My Oracle Support Banner

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 JULY 22, 2024

Applies to:

Oracle Project Costing - Version 12.2.4 and later
Oracle 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


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