Incremental Load Graph Is Failing ORA-00918: Column Ambiguously Defined (Doc ID 2071860.1)

Last updated on DECEMBER 01, 2015

Applies to:

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

Symptoms

On : 12.2.4 version, Endeca Integration (v5 and lower)

After application of <Patch:21903282:R12.ONT.C>  When attempting to run Incremental load graph the following error occurs.


ERROR
-----------------------
‘Graph execution finished with error
2015-10-07 13:38:19,903 ERROR 295436 [WatchDog] Node READ_FULFILL_DELAY_RECORDS_FROM_DB finished with status: ERROR caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously define

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Incremental load graph on V5 version of endeca.


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