Unable to Import Or Enter Sale order-ora-20001:app-fnd-01564:oracle error-1422 in Get_seq_info

In this Document

Symptoms

Cause

Solution

Applies To:Oracle Order management-version 12.0.4 to 12.1.3 [Release 12.0 to 12.1]
information in this document applies to any platform.



Symptoms

When attempting to either import a sales order, or enter a sales order from the Sales order form, the following errors OCC ur

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 the requested number of rows.
The SQL statement being executed at the time of the error WAS:SEQ. doc_sequence_id, SEQ. TYPE, Seq.name...and is executed from the file Afsqnumb.pls in package Oe_header_util Procedure Get_order_number.1

user-defined Exception in package oe_header_util Procedure pre_write_process

Cause

There is duplicate Document sequences defined.

Solution

1. Go into the Responsibility:order Management Super User responsibility.

2. Navigate to Menupath > Setup > Documents > Assign

3. Query up the Application:order Management, and the Category at issue.

4. End Date the duplicate Document Sequence.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

Unable to Import Or Enter Sale order-ora-20001:app-fnd-01564:oracle error-1422 in Get_seq_info