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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.