R12:CE Payment In AP Not Available For Reconciliation In Cash Management (Doc ID 2125400.1)

Last updated on OCTOBER 16, 2017

Applies to:

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

Symptoms

Payable Payment is not available for Reconciliation against a Bank Statement.
The Payment is Negotiable in Payables, but unable to find the Payment in Cash Management to Reconcile.


STEPS
The issue can be reproduced at will with the following steps:


1.) Navigate ->  Bank Statements -> Bank Statements and Reconciliation
2.) Query the Bank Statement and the Bank Statement Line that is Unreconciled.
3.) Select Find Transactions and try to Find the Payment Number

 

1 -  For the associated Payment, run the Aplisth.sql diagnostic report .

2 -  For the associated Bank Statement Line, run the Celisth.sql diagnostic report.

3 -  Run the following queries against the tables in CE to see the bank statement lines the payment has been reconciled with.

     Substitute the REFERENCE_ID with the CHECK_ID of the Payment.

     Select * from CE_STATEMENT_RECONCILS_ALL
     where REFERENCE_ID = 439202
     and REFERENCE_TYPE = 'PAYMENT
     order by statement_line_id , creation_date ;

     Select * from CE_STATEMENT_LINES
     where statement_line_id in (Select h.statement_line_id from CE_STATEMENT_RECONCILS_ALL h
     where h.reference_type = 'PAYMENT' and h.reference_id in (439202)) ;

     Select * from CE_STATEMENT_HEADERS
     where statement_header_id in (Select l.statement_header_id from CE_STATEMENT_LINES l
     where l.statement_line_id in (Select h.statement_line_id from CE_STATEMENT_RECONCILS_ALL h
     where h.reference_type = 'PAYMENT' and h.reference_id in (439202))) ;

 4 - Upload the following to the SR.

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