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

Last updated on JUNE 08, 2016

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

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

Cause

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