RR12 Project Billing Invoices have corrupt data in Receivables

(Doc ID 2012954.1)

Last updated on AUGUST 01, 2016

Applies to:

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


On : 12.1.3 version, Interface Invoices to Receivables

The Subledger Accounting Program Report is showing that Exchange Gain/Loss Accounting entry is created for specific credit memos even when the application is of the same currency and/or exchange-rate. Additionally the PATTAR PRC: Interface Invoices to Receivables is populating the RA_INTERFACE_LINES_ALL table Amount = 0 and accounted_amount <> 0.

The exchange gain/loss accounting is not supposed to be generated, because the credit memo and the original AR transaction used the same currency and the same rate.

The issue can be reproduced at will with the following steps:
1. Create and invoice and interface it to Receivables
2. Cancel the invoice and create a credit memo
3. Interface the Credit Memo to Receivables
4. Run the Receivables Transaction data collection script and the RA_INTERFACE_LINES_ALL table shows the mismatches in the fields.


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