My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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: "<MAPPING>"."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: "<MAPPING>"."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: "<MAPPING>"."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: "<MAPPING>"."ID$4": invalid identifier

Changes

 

Cause

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
Symptoms
Changes
Cause
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.