R12/CE: Payment Showing Reconciled In Payables But Not Reconciled In Cash Management (Doc ID 2252465.1)

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.

Symptoms

Payment shows as reconciled in AP, but shows as Unreconciled in CE.

For example
Type: Payment
Number: 3000062300
Transaction Date: 03/01/2017
Amount:2500.00
Amount Reconciled:
Status: Unreconciled

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:
CE_STATEMENT_LINES
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.

Cause

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