Workflow 'WIP: Shipping & Receiving Intermediate' In Error
Last updated on MARCH 08, 2017
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, SUPPORT
When attempting to Move job to the OSP operation, the work flow 'WIP: Shipping & Receiving Intermediate' has
the following error occurs.
Error Name -1422
Error Message ORA-01422: exact fetch returns more than requested number of rows
Error Stack WIP_OSP_SHP_I_WF.StartDetailProcesses(WIPISHPW, 682632) Wf_Engine_Util.Function_Call(wip_osp_shp_i_wf.WaitforReqImport, WIPISHPW, 682632, 333446, RUN)
The issue can be reproduced at will with the following steps:
1. Create WIP Job with OSP operation.
2. Move job to the OSP operation.
3. Requisition Import program triggers to create Requisition but the work flow 'WIP: Shipping & Receiving Intermediate' errors out.
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 hundreds of Community platforms