My Oracle Support Banner

PATCH #5382863 CREATES INVALID PACKAGE (Doc ID 976669.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Supply Chain Intelligence - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

 
Comments
--------
 On : 11.5.10.2 version, CSF-DailyBusiness Intelligence
 
When attempting to apply patch 5382863 the following error occurs.
 
ERROR
-----------------------
SQL> alter package ISC_FS_TASK_ETL_PKG compile body;
 
Warning: Package Body altered with compilation errors.
 
SQL> show errors
Errors for PACKAGE BODY ISC_FS_TASK_ETL_PKG:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
378/3 PL/SQL: SQL Statement ignored
425/7 PL/SQL: ORA-00904: "TTR_ASSIGNEE_TYPE": invalid identifier
1466/3 PL/SQL: SQL Statement ignored
1575/7 PL/SQL: ORA-00904: "RESOURCE_TYPE": invalid identifier
1629/3 PL/SQL: SQL Statement ignored
1955/32 PL/SQL: ORA-00904: "TA"."RESOURCE_TYPE": invalid identifier
2263/3 PL/SQL: SQL Statement ignored
2373/7 PL/SQL: ORA-00904: "OWNER_TYPE": invalid identifier
 
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install patch 5382863

Changes

 

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
Changes
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.