Error: ORA-01427 When Running Endeca Inv-item Full Load In Clover

(Doc ID 2226166.1)

Last updated on JANUARY 24, 2017

Applies to:

Oracle Item Master - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Item Endeca Integration (v5 and lower)

When attempting to run the inv-item full load config.grf graph in clover,
the following error occurs.

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

“ORA-01427: single-row subquery returns more than one row"

Execution of graph './graph/Impl/LoadDataFull.grf' failed!
Component [Run DataDeNormalizer:RUN_DATA_DE_NORMALIZER] finished with status ERROR.
Execution of graph './graph/Impl/DataDeNormalizer.grf' failed!
Component [Read Item Org Grain Data:READ_ITEM_ORG_GRAIN_DATA] finished with status ERROR.
ORA-01427: single-row subquery returns more than one row

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