My Oracle Support Banner

Unable to Book the Sales Order Due to Error Ora-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 2431355.1)

Last updated on AUGUST 03, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Transaction Entry

Unable to Book the Sales order due to below error message.
We are unable to book the SO's getting below error.

 
ERROR
Error Message ORA-01422: exact fetch returns more than requested number of rows
Error Stack Wf_Engine_Util.Activity_Parent_Process(280613) Wf_Engine_Util.Process_Activity(OEOH, 9735338, 280613, 50)
Wf_Engine.HandleErrorInternal(OEOH, 9735338, GEPS_BOOK_PROCESS_ASYNCH:BOOK_ELIGIBLE, RETRY)
Warning List: 51. Incorrect WorkFlow Process associated to this Order Header.

STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order Book Order:8144471
3. Observe Error
 

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!


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