My Oracle Support Banner

EBS Endeca Extensions ONT Error (Doc ID 2339906.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to implement EBS 12.2.3 and Endeca V5 the following error occurs when trying to run a Full Data Load for ONT on EBS Endeca Extensions.

ERROR
Endeca Integration
Running Full Data Load graph for ONT on Clover integrator
Trying to run a Full Data load for ONT on EBS Endeca Extensions, why is the following error occurring?

2017-07-18 00:08:12,488 ERROR 28710 WatchDog Node READ_FROM_DB_VIEW_OE_ENDECA_RETURNS_V error details:
org.jetel.exception.JetelException: SQLException when reading resultSet: ORA-01427: single-row subquery returns more than one row
caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

STEPS
1. Run > Full Data Load graph for ONT on Clover integrator
2. Full Data load for ONT on EBS Endeca Extensions
3. Observe Error

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!


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