Reference Number
The format of Reference Number in Oracle Banking Payments is a 16 digit number.
On any new operation on screen, the transaction reference number is generated as explained in the below table.
| Component | Description | Digits | Position, Length | Sr. No. |
|---|---|---|---|---|
| Year | Last 2 Digits of the Year | 2 | 1, 2 | For e.g. 2017 = 17 |
| Date | Julian Date | 3 | 3, 3 | For e.g. 1st February = 032 |
| Server Id |
If clustered, each app server will have a number. This is setup as a JVM Parameter by Infra Team |
2 | 6, 2 | For e.g 1 App Server = 01 |
| PM Type | Each Sub-Module in PM represents a Type | 1 | 8, 1 |
ACH - 1 XBORDER & RTGS - 3 BOOKTRANSFER -4 DD - 5 Clearing - 6 FASTER PAYMENTS – 7 C2B - 8 |
| Seconds |
Seconds Elapsed past date change 1 Minute = 00060 Seconds 1 Hour = 03600 Seconds 24 Hours = 86400 Seconds Left Padded with 0s |
5 | 9, 5 | For e.g. If time is 18:00 as per the host date then Seconds will be calculated as 64800. |
| Serial Number |
Sequential Serial Number generated per second Sequence Resets to 0000 for every Second |
3 | 14, 3 |
For e.g. Seconds and Serial Number Representation for 5 Transactions processed @ 18:00 648000001 - 64800004 64800 – Seconds001 – Serial Number 002 – Serial Number 003 – Serial Number 004 – Serial Number |
Other Reference Number like Queue Reference Number, File reference, etc.
| Component | Description | Digits | Position, Length | S.No |
|---|---|---|---|---|
| Year | Last 2 Digits of the Year | 2 | 1, 2 | For e.g. 2017 = 17 |
| Date | Julian Date | 3 | 3, 3 | For e.g. 1st February = 032 |
| Server Id |
If clustered, each app server will have a number. This is setup as a JVM Parameter by Infra Team |
2 | 6, 2 | For e.g 1 App Server = 01 |
| Seconds |
Seconds Elapsed past date change 1 Minute = 00060 Seconds 1 Hour = 03600 Seconds 24 Hours = 86400 Seconds Left Padded with 0s |
5 | 9, 5 | For e.g. If time is 18:00 as per the host date then Seconds will be calculated as 64800. |
| Serial Number |
Sequential Serial Number generated per second Sequence Resets to 0000 for every Second |
3 | 14, 3 |
For e.g. Seconds and Serial Number Representation for 5 Transactions processed @ 18:00 648000001 - 64800004 64800 – Seconds001 – Serial Number 002 – Serial Number 003 – Serial Number 004 – Serial Number |
Parent topic: Common Processes