My Oracle Support Banner

Autoinvoice Issue: AutoInvoice Generates Incorrect (Duplicate) Transaction Numbers After Patch 10628769 (Doc ID 1347151.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Receivables - Version and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


After applying the <Patch 10628769> and running the post requirement jl8982308.sql, the invoice sequences are wrong and repeated. The file jl8982308.sql creates new sequences with the name JL_BR_TRX_<Batch_source_id_org_id>.

For manual invoices, the system uses values from the sequence JL_BR_TRX_<Batch_source_id_org_id>.
For Autoinvoice invoices, the system uses values from the sequence RA_TRX_NUMBER_<Batch_source_id_org_id>.

Depending on how the transaction is created, you end up with "repeated" or duplicate numbers.

The issue can be reproduced at will with the following steps:
Create an invoice manually:
Invoice 1234 for 1000 BRL
Source XXX Source

Create an invoice using Autoinvoice
Invoice 1234 for 18.24 BRL
Source XXX Source

Both invoices have the same trx_number = 1234


Applied <Patch 10628769> and ran the post requirement jl8982308.sql


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
 Still Have Questions?

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