OKL_invalid_objects_after_patching.txt

User_DYV2K

Marc Graul-Oracle

Hello,

What release and patch is this?

Please review existing docs:

R12 scenario:

Multiple OKL Invalid Package Bodies after Applying R12.1 or Upgrading to R12.1 (Doc ID 1067374.1)

11i scenario:

11.5.10.2 : After applying patch 18122010 : ORACLE APPLICATIONS WITH 11I.ATG_PF.H RUP7: CPU PATCH FOR JUL 2014 there is many invalid OKL objects (Doc ID 1920828.1)

Regards.

-Marc

User_DYV2K

Hello Marc

We are on 11.5.10.2

This is CPU2014 July patches.

We do not have OKL installed.

We have got that noteid suggested before as well.

Since we do not have OKL, can we ignore the invalids and proceed?

please advice.

regards

Sougata

Eric Castillo-Oracle

Hello Marc

We are on 11.5.10.2

This is CPU2014 July patches.

We do not have OKL installed.

We have got that noteid suggested before as well.

Since we do not have OKL, can we ignore the invalids and proceed?

please advice.

regards

Sougata

Hello,

This is a known issue, see document : 11.5.10.2 : After applying patch 18122010 : ORACLE APPLICATIONS WITH 11I.ATG_PF.H RUP7: CPU PATCH FOR JUL 2014 there is many invalid OKL objects (Doc ID 1920828.1)

Cause

Patch 18122010 ORACLE APPLICATIONS WITH 11I.ATG_PF.H RUP7: CPU PATCH FOR JUL 2014
includes those 2 patches :

Patch 4143569 OKL.G RUP1 8/11/2014 9:55:20 AM
Patch 4298372 OKL.G RUP2 8/11/2014 9:55:20 AM

Those 2 patches require patch 11i.OKL G as pre-requisite ,
but Patch 3981693 11Ii.OKL.G is not applied in the current environment.
as we can see from the result of this sql :

sqlplus apps/...

SELECT SUBSTR (bug_number, 1, 10) bug,
DECODE (bug_number,
'3981693', 'OKL.G','4143569', 'OKL.G RUP1','4298372', 'OKL.G RUP2','4487651', 'OKL.G RUP3','4956746', 'OKL.G RUP4',
'5388644', 'OKL.G RUP 5','4551977', 'OKL.H','5088908', 'OKL.H RUP1','5196112', 'OKL.H RUP2','5350898', 'OKL.H RUP3',
'5701628', 'OKL.H RUP4','6370848', 'OKL.H RUP5','6526396', 'OKL.H RUP6') patch,
creation_date app_date
FROM ad_bugs
WHERE bug_number IN
('6370848', '5701628', '5350898', '5196112', '5088908','4551977', '3981693', '4143569', '4298372', '4487651','4956746', '6526396', '5388644')
ORDER BY 2;

Please remember that at database level all products should be valid even if they are in status inactif in your environment
Even if OKL is not actif in your environment at database level you need to have the complete data model.
Note that when applying a patch for an inactif product, adpatch will check the status of the product and will perform only the needed actions.

Solution

To implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Apply Patch 3981693 11Ii.OKL.G

As usual before applying any patch :
- Review the readme and apply the pre-requisite patches if any

3. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.

Best Regards,

Eric.