Transactions Workbench Issue: Datafix: Unable To Post The Credit Memos To GL
(Doc ID 2058157.1)
Last updated on JULY 19, 2019
Oracle Receivables - Version 12 and later Information in this document applies to any platform.
Issue: ====== When attempting to run Create Accounting Credit Memos and Adjustments fail with error because of negative exchange rates.
The problem with the credit memo/adjustment distributions is that the distributions are generated with the same corruption as the transactions they are applied against. The original transactions are posting with the corrupt acctd_amount rows because overall the table is balanced. The credit memos and adjustments are not balancing and fail.
Analysis: ======= The acctd amounts are wrongly populated in ra_cust_trx_line_gl_dist_all and the ar_distributions tables.
Fix Approach: ============ 1. Undo Accounting has to be done. 2. The acctd_amount has to be corrected in ra_cust_trx_line_gl_dist_all (GLD) and ar_distributions (ARD) Tables.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!