Problem When Running SPL_OMS_SNAPSHOT_PKG.SQL When Installing BI

(Doc ID 978717.1)

Last updated on JUNE 08, 2010

Applies to:

Oracle Utilities Business Intelligence - Version: 2.2.1 and later   [Release: and later ]
Information in this document applies to any platform.

Goal


When executing the Packages Deploy through the script spl_oms_snapshot_pkg.sql, the process does not complete successfully. Instead the following error is encountered:

SQL> @spl_oms_snapshot_pkg.sql

Function created.
Package created.
No errors.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY SPL_OMS_SNAPSHOT_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
588/5 PL/SQL: SQL Statement ignored
592/47 PL/SQL: ORA-00904: "NUM_CUST_SUST_INTRPT": invalid identifier
823/9 PL/SQL: SQL Statement ignored
831/13 PL/SQL: ORA-00904: "NUM_CUST_SUST_INTRPT": invalid identifier
1212/9 PL/SQL: SQL Statement ignored
1220/13 PL/SQL: ORA-00904: "NUM_CUST_SUST_INTRPT": invalid identifier
1305/5 PL/SQL: SQL Statement ignored
1309/47 PL/SQL: ORA-00904: "NUM_CUST_SUST_INTRPT": invalid identifier



Solution

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