DATAFIX To Avoid Duplicate Document Sequence Assignment Records Caused by User Incorrect Setup (Doc ID 2273929.1)

Last updated on MAY 19, 2023

Applies to:

Symptoms

When attempting to save order header  or go to lines tab, the following error occurs.

Error

ORA-20001: APP-FND-01564: ORACLE error - 1422 in get_seq_info

  Cause: get_seq_info failed due to ORA-01422: exact fetch

  returns more than requested number of rows.

  The SQL statement being executed at the time of the error

  wa: select SEQ.DOC_SEQUENCE_ID, SEQ_TYPE, SEQ_NAME... and

  was executed from the file AFSQNUMB.pls. in Package

  OE_Header_Util Procedure Get_Order_Number

Steps

The issue can be reproduced at will for a new sales order with following steps below

1. Log  into Oracle Applications
2. Go to Order Management Super User Responsibility
3. Navigate to MENUPATH > Orders, Returns
4. Open the Sales Order Form
5. Enter the Order Header details.
6. Navigate to line items tab, enter line details and SAVE. Error mentioned above is displayed on the form

Changes

Cause

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