Transactions Workbench Issue: Datafix: Unable To Post The Credit Memos To GL

(Doc ID 2058157.1)

Last updated on JANUARY 14, 2016

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms