My Oracle Support Banner

R12: View Workplan Cost Oracle.apps.fnd.framework.OAException: Java.sql.SQLException: ORA-04063: (Doc ID 2390348.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Navigation Workplan --> Task tab --> View Workplan Cost

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-04063: package body "APPS.PA_OLAP_PVT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PA_OLAP_PVT"
ORA-06512: at "APPS.PJI_REP_UTIL", line 874
ORA-06512: at line 1


Recompiling package returns the following errors

DBMS_CUBE.BUILD must be declared
DBMS_CUBE.IMPORT_XML must be declared

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!


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