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:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
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:
-------- ---------------------------------------------------------------------------------------
3993/8 PL/SQL: Statement ignored
3993/8 PLS-00306: wrong number or types of arguments in call to 'AP_CHECK_GDF_VALID'
-------- ---------------------------------------------------------------------------------------
4010/8 PL/SQL: Statement ignored
4010/8 PLS-00306: wrong number or types of arguments in call to 'AP_CHECK_GDF_VALID'
-------- ---------------------------------------------------------------------------------------
3957 23 PLS-00302: component 'AP_CHECK_GDF_VALID' must be declared
3957 3 PL/SQL: Statement ignored
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:
- Apply patch 19157523
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |