WIP Mass Load Completes In Warning With ERROR

(Doc ID 2421556.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Work in Process - Version 11.5.10.2 to 12.2.7 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run the WIP Mass Load, the following error occurs.

ERROR

"Error: WIPJDLDB load all details ORA-01422: exact fetch returns more than requested number of rows"


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility = Work In Process (WIP)
2. Navigation = Discrete-> Import Job and Schedules
3. launch WIP Mass Load for a group_id



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