Invoices Imported From Projects Have Corrupt ACCTD_AMOUNT in GLDIST Table (Doc ID 2131650.1)

Last updated on AUGUST 29, 2016

Applies to:

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

Symptoms

Transactions and Credit Memos are being created with corrupted data from Projects.  In Projects, Invoice ACCTD_EXCHG_RATE Corrupts RA_INTERFACE_DISTRIBUTIONS_ALL.ACCTD_AMOUNT.

Both header and line information is imported from Projects not generated by Receivable Auto Accounting.

 

Typical scenario is displayed below:

 

Example of 0.00 Transaction, with exchange_rate = 1.302

 

CUSTOMER_TRX_LINE_ID PERCENT CLASS AMOUNT ACCTD_AMOUNT
12345 100 REV 1500.00 1951.03
12345 0 REV 0 1.97
12346 100 REV 100.00 128.00
12346 0 REV 0 2.21
12347 100 REV -1600.00 -2081.00
12347 0 REV 0 -2.2
  100 REC 0 .01

 

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