MSCPDCW - ODS Load completes in Warning With User-Defined Exception in Load_Supply. Error ORA-01403: no data found (Doc ID 1616072.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

When attempting to run collections the following warning  occurs.

MSCPDCW module: Planning ODS Load Worker

19-JAN 13:45:25 : Procedure MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY started.
19-JAN 13:45:25 : load_supply
19-JAN 13:45:26 : OTHER========================================
19-JAN 13:45:26 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
19-JAN 13:45:26 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=CG
19-JAN 13:45:26 : COLUMN=ORGANIZATION_CODE, VALUE=VAL:KIN
19-JAN 13:45:26 : COLUMN=ORDER_TYPE, VALUE=Purchase order
19-JAN 13:45:26 : User-Defined Exception




STEPS
-----------------------
Advanced supply chain planner
1. run 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