My Oracle Support Banner

Transactions Workbench Issue: Datafix: Unable To Post The Credit Memos To GL (Doc ID 2058157.1)

Last updated on JULY 19, 2019

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.


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.

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!

In this Document
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.