Package Body APPS.PO_WF_PO_NOTIFICATION Becomes Invalid With Error 'PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope' After Applying July 2024 CPU Patch (Doc ID 3059308.1)

Last updated on NOVEMBER 16, 2024

Applies to:

Symptoms

When Applying the July 2024 CPU patch one of the package body PO_WF_PO_NOTIFICATION becomes invaid

SQL> alter package apps.PO_WF_PO_NOTIFICATION compile body;

Warning: Package Body altered with compilation errors.

ERROR

PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope

SQL> sho error
Errors for PACKAGE BODY APPS.PO_WF_PO_NOTIFICATION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1085/9 PL/SQL: Statement ignored
1086/16 PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope
1275/17 PL/SQL: Statement ignored
1275/121 PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope
1654/7 PL/SQL: Statement ignored
1655/22 PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope
1747/7 PL/SQL: Statement ignored
1747/103 PLS-00313: 'DATE_TO_DISPLAYDT' not declared in this scope

STEPS TO REPLICATE
The issue can be reproduced at will with the following steps:
1. Apply July 2024 CPU
2. Package PO_WF_PO_NOTIFICATION got invalid Error

Cause

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