Bills Receivable Remittance: The AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER) Needs to be Used Instead of Invoice ID (RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID) in AR Bill Remittance (RIBA) Format For Italy

(Doc ID 1541168.1)

Last updated on JULY 12, 2016

Applies to:

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

Symptoms

Customer is using latest version of IBYC_BR_IT_en.rtf is 120.3.12010000.7 from patch 15883694:R12.IBY.B.

This is being used in conjunction with AR Bills Receivable (BR) Remittance.

The AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER) needs to be used, instead of Invoice ID (RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID) that is used by IBY.

Receivables doesn't use the Invoice ID in Bills Receivable and the transaction number is only available in Oracle front end.

Currently Documents data is populated from GT tables (IBY_AR_DOC_HEADER_GT).

The query to insert data into IBY_AR_DOC_HEADER_GT for BR is as follows:

Thus, the data is being passed from AR as NULL.

IBY forms extract from the data in GT table. Hence, this fix needs to be done in AR.

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