18524104 ODS Load Worker Is Failing With ORA-01427: Single-row Subquery Returns More Than One Row (Doc ID 1667611.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

On : 12.1.3.9 version, Data Collections

When attempting to run collections the following error occurs.

ERROR
-----------------------

MSCPDCW module: Planning ODS Load Worker
+---------------------------------------------------------------------------+

03-APR 00:22:12 : MSC_DL_TASK_START_PARTIAL (PROCEDURE=MSC_CL_OTHER_ODS_LOAD.LOAD_SOURCING)
03-APR 00:22:12 : ORA-01427: single-row subquery returns more than one row
03-APR 00:22:12 : ORA-01427: single-row subquery returns more than one row



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Advanced supply chain planner
1. run legacy 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