My Oracle Support Banner

Sequential Numbering Error Creating An Order From Istore (Doc ID 262373.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle iStore - Version 11.5.9 to [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.


Creating an order in iStore, the following eror shows up:

Error messages from Order Management
ORA-20001: An assignment does not exist for these parameters and one is  mandatory.
Cause: The profile option Sequential Numbering is defined to have sequential numbering always used. The current set of parameters does not have a  sequence assigned.
Action: Go to the Assign Sequences screen and assign a sequence to  the current set of parameters. in Package OE_Header_Util Procedure Get_Order_Number User-Defined Exception in Package OE_Header_Util Procedure Pre_Write_Process
There is an error in order submission.


To view full details, 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 a vibrant support community of peers and Oracle experts.