How To Create Automatic Transaction Numbering Sequence for Transaction Batch Source Always with Nocache option? (Doc ID 428561.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
RAXSUMSC Transaction Batch Sources Form
ARXTWMAI Transactions Form


Goal

NAV Receivables --> Setup -->  Transactions --> Sources
When setting Automatic Transaction Numbering for Transaction Batch Sources the database sequence generated has default cache size of 20.
This result in sequence number skipped.
Workaround is to alter sequence after sequence has been created in the database
How to create sequences by default with nocache for all new Transaction Batch Sources with Automatic Transaction Numbering checked ?

Solution

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