My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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