Invoice Number Skipping Problem
When you set the Automatic Invoice Numbering to Yes while
defining the batch source. Sometime invoice numbers are skipped by 20 instead
of sequencial numbering. This happens due to Oracle Application creating
the automatic number
To minimize this change the sequences used to generate
Invoice Numbers to not use caching. This can be done via a SQL statement
such as:-
To find out the batch_source_id query the table
SELECT batch_source_id
But setting the NOCACHE option affect the performance of Invoice entry in very high volume situations.
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|