Link between Bank Statement line and Transactions for Group of Manual Reconciliation.
We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to retrieve a group of multiple statement lines against a group of manual reconciled multiple system transactions, there is a duplication of rows for each statement when recon_history_id is same for multiple transactions for multiple statement lines. Any guidance on how to avoid the duplication of rows when linked with group of multiple transactions. Any source or unique reference would be greatly appreciated.
Tagged:
0