My Oracle Support Banner

Brazil Sequence Issue: The Invoice Numbering Skips (Doc ID 1551657.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

In Brazil Localizations, when an invoice is rejected by Autoinvoice program, for invalid data, the invoice number skips sequence numbers.            

Changes

A separate sequence is created for Brazil.

For newly created batch sources, the sequence will be automatically created.

For existing batch sources, users have to run the script: jl8982308.sql

The sequence will be of the form:
          'JL_BR_TRX_NUM_'||to_char(p_batch_source_id)'_' ||p_org_id  || '_S'
where p_batch_source_id is the batch source id of the imported transaction batch source used for AutoInvoices, and p_org_id is the org_id attached to the responsibility.

There is no provision to see the next value of the newly created sequence from Applications. If users want to verify the next value of this sequence, he can execute the following query:

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