Package PA_OLAP_PVT Is Invalid After Upgrade EBS Application to 12.2.4 and Database to 12.1.0.2
(Doc ID 2796366.1)
Last updated on SEPTEMBER 13, 2024
Applies to:
Oracle Project Planning and Control - Version 12.2.4 and laterOracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.
Symptoms
Package PA_OLAP_PVT is invalid after upgrade EBS Application to 12.2.4 and Database to 12.1.0.2.
When trying to compile the Package PA_OLAP_PVT manually, getting the below compilation error.
Compilation Error:
PLS-00201:identifier 'DBMS_SQL2.EXPAND_SQL_TEXT' must be declared
Steps:
1. Apply the 12.2.4 patch.R12.PJ_PF.C.delta.4(17934640)
2. Upgrade the Database version to 12.1.0.2
3. Review worker log for patch application error.
Changes
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 |