TriniDBA

Problem:

While running patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLTXRBKUG.sql on worker  1.
           FAILED: file OKLTXRBKUG.sql on worker  2.
           FAILED: file OKLTXRBKUG.sql on worker  3.
           FAILED: file OKLTXRBKUG.sql on worker  4.
           FAILED: file OKLTXRBKUG.sql on worker  5.
           FAILED: file OKLTXRBKUG.sql on worker  6.
           FAILED: file OKLTXRBKUG.sql on worker  7.
           FAILED: file OKLTXRBKUG.sql on worker  8.
           FAILED: file OKLTXRBKUG.sql on worker  9.
           FAILED: file OKLTXRBKUG.sql on worker 10.
           FAILED: file OKLTXRBKUG.sql on worker 11.
           FAILED: file OKLTXRBKUG.sql on worker 12.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Solution:

The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus as sysdba and ran the following commands:

alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;

OKL_TRANSACTION_PVT now compiles without issue.

To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:

select count(*) from dba_objects where status = ‘INVALID’;

Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.