R12: AP/IBY/CE - What Allowed a Second Payment to be Created with the Same Number as a Prior Payment, Both for the Same Disbursement Bank Account?

(Doc ID 2191647.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2 [Release 12 to 12.2]
Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Oracle Payments - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Goal

When the user was processing Quick Payment: ID=857065 last week, the user mistakenly chose the Payment Document named "USD Manual Payment", when they were supposed to use the other Payment Document named "CAN XML Format Payment (USD) R12".  Both Payment Document setups are defined under the same disbursement bank account.
.
That Quick payment ended up getting numbered 20241, which corresponded to the Next Available Document Number from the Payment Document "CAN XML Format Payment (USD) R12", whereas the next check number to be defaulted from Payment Document "USD Manual Payment" would have been 1128.
.
Yet, since the user manually overrode the defaulted check number 1128 value and saved the Quick payment with check number 20241, the Last Issued Document Number on the "USD Manual Payment" Payment Document setup has jumped forward to be "20241" instead of "1128".
.
Q1) Is this supposed to happen?
.
Q2) Should the Quick payment not have taken the sequence number from the payment document chosen on the form?
.
Q3) As a corrective measure, can the user manually update the Last Issued Document Number in the setup of Payment Document "USD Manual Payment" to restore the correct/intended value of 1127 instead of the unintended actual value of 21241?  Will doing so cause any future problems?

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