Invalid Object OKL_K_LINE_FIN_EXT_PVT (Doc ID 2296829.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Symptoms

On : 12.1.3 version, Patch Application Issues

After applying a patch package body OKL_K_LINE_FIN_EXT_PVT is invalid and throws these errors in compiling:.

ERROR
-----------------------
SQL> show error
Errors for PACKAGE BODY APPS.OKL_K_LINE_FIN_EXT_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
156/1 PL/SQL: ORA-00907: missing right parenthesis
156/1 PL/SQL: SQL Statement ignored
2314/1 PL/SQL: ORA-00907: missing right parenthesis
2314/1 PL/SQL: SQL Statement ignored
4404/1 PL/SQL: ORA-00907: missing right parenthesis
4404/1 PL/SQL: SQL Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to compile package body OKL_K_LINE_FIN_EXT_PVT

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
There is no impact unless Lease and Finance Management (OKL) is being used.

Cause

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