Patch 18045808 And 19030202 Cause Issues for Jtfptklb.pls, JTF_TASK_UTL and JTFTKMAN.pll (Doc ID 1992291.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Common Applications Calendar - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Installation

Patch 18045808 and 19030202 conflict on jtfptklb.pls and JTFTKMAN.pll, which causes package JTF_TASK_UTL to stay invalid and JTFTKMAN.fmb cannot generate successfully


SQL> alter package apps.JTF_TASK_UTL compile;

Warning: Package altered with compilation errors.

SQL> alter package apps.JTF_TASK_UTL compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
  



ERROR
-----------------------


Errors for PACKAGE BODY APPS.JTF_TASK_UTL:

LINE/COL ERROR


-------- -----------------------------------------------------------------


503/13 PLS-00323: subprogram or cursor 'CHECK_TRUNC_SRC_OBJ_NAME' is
declared in a package specification and must be defined in the
package body

580/14 PLS-00323: subprogram or cursor 'ENABLE_AUDIT' is declared in a


package specification and must be defined in the package body

582/13 PLS-00323: subprogram or cursor 'TASKTOSERVERTZ' is declared in a


package specification and must be defined in the package body

585/13 PLS-00323: subprogram or cursor 'SERVERTOTASKTZ' is declared in a


LINE/COL ERROR



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete upgrade

Cause

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