OHADI 2.0: Setup Pkg Fails with "HDM_CRS_MAP"."PRIO_FLG", ODI-1228, PLS-00905 and ORA-06550 Error Messages (Doc ID 1476901.1)

Last updated on DECEMBER 09, 2015

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.0 and later
Information in this document applies to any platform.

Goal

The package PKG_Global fails with the following error:

"HDM_CRS_MAP"."PRIO_FLG": invalid identifier

The table HDM_CRS_MAP does not have the prio_flg as a field.

 

Error from inside OHADI is:

ODI-1228: Task PROC_DI_Refresh_CRSMAP_INTRVN_S (Procedure) fails on the target ORACLE connection HDM.
Caused By: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00905: object HDM.LOAD_FLT_CRSMAP_INTRVN is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 

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