Incremental Load Is Getting Failed in ONT Endeca Extensions in Endeca V5 (Doc ID 2086340.1)

Last updated on DECEMBER 11, 2015

Applies to:

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

Symptoms

Incremental load is getting failed in ONT Endeca extensions in Endeca V5 in production. Incremental load is scheduled to run and it is getting failed with following error:
 
 -- Error
 2015-11-16 11:39:33,651 ERROR 53788 [WatchDog] Graph execution finished with
 error
 2015-11-16 11:39:33,651 ERROR 53788 [WatchDog] Node
 COMPUTE_TEMP_TABLE_COLUMNS finished with status: ERROR caused by: ORA-06503:
 PL/SQL: Function returned without value
 ORA-06512: at "APPS.OE_LINE_STATUS_PUB", line 888
 ORA-06512: at "APPS.OE_ENDECA_UTILS", line 750
 ORA-06512: at line 1
 
 2015-11-16 11:39:33,651 ERROR 53788 [WatchDog] Node
 COMPUTE_TEMP_TABLE_COLUMNS error details:
 java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
 ORA-06512: at "APPS.OE_LINE_STATUS_PUB", line 888
 ORA-06512: at "APPS.OE_ENDECA_UTILS", line 750
 ORA-06512: at line 1
 
  -- Steps
 The issue can be reproduced at will with the following steps.
 1. Run Incremental load graph.

 

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