My Oracle Support Banner

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 later
Oracle 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

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