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.
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 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.
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order Book Order:8144471
3. Observe Error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!