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

Last updated on AUGUST 25, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 11-Jul-2013
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 2916 for 1000 BRL
Source SED-NF ELECTRONICA SAIDA MANUAL

Create an invoice using Autoinvoice
Invoice 2916 for 18.24 BRL
Source SED-NF ELECTRONICA SAIDA

Both invoices have the same trx_number = 2916

Changes

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

Cause

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