R12/CE: Payment Showing Reconciled In Payables But Not Reconciled In Cash Management
Last updated on APRIL 06, 2017
Applies to:Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.
Payment shows as reconciled in AP, but shows as Unreconciled in CE.
Transaction Date: 03/01/2017
1. Two Payments of amount: 354.1 and 2500 are RECONCILED against a STATEMENT_LINE_ID:2292068 of amount: 354.1 only:
Reconciliation trail in ce: CE_STATEMENT_RECONCILS_ALL
STATEMENT_LINE_ID REFERENCE_TYPE REFERENCE_ID LAST_ ORG_ID STATUS_FLAG CURRENT_RECORD_FLAG AMOUNT
2292068 PAYMENT 3710177 09-MAR-2017 10:16 7051 M Y 354.1
2292068 PAYMENT 3716038 09-MAR-2017 10:30 7051 M Y 2500
2. CE LINE:
STATEMENT_LINE_ID STATEMENT_HEADER_ID LINE_NUMBER TRX_DATE TRX_TYPE AMOUNT STATUS TRX_CODE BANK_TRX_NUMBER
2292068 309578 53 01-MAR-2017 00:00 DEBIT 354.1 RECONCILED 475 3000062071
2292034 309578 19 01-MAR-2017 00:00 DEBIT 2500 UNRECONCILED 475 3000062300
3. As per line only one Payment of amount 354.1 should have been reconciled against this line but two payments were reconciled.
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