My Oracle Support Banner

Getting Error While Extending The Dimension (CD_SA). (Doc ID 2535065.1)

Last updated on SEPTEMBER 19, 2022

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 2.7.0.0.0 version, Install / Upgrade

Getting error while extending the dimension (CD_SA).

User have followed steps mentioned in the "OUA_Developer_Guide_2.7.0 document" guide for extending the CD_SA dimension. User want to add few more attributes to this dimension.

Getting below error after execution.

ODI-1228: Task CM: Call external CM Procedure-IKM BI Dimension Load (SCD-II)- fails on the target connection B1.Caused By: java.sql.BatchUpdateException: error occurred during batching: ORA-06550: line 1, column 7:
PLS-00201: identifier 'CCB2REP.CM_CD_SA_UDX' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at line 23

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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