PLS-00907: Cannot Load Library Unit APPS.OKL_TCN_PVT (referenced By APPS.OKL_TRX_CONTRACTS_PVT) (Doc ID 1478047.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.1 and later
Information in this document applies to any platform.
Checked for relevance on 09-JAN-2014

Goal

Did a 12.1.1 fresh install then patched to 12.1.3. After that, there are some invalid objects found in the db. When compiling the packages, all shown the same error:
PLS-00907: cannot load library unit APPS.OKL_TCN_PVT (referenced by APPS.OKL_TRX_CONTRACTS_PVT)

However the package "OKL_TCN_PVT" is VALID.

OKL_TRANS_CONTRACTS_PVT_W
OKL_TRANSACTION_PVT_W
OKL_TRANSACTION_PUB
OKL_MISC_TRANS_PVT
OKL_REV_LOSS_PROV_PVT
OKL_SPLIT_CONTRACT_PVT
OKL_TRANS_CONTRACTS_PVT
OKL_TRX_CONTRACTS_PUB_W
OKL_TRANS_CONTRACTS_PUB_W
OKL_TRANSACTION_PUB_W
OKL_SERVICE_INTEGRATION_PVT
OKL_PERIOD_SWEEP_PVT
OKL_PROCESS_PPD_PVT

How to compile these objects so they become valid?
 

Solution

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