OKS Invalids After 11i to R12 Migration (Doc ID 1448263.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Service Contracts - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.1 version upgraded from 11i Contracts where Service Contracts Reprocess/Synchronize Rule Data program has also been run, there are OKS invalids in the environment.
Some OKS objects remain invalid even after recompilation.

Error:

Name , Text
OKS_UPGRADE_WARRANTIES, PLS-00302: component 'SHIP_TO_CONTACT_ID' must be declared
OKS_UPGRADE_WARRANTIES, PL/SQL: Declaration ignored
OKS_COVTIMES_HIST_V, ORA-00942: table or view does not exist
OKS_EXTWAR_UPGRADE, PL/SQL: ORA-00942: table or view does not exist
OKS_EXTWAR_UPGRADE, PL/SQL: SQL Statement ignored
OKS_UPGRADE_WARRANTIES, PLS-00905: object APPS.OKS_UPGRADE_WARRANTIES is invalid
OKS_UPGRADE_WARRANTIES, PLS-00304: cannot compile body of 'OKS_UPGRADE_WARRANTIES' without its specification
OKS_UPGRADE_WARRANTIES, PL/SQL: Compilation unit analysis terminated
OKS_COVERAGE_MIGRATION, PL/SQL: ORA-00942: table or view does not exist
OKS_COVERAGE_MIGRATION, PL/SQL: SQL Statement ignored
OKS_COVERAGE_MIGRATION, PLS-00364: loop index variable 'GET_DURATION_REC' use is invalid
OKS_COVERAGE_MIGRATION, PL/SQL: Statement ignored
OKS_COVERAGE_MIGRATION, PLS-00364: loop index variable 'GET_TIME_ZONE_ID_REC' use is invalid
...
OKS_CCENCRYPTION_PKG, PLS-00302: component 'GET_SYS_KEY_RAW' must be declared
...
'C_DES3_MAX_KEY_LEN' must be declared
OKS_CCENCRYPTION_PKG, PL/SQL: Statement ignored
OKS_CCENCRYPTION_PKG, PLS-00302: component 'CIPHER_CCNUMBER' must be declared
OKS_CCENCRYPTION_PKG, PLS-00302: component 'GET_HASH' must be declared
OKS_CCENCRYPTION_PKG, PLS-00302: component 'GET_UNMASKED_DIGITS' must be declared
OKS_CCENCRYPTION_PKG, PL/SQL: ORA-00904: "IBY_CC_SECURITY_PUB"."GET_UNMASKED_DIGITS": invalid identifier
...
OKS_CCENCRYPTION_PKG, PLS-00302: component 'GET_SECURE_CARD_REF' must be declared
"IBY_CC_SECURITY_PUB"."GET_SECURE_CARD_REF": invalid identifier
OKS_CCENCRYPTION_PKG, PL/SQL: SQL Statement ignored
OKS_CCENCRYPTION_PKG, PLS-00302: component 'GET_SECURE_CARD_REF' must be declared
OKS_CCENCRYPTION_PKG, PL/SQL: ORA-00904: "IBY_CC_SECURITY_PUB"."GET_SECURE_CARD_REF": invalid identifier
OKS_CCENCRYPTION_PKG, PL/SQL: SQL Statement ignored
OKS_CCENCRYPTION_PKG, PLS-00302: component 'CIPHER_CCNUMBER' must be declared
OKS_RULE_MIGRATE, PL/SQL: ORA-00942: table or view does not exist
OKS_RULE_MIGRATE, PL/SQL: SQL Statement ignored
...
OKS_RULE_MIGRATE, PL/SQL: ORA-00942: table or view does not exist
OKS_RULE_MIGRATE, PL/SQL: SQL Statement ignored

Steps to Reproduce:

1. Run the migration 11i to R12 and follow the instructions in Doc ID 372469.1: Service Contracts Release 12 Migration

2. Check for invalid objects:

col owner format a7 col OBJECT_NAME format a40
SET pages 999 lin 140
SELECT OWNER,
object_name,
object_type,
status
FROM dba_objects
WHERE status <> 'VALID'
AND object_name LIKE 'OKS_%';

Typical output:
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------- ---------------------------------------- ------------------- -------
APPS OKS_CCENCRYPTION_PKG PACKAGE BODY INVALID
APPS OKS_COVERAGE_MIGRATION PACKAGE BODY INVALID
APPS OKS_COVTIMES_HIST_V VIEW INVALID
APPS OKS_EXTWAR_UPGRADE PACKAGE BODY INVALID
APPS OKS_RULE_MIGRATE PACKAGE BODY INVALID
APPS OKS_UPGRADE_WARRANTIES PACKAGE INVALID
APPS OKS_UPGRADE_WARRANTIES PACKAGE BODY INVALID

7 rows selected.
--

3. Recompile invalid objects.

SQL>
ALTER PACKAGE APPS.OKS_CCENCRYPTION_PKG COMPILE body;
ALTER PACKAGE APPS.OKS_COVERAGE_MIGRATION COMPILE body;
ALTER VIEW APPS.OKS_COVTIMES_HIST_V COMPILE;
ALTER PACKAGE APPS.OKS_EXTWAR_UPGRADE COMPILE body;
ALTER PACKAGE APPS.OKS_RULE_MIGRATE COMPILE body;
ALTER PACKAGE APPS.OKS_UPGRADE_WARRANTIES COMPILE;
ALTER PACKAGE APPS.OKS_UPGRADE_WARRANTIES COMPILE body;

Some packages fail to compile:

>> Warning: Package Body altered with compilation errors.

Note: view OKS_COVTIMES_HIST_V can be dropped as this is no longer used in R12.

SQL>
Warning: Package Body altered with compilation errors.
SQL>
Warning: View altered with compilation errors.
SQL>
Warning: Package altered with compilation errors.

The following SQL will display existing Errors.

SQL> col TEXT format a100
SELECT NAME,
TEXT
FROM DBA_ERRORS
WHERE NAME IN ('OKS_CCENCRYPTION_PKG' ,'OKS_COVERAGE_MIGRATION' ,'OKS_COVTIMES_HIST_V' ,'OKS_EXTWAR_UPGRADE' ,'OKS_RULE_MIGRATE' ,'OKS_UPGRADE_WARRANTIES' ,'OKS_UPGRADE_WARRANTIES' );


Changes

Migration from 11i to R12.

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