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.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Still Have Questions?
References

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