My Oracle Support Banner

Transactions Are Using Transaction Number Sequence Even When Not Saved (Doc ID 1908872.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


You are entering a Transaction Header and navigate to the Lines form (click on Line Items button) and the system allocates the transaction number (ie. 1), based on the next number from the Batch Source.  

At this point, the system message is

FRM-40404: Database apply complete: 1 records applied

However, if you then exit the form and say 'No' to the 'Save Changes' message, the whole Transaction and header information is discarded. 

The next time you enter an Invoice, the next number in the sequence (ie. 2) is allotted. The earlier invoice number 1 is lost.

If you give a query for the Invoice Number 1, the system says 'Query Caused No Records to be Retrieved.'




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
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.