R12: AP: After Applying Patch 19157523, Package Body AP_INVOICES_UTILITY_PKG Is Invalid wtih Compilation Errors PLS-306, and PLS-302 Referencing Call to AP_CHECK_GDF_VALID (Doc ID 2690919.1)

Last updated on JANUARY 08, 2024

Applies to:

Symptoms

Package Body AP_INVOICES_UTILITY_PKG is INVALID after applying <Patch 19157523>

Compilation Errors PLS-00306 and PLS-00302 while compiling package body AP_INVOICES_UTILITY_PKG

Package Body compilation shows the following Errors:

The current version of Package Body AP_INVOICES_UTILITY_PKG (source file $AP_TOP/patch/115/sql/apinvutb.pls) is:

• Below 120.56.12010000.37, for Release 12.1.x
• Below 120.79.12020000.13, for Release 12.2.x

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

1. Apply patch 19157523
2. Observe that Package Body AP_INVOICES_UTILITY_PKG is invalidated

Changes

 Applied <Patch 19157523> or any other patch that upgraded the version of PACKAGE BODY FV_GTAS_UTILITY_PKG (source file $FV_TOP/patch/115/sql/FVGTSUTB.pls) to:

• Version 120.0.12010000.55 or Higher, for Release 12.1.x
• Version 120.0.12020000.54 or Higher, for Release 12.2.x

Cause

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