Invalid Service Contracts (OKS) Objects After Upgrading from 11i to R12 (Doc ID 1448263.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

On 12.1.1 instance upgraded from 11i, 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
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:

Changes

Migration from 11i to R12.

Cause