R12/CE: Unreconciled Payment & Receipt Is not On the General Ledger Reconciliation Report - Oracle EBS R12

https://cashmanagementcm.blogspot.com/2019/04/r12ce-unreconciled-payment-receipt-is.html

This report shows how your bank position Reconciles to your General Ledger for a requested period. It compares your bank position to your General Ledger position and lists your total reconciled and unreconciled statement line amounts in Cash Management, indicating any discrepancies in your cash position.

This report will not be accurate unless you first reconcile all statements in Cash Management, transfer journal entry transactions from Oracle Payables and Oracle Receivables to your General Ledger, then post journals in General Ledger.

Warning: The Data in Cash Bank Account must be Posted in GL. Make Sure it is not a Clearing Account.

--------------------------------------------------------------------------------------------------------------------------

Payment or Receipt not appearing in the Report which were reconciled and then un-reconciled in the Report period.


select * from ap_checks_all
where check_Number in ('39841665','39841660')

CheckNumber = ('39841665','39841660')
CheckId = (75638 ,75609)


select * from CE_STATEMENT_RECONCILS_ALL --statement line id =118312
where REFERENCE_ID in (75638 , 75609) --Check_Id or Receipt_Id
and reference_type ='PAYMENT'


createtable CE_STATEMENT_RECO_ALL_BKP
asselect * from CE_STATEMENT_RECONCILS_ALL
where REFERENCE_ID in (75638 , 75609) --Check_Id or Receipt_Id
and reference_type ='PAYMENT'


delete from CE_STATEMENT_RECONCILS_ALL
where REFERENCE_ID = 75638 --Check_Id or Receipt_Id
and reference_type ='PAYMENT'


delete from CE_STATEMENT_RECONCILS_ALL
where REFERENCE_ID = 75609 --Check_Id or Receipt_Id
and reference_type ='PAYMENT'

--------------------------------------------------------------------------------------------------------------------------

CE_STATEMENT_RECONCILS_ALL:

The CE_STATEMENT_RECONCILS_ALL table stores information about reconciliation history or audit trail. Each row represents an action performed against a statement line.