My Oracle Support Banner

R12.1:CE: How To Update BANK_TRX_NUMBER Field In CE_STATEMENT_LINES Table? (Doc ID 2363755.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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

Goal

Can the BANK_TRX_NUMBER field be updated directly in the CE_STATEMENT_LINES table with the payment number by executing a script and then execute the concurrent "AutoReconciliation"?

There is an invoice payment process that controls the bank.
The bank first sends the bank statement file and later sends the invoice payment file.
The users daily load the bank account statement and in this process they relate the payment number, but in this case the payment has not been generated.

They change the order of the process, first generate the payment and then load the bank account statement.
This process has already been controlled for future payments. However, there are 16,000 lines not reconciled.

They are identifying payments and bank statement lines not reconciled with the concurrent "Transactions Available for Reconciliation Report" in Cash Management. 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.