R12: Why Aren't the Document Number and Voucher Number Assigned in the Same Order in a Payment Batch ? (Doc ID 2249137.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Payments - Version 12.0.1 and later
Information in this document applies to any platform.

Goal

In Payment Process Profile set the "Payment Sorting" to sort by "Payee Number" - Ascending. However this setting does not does not sort the Payment Batch by Document Number and Voucher Number. Why payment batch does not assign the Voucher number in sequence as Document Number ?

 

E.g. The extract shows the voucher number and the document number in this order:

Voucher Number  Document Number
89734               10860
89735               10861
89736               10864
89737               10865
89738               10866
89739               10859
89740               10858
89741               10867
89742               10863
89743               10862

And expected ordering is
89734               10858
89735               10859
89736               10860
89737               10861
89738               10862
89739               10863
89740               10864
89741               10865
89742               10866
89743               10867


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms