ORA-06550 and ORA-00904 Invalid Identifier while Deploying an OWB 11.2.0.2 Mapping (Doc ID 1321824.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using OWB 11.2.0.2 with cumulative <Patch 10185523>, the following error messages are generated when deploying some mappings:

Case 1 example:
Occurs when the ANSI SQL Syntax parameter of the mapping is set to True:

ORA-06550: PACKAGE BODY, line 167, column 2:
PL/SQL: SQL Statement ignored

ORA-06550: PACKAGE BODY, line 186, column 166:
PL/SQL: ORA-00904: "IGS_UC_APPL_CHOICES_ODS"."PERSON_ID": invalid identifier

ORA-06550: PACKAGE BODY, line 26, column 2:
PL/SQL: SQL Statement ignored

ORA-06550: PACKAGE BODY, line 45, column 166:
PL/SQL: ORA-00904: "IGS_UC_APPL_CHOICES_ODS"."PERSON_ID": invalid identifier

ORA-06550: PACKAGE BODY, line 638, column 7:
PL/SQL: SQL Statement ignored

ORA-06550: PACKAGE BODY, line 676, column 166:
PL/SQL: ORA-00904: "IGS_UC_APPL_CHOICES_ODS"."PERSON_ID": invalid identifier


Case 2 example:
Occurs with all cases:

ORA-06550: PACKAGE BODY, line 479, column 1:
PL/SQL: SQL Statement ignored

ORA-06550: PACKAGE BODY, line 640, column 8:
PL/SQL: ORA-00904: "SETOP$2"."ID$4": invalid identifier

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