My Oracle Support Banner

ORA-20001 "APP-FND-01702" "APP-FND-01728" When Entering Sales Order, Quotes, Sales Agreement (Doc ID 2031743.1)

Last updated on OCTOBER 26, 2020

Applies to:

Oracle Order Management - Version 12 and later
Information in this document applies to any platform.

Symptoms

Problem Statement

  1. Sales Agreement: When attempting to enter a new Sales Agreement with Sales Agreement Type = XXX the following error occurs.
  2. Sales Order: When attempting to create new order transaction type the following error occurs.
  3. When attempting to create a quote, the following error occurs.
  4. Order Import fails due to the following error.

Error

Depends on profile value the following error message is shown.

Profile : Sequential Numbering

Partially Used

APP-FND-01728 An assignment does not exist for these parameters.

Always Used

APP-FND-01702 An assignment does not exist for these parameters and one is mandatory.

Error Details are depends on the type.

  1. Cause: An attempt was made to find a sequence for this document flexfield.
    The profile option says Sequential Numbering is only partially used.
     
    Action: None is necessary unless you expected this document flexfield to have
    a sequence defined. in Package OE_Blanket_Util Procedure Get_Order_Number
  2. 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
    0E_Header_Util Procedure Get_0rder_Number
  3. Cause: An attempt was made to find a sequence for this document flexfield
    The profile options says Sequential Numbering is only partially used.
    Action: None is necessary unless you expected this document flexfield to have a sequence defined in Package OE_Header_Util Procedure Get_Order_Number

    User Defined Exception in Package OE_Header_Util Procedure Pre_Write_Process
  4. Cause: An attempt was made to find a sequence for this document flexfield. The profile option says
    Sequential Numbering is only partially used.
    Action: None is necessary unless you expected this document flexfield to have a sequence defined.
    in Package OE_Header_Util Procedure Get_Order_Number

Steps to Reproduce

  1. Enter a new sales agreement with Sales Agreement Type = XXX
  2. Enter a new sales order
  3. Enter a new quote
  4. Create order via Order Import

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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