Complementary Invoices Program Error - REP-1419: MSG-00096: SELECT RA_TRX_NUMBER__86_S.NEXTVAL INTO:CP_SEQ_NUMBER
Last updated on JULY 31, 2017
Applies to:Oracle Financials for the Americas - Version 188.8.131.52 and later
Oracle Receivables - Version 184.108.40.206 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms