How To Create Automatic Transaction Numbering Sequence for Transaction Batch Source Always with Nocache option?
Last updated on MARCH 21, 2017
Applies to:Oracle Receivables - Version 18.104.22.168 and later
Information in this document applies to any platform.
RAXSUMSC Transaction Batch Sources Form
ARXTWMAI Transactions Form
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 ?
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