Submit Quote to Order Error: "ORA-20001: APP-FND-01728: An assignment does not exist for these parameters"
Last updated on FEBRUARY 05, 2018
Applies to:Oracle Quoting - Version 188.8.131.52 and later
Information in this document applies to any platform.
OE_Header_Util Procedure Pre_Write_Process
When converting the quote (that contains a newly defined 'Order Type' ) into a Sales Order an error is returned.
ORA-20001: APP-FND-01728: An assignment does not exist for these parameters.
Cause: An attempt was made to find a sequence for this document flexfield. The profile option says Sequential Numbering is only partially used.
There is an error in order submission.
Steps to Reproduce
The issue can be reproduced at will with the following steps:
Setup: Document Sequencing is switched on for Oracle Order Management. Sequencing is based on 'Order Type'.
- Create a quote with a newly defined Order Type
- Submit the Quote to create a Sales Order
- Error is returned
- ORA-20001: APP-FND-01728: An assignment does not exist for these parameter
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms