Unable To Compile OKS_CCENCRYPTION_PKG

(Doc ID 413213.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Service Contracts - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 26-Feb-2014***

Symptoms

Unable to compile OKS_CCENCRYPTION_PKG.
a) Package OKS_CCENCRYPTION_PKG is invalid
alter session set nls_language = 'American'

Session altered

select owner, object_name, object_type, created, last_ddl_time, timestamp, status
from dba_objects
where owner = 'APPS'
and object_name like 'OKS_CCENCRYPTION_PKG%'

OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS
------------------------------ ---------------------------------------- ------------------ --------------------- --------------------- ------------------- -------
APPS OKS_CCENCRYPTION_PKG PACKAGE 6/8/2006 3:08:44 AM 6/8/2006 3:08:44 AM 2006-06-08:03:08:44 VALID
APPS OKS_CCENCRYPTION_PKG PACKAGE BODY 6/8/2006 3:08:50 AM 8/14/2007 1:28:34 PM 2006-12-06:12:14:38 INVALID
2 rows selected
b) Unable to compile package OKS_CCENCRYPTION_PKG
SQL> alter package OKS_CCENCRYPTION_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY OKS_CCENCRYPTION_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
80/20 PL/SQL: Item ignored
80/20 PLS-201: identifier 'IBY_SYS_SECURITY_SUBKEYS.SUBKEY_CIPHER_TEXT' must be declared
137/10 PL/SQL: Statement ignored
137/40 PLS-302: component 'GET_SYS_KEY_RAW' must be declared
142/8 PL/SQL: Statement ignored
142/8 PLS-320: the declaration of the type of this expression is incomplete or malformed

151/10 PL/SQL: SQL Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
151/17 PL/SQL: ORA-2289: sequence does not exist
157/9 PL/SQL: SQL Statement ignored
157/21 PL/SQL: ORA-942: table or view does not exist
249/7 PL/SQL: SQL Statement ignored
249/19 PL/SQL: ORA-942: table or view does not exist
422/7 PL/SQL: SQL Statement ignored
422/19 PL/SQL: ORA-942: table or view does not exist

Changes

Migration.

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