Error While Loading Sourcing Rule In Legacy Self Service Load (Doc ID 1631209.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Data Collections

When attempting to run MSCPPW module: MSC Pre Process Worker,
the following error occurs.

ERROR
-----------------------
Pre-processing program succeeded.
.
.
G_IN_PROCESS after2
lv_sql_stmt after67UPDATE MSC_ST_ITEM_SOURCING t1 SET INVENTORY_ITEM_ID = (SELECT distinct local_id FROM msc_local_id_item t2 WHERE t2.char1 = t1.sr_instance_code AND NVL(t2.char2, '-23453')= NVL(t1.company_name,'-23453') AND t2.char4 = t1.ITEM_NAME AND t2.entity_name = 'SR_INVENTORY_ITEM_ID' AND t2.instance_id = :p_instance_id) WHERE sr_instance_code = :p_instance_code AND NVL(batch_id,-23453) = :p_batch_id AND process_flag = 2
lfinal block MSC_ST_UTIL.DERIVE_ITEM_ID(6)ORA-01427: single-row subquery returns more than one row
lv_error_textMSC_ST_UTIL.DERIVE_ITEM_ID(6)ORA-01427: single-row subquery returns more than one row
lv_message_textThe value provided for ITEM_NAME is invalid. Please resubmit this record with a valid value for ITEM_NAME.
12-NOV 09:40:36 : MSC_ST_UTIL.DERIVE_ITEM_ID(6)ORA-01427: single-row subquery returns more than one row
12-NOV 09:40:39 : 1.5 minutes elapsed.



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