R12.1:CE: How To Update BANK_TRX_NUMBER Field In CE_STATEMENT_LINES Table?
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.
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.
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