Invalid OKL Object OKL_SIMPLE_PRICING_PVT After Upgrade To 12.1.3 (Doc ID 1274356.1)

Last updated on APRIL 11, 2022

Applies to:

Symptoms

On: 12.1.3 version, Installation

After <patch 9239090> 12.1.3, ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK is applied there is an invalid OKL object.

ERROR
-----------------------
Errors for PACKAGE BODY OKL_SIMPLE_PRICING_PVT

a) OMCHECK (appscheck) output shows:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

. ( ) , * %

b) Recompiling shows:
Warning: Package Body created with compilation errors.
.
(POWER(1+ l_Rate,l_periods)-1)
*
ERROR at line 1:
ORA-00928: missing SELECT keyword




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <patch 9239090>.
2. Run the following to check the invalid objects:
select object_name, object_type, owner, status
from dba_objects
where status = 'INVALID'
and object_name like 'OKL%'

OR

Check Apps Check output for product OKL
(R) OM Super User
(N) Reports, Request > Run Request > Single Request
- Choose "Diagnostics: Apps Check", select 'Lease Management' from the LOV

Please provide the Apps Check output for product OKL
(R) OM Super User
(N) Reports, Request > Run Request > Single Request
- Choose "Diagnostics: Apps Check", select 'Lease Management' from the LOV

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.