R12: AP: Package Body AP_INVOICES_UTILITY_PKG Is Invalid After Applying Patch 19157523, Attempt To Compile The Pacakge Raises Error "PLS-00306: wrong number or types of arguments in call to 'AP_CHECK_GDF_VALID'" (Doc ID 2690919.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Symptoms

Package Body AP_INVOICES_UTILITY_PKG is INVALID after applying <Patch 19157523>

Error PLS-00306 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.