Package OE_ENDECA_UTILS Became Invalid After Applying a Patch (Doc ID 2076153.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Patch Application Issues

After applying a  patch
the endeca package OE_ENDECA_UTILS became invalid.


ERROR
-----------------------
OE_ENDECA_UTILS OEXUENDB.pls 120.0.12010000.32 BODY INVALID

Errors for PACKAGE BODY OE_ENDECA_UTILS

PL/SQL: ORA-00904: "FND_EID_ATTH_PKG"."RETURN_TEXT": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00364: loop index variable 'FILEATTACHMENT_REC' use is invalid
PL/SQL: Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PLS-00364: loop index variable 'EID_REC' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'EID_REC' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'EID_REC' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'EID_REC' use is invalid
PL/SQL: Statement ignored
PLS-00201: identifier 'FND_EID_FLEX_PKG.GET_DFF_KVP_APP' must be declared
PL/SQL: Statement ignored
PLS-00306: wrong number or types of arguments in call to 'GET_SALESPERSON_NAME'
PL/SQL: Statement ignored
PLS-00306: wrong number or types of arguments in call to 'GET_SALESPERSON_NAME'
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 19258555 ORDER MANAGEMENT (12.1) AUG 2015 ROLL UP PATCH
2. Check invalids

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