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 11.5.10.2 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


Symptoms

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.

STEPS
-----------------------
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

Changes

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

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
Changes
Cause
Solution
 Still Have Questions?
References


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