Compile Failure For DBMS_RANDOM During ETL Process (Doc ID 1299038.1)

Last updated on JUNE 30, 2016

Applies to:

Primavera P6 Reporting Database - Version: R2.1 and later   [Release: R2 and later ]
Information in this document applies to any platform.

Symptoms

The following error is thrown in the Reporting Database ETLprocess.log file when running the ETL process:

<12.17.2010 10:06:59> createdbs [INFO] (Message) - Warning: Procedure created with compilation errors.
<12.17.2010 10:06:59> createdbs [INFO] (Message) - Errors for PROCEDURE CREATEREPORTUSERS:
<12.17.2010 10:06:59> createdbs [INFO] (Message) - LINE/COL ERROR
<12.17.2010 10:06:59> createdbs [INFO] (Message) - --------
-----------------------------------------------------------------
<12.17.2010 10:06:59> createdbs [INFO] (Message) - 56/7 PL/SQL: Statement ignored
<12.17.2010 10:06:59> createdbs [INFO] (Message) - 56/20 PLS-00201: identifier 'DBMS_RANDOM' must be declared
<12.17.2010 10:06:59> createdbs [INFO] (Message) - Procedure created.
<12.17.2010 10:06:59> createdbs [INFO] (Message) - Package created.
<12.17.2010 10:06:59> createdbs [INFO] (Message) - Package body created.
<12.17.2010 10:06:59> createdbs [INFO] (Message) - No errors.

.........

<12.17.2010 11:41:18> load [INFO] (Message) - createreportusers;
<12.17.2010 11:41:18> load [INFO] (Message) - *
<12.17.2010 11:41:18> load [INFO] (Message) - ERROR at line 2:
<12.17.2010 11:41:18> load [INFO] (Message) - ORA-06550: line 2, column 3:
<12.17.2010 11:41:18> load [INFO] (Message) - PLS-00905: object ODSUSER.CREATEREPORTUSERS is invalid
<12.17.2010 11:41:18> load [INFO] (Message) - ORA-06550: line 2, column 3:
<12.17.2010 11:41:18> load [INFO] (Message) - PL/SQL: Statement ignored
<12.17.2010 11:41:19> load [INFO] (Progress) - Step 2/9 Part 1/1 - FAILED
(150) (0 hours, 0 minutes, 3 seconds, 346 milliseconds)

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