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 FEBRUARY 24, 2019
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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!