PA and GMS Invalid Objects After 19c Database Upgrade - PL/SQL ORA-04098 Trigger APPS.PA_TRANSACTION_INTERFACE_T4 is Invalid and Failed Re-validation
(Doc ID 2942075.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Project Costing - Version 12.2.4 and laterOracle Grants Accounting - Version 12.2.4 and later
Information in this document applies to any platform.
Symptoms
After upgrading from 12.1.0.2 database to 19.18. database, there are PA (Oracle Projects) and GMS (Grants Accounting) invalid objects.
PA_OTC_API
PA_TRX_IMPORT
PA_TXN_INTERFACE_ITEMS_PKG
GMS_LD_PKG
GMS_PA_API
GMS_AWARD_DIST_ENG
GMS_PA_COSTING_PKG
PAAPIMP_PKG
PA_TRANSACTION_INTERFACE_T4
Running the following queries identified the invalid objects and errors.
Changes
Upgrade from 12.1.0.2 database to 19.18 database
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 |