E1: INST: UPG: Data Import for SY910 Fails with Error "PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG' must be declared" During Platform Pack for Install or Upgrade to EnterpriseOne 9.1 (Doc ID 1457747.1)

Last updated on AUGUST 16, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Upgrade from JD Edwards EnterpriseOne 9.0 to 9.1 application release level.
Oracle Enterprise Edition database, Release 11.2.0.2.0

While installing the Platform Pack, the database installation errors during the the SY910 data import and does not allow the install to continue. The SY910 tables appear to be populated, but the OracleLoadStatus.txt file states:

Calling load for SY910 load type SY
LOAD: Calling impdp dump file DUMP_SY.DMP for SY910
- - - - - - - - - - - - - - - - - - - - - - - - - -
Error Importing Data for SY910
- check OracleInstalllog.txt and /u01/jde/e910/ORCL/logs/Import_SY910_SY.log

The Import_SY910_SY.log has these errors:

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_LOOP' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 7, column 1:
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_END' must be declared
ORA-06550: line 7, c
Job "JDEDBA"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s)

 

Cause

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 hundreds of Community platforms