Complementary Invoices Program Error - REP-1419: MSG-00096: SELECT RA_TRX_NUMBER__86_S.NEXTVAL INTO:CP_SEQ_NUMBER
Last updated on MARCH 15, 2018
Applies to:Oracle Receivables - Version 18.104.22.168 and later
Oracle Financials for the Americas - Version 22.214.171.124 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms