Learn Oracle Applications Tech-Stack: How To Link AR Receipt With Bank Statement

Wednesday 27 February 2019

How To Link AR Receipt With Bank Statement

SELECT CASH_RECEIPT_ID
FROM FUSION.AR_CASH_RECEIPTS_ALL
WHERE RECEIPT_NUMBER = '&RECEIPT_NUMBER'
AND RECON_FLAG = Y;

SELECT RECON_HISTORY_ID
FROM FUSION.CE_RECON_HISTORY_ITEMS
WHERE RECON_SOURCE = 'AR'
AND SOURCE_ID = '&CASH_RECEIPT_ID';

SELECT STATEMENT_HEADER_ID
FROM FUSION.CE_STATEMENT_LINES
WHERE RECON_HISTORY_ID = '&RECON_HISTORY_ID';

SELECT STATEMENT_NUMBER

FROM FUSION.CE_STATEMENT_HEADERS

WHERE STATEMENT_HEADER_ID = '&STATEMENT_HEADER_ID';

Mapping of Transactions from Cash Management to AP/AR

Lets Say we have a record in

1. query CE_STATEMENT_HEADERS ->
2. query CE_STATEMENT_LINES -> get recon_history_id
3. query CE_RECON_HISTORY_ITEMS -> provide recon_history_id, and get source id -> sourec_id = check_id (ap), and sourec_id = cash_receipt_id (AR)