My Oracle Support Banner

Error: ORA-01427 When Running Endeca Inv-item Full Load In Clover (Doc ID 2226166.1)

Last updated on JUNE 15, 2021

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.