BI SPL_OMS_SNAPSHOT_Package Deployment Errors (Doc ID 979152.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Business Intelligence - Version DNU2.2.1 to DNU2.2.1
Information in this document applies to any platform.

Symptoms

Q1:
While performing the database configuration for ETL Process, after uploading all the meta data and deploy all external table and extension, the deployment of the SPL_OMS_SNAPSHOT_Package package does not complete successfully. Instead an ora-06550 error is encountered.

Q2:
While running the spl_oms_snapshot_pkg.sql package the process does not complete successfully. Instead the "ora-00904: "NUM_CUST_SUST_INTRPT": invalid identifier" is encountered.

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