Autoinvoice Issue: AutoInvoice Generates Incorrect (Duplicate) Transaction Numbers After Patch 10628769
Last updated on AUGUST 25, 2017
Applies to:Oracle Receivables - Version 220.127.116.11 and later
Information in this document applies to any platform.
Checked for relevance on 11-Jul-2013
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 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
Applied <Patch 10628769> and ran the post requirement jl8982308.sql
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