MSCPDCW Planning ODS Load Worker fail with ORA-01422 when running Net Refresh Mode (Doc ID 337224.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.

Symptoms

Running data collections in a Net Refresh Mode in ASCP is erroring as follows:

MSC_DL_TASK_START_PARTIAL (PROCEDURE=LOAD_SALES_ORDER)
Calling Linking of Sales Order for 11i source ...
MSC_DL_TASK_START_PARTIAL (PROCEDURE=LINK_SUPP_SO_DEMAND_11I2)
==========================================================
Starting LINK_SUPP_SO_DEMAND_11I2 ......
Supply table is: MSC_SUPPLIES
==========================================================
Error: ORA-01422: exact fetch returns more than requested number of rows
Error: ORA-01422: exact fetch returns more than requested number of rows
...
...
Error: ORA-01422: exact fetch returns more than requested number of rows
.2 minutes elapsed.
Linking of Sales Order line to its Parent Sales orders is successful.....
202.3 minutes elapsed.
User-Defined Exception
Sending message :-9999999 to monitor.

Navigation Path:
Supper USer => Collections => Oracle systems => Standard collections

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