My Oracle Support Banner

Transformation Installation Fails With 'ORA-00904: :Invalid Identifier' (Doc ID 2820847.1)

Last updated on NOVEMBER 17, 2021

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.5.2 and later
Information in this document applies to any platform.

Symptoms

A transformation installation is ending in warning with the following error:

Validating all objects in <target model> Target Model
Checking for invalid objects such as Tables,Views,Indexes,Triggers.
We have invalid objects.Hence Recompiling the objects to resolve any compilation errors.
We still have invalid objects that cannot be resolved through compilation.
Identifying each individual invalid object type.
TRIGGER <trigger name> has following errors at:
  Line 16 with PL/SQL: Statement ignored
  Line 16 with PLS-00302: component 'CDR$DUP_NUM' must be declared
  Line 17 with PL/SQL: Statement ignored
  Line 17 with PLS-00302: component 'CDR$DUP_NUM' must be declared
We still have invalid objects that cannot be resolved through compilation.
Identifying each individual invalid object type.
PACKAGE BODY<package body name> has following errors at:
  Line 365 with PL/SQL: Statement ignored
  Line 365 with PLS-00302: component 'CDR$DUP_NUM' must be declared
  Line 606 with PL/SQL: SQL Statement ignored
  Line 606 with PLS-00302: component 'CDR$DUP_NUM' must be declared
  Line 607 with PL/SQL: ORA-00904: : 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!


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