My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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