Load Failures For ONT FullGraph (Doc ID 1995165.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Endeca Intregration

Load failures for ONT FullGraph

After successful install and configuration, when trying to run a full load for ONT graphs
we are running into an error:

PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.OE_ENDECA_UTILS", line 824

This is due to the req numbers variables in the package being number when they should
be able to handle varchar2. Below cursor can return varchar2, but values are being placed
in number variable.

CURSOR get_req_number (p_line_id IN NUMBER) is
  SELECT RQH.segment1
  from PO_REQUISITION_HEADERS_ALL RQH,
  OE_DROP_SHIP_SOURCES SRC,
  OE_ORDER_LINES_all LIN
  where SRC.LINE_ID = LIN.LINE_ID
  and SRC.REQUISITION_HEADER_ID = RQH.REQUISITION_HEADER_ID
  AND lin.line_id = p_line_id;


The version of EBS Extentions for Endeca is 12.1.3.5 and patch for SCM we applied
is 17730048. 

 

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