R12: AP/IBY/CE: A Case in Which Document Num Column Values in the Payment Workbench Form Suddenly/Unexpectedly Overlap for a Given Internal Bank Account (Doc ID 2081336.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Oracle Cash Management - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

An example case:

The business uses a single disbursement bank account to process AP invoice payments as printed checks and as ACH payments.
Users suddenly noticed (without any related warning or error message during payment processing) an unexpected overlap in the numbers assigned to printed checks and ACH payments.
That overlap is causing issues for users, for example when trying to research and reconcile payments.
Note that the checks get formatted using check stock stationary that is pre-printed with the check numbers sequence, so the business cannot change the existing setup in Oracle for check numbering.
The business would like to change the numbering for ACH payments, yet it is not clear what setup controls the ACH payment numbering at present.
The business can not do any additional payments from this bank account until we can adjust the numbering sequence so it is someone of an urgent issue.

Why is that overlap occurring?  And what can be done to resolve / prevent it going forward?

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