After Applying Patch 35376272 - WF_LOAD Is Getting Invalid. (Doc ID 2968615.1)

Last updated on AUGUST 17, 2023

Applies to:

Symptoms

On : 12.2 HRMS RUP16 version, Workflow

WF_LOAD IS GETTING INVALID POST APPLYING WF PATCH 35376272


ERROR
-----------------------
SQL> ALTER PACKAGE WF_LOAD COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY WF_LOAD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2426/3 PL/SQL: Statement ignored
2426/12 PLS-00302: component 'PERSISTENCE_TYPE' must be declared
2785/3 PL/SQL: Statement ignored
2785/12 PLS-00302: component 'PERSISTENCE_TYPE' must be declared
SQL> ALTER PACKAGE XDP_PURGE COMPILE BODY;



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Applied Patch: 35376272 to resolve Purge Obsolete Workflow Runtime Data concurrent program not purging give item_type and item_key.

2. The patch resolved the issue Purge Obsolete Workflow Runtime Data concurrent program, but WF_LOAD   package body is Invalid with Error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot deploy the patch in production.

Cause

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