Workflow 'WIP: Shipping & Receiving Intermediate' In Error (Doc ID 2140948.1)

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.

Symptoms

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
-----------------------
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)


STEPS
-----------------------
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.


Cause

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