Complementary Invoices Program Error - REP-1419: MSG-00096: SELECT RA_TRX_NUMBER__86_S.NEXTVAL INTO:CP_SEQ_NUMBER

(Doc ID 1612655.1)

Last updated on MARCH 15, 2018

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Oracle Financials for the Americas - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

You are attempting to generate a Complementary Invoice in Receivables and receive the following error:

REP-1419: MSG-00096: SELECT RA_TRX_NUMBER__86_S.NEXTVAL INTO:CP_SEQ_NUMBER

What source does a Fiscal partner use to identify the parent invoice information of a complementary invoice and of a canceled invoice?

INFORMATION ABOUT PARENT INVOICE OF COMPLEMENTARY INVOICES IN AR
For a Transaction Batch Source the Complimentary Invoice is not following the same sequential transaction numbering as the parent invoice.

Currently, the partner system uses the same field (Previous_Customer_Trx_Id from ra_customer_trx_all table) to reference the parent invoice of the both types of invoice.
Thus, to generate a complementary invoice in AR, it is issuing the error in the payment table.
The system is assuming that it is a cancellation invoice.

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