Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deployment Errors:ORA-06550 & ORA-00904 Invalid Identifier

590757Aug 9 2007 — edited Aug 9 2007

Hi All,

Getting the below errors while deploying the mapping

Name
Action
Status
Log
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1146, column 7:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1178, column 3:
PL/SQL: ORA-00904: "CNVLETTERCODE": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1372, column 7:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1393, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPELOB": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1588, column 7:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 160, column 3:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1609, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPESALESREP": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 174, column 3:
PL/SQL: ORA-00904: "CNVLETTERCODE": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1804, column 7:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 1825, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPEAREA": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 186, column 3:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 194, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPELOB": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 207, column 3:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 215, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPESALESREP": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 228, column 3:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 236, column 3:
PL/SQL: ORA-00904: "CNVANALYSISTYPEAREA": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 249, column 3:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 266, column 3:
PL/SQL: ORA-00904: "CNVCOUNTRY": invalid identifier
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 759, column 1:
PL/SQL: SQL Statement ignored
LF_CUSTINTERIMIF
Create
Warning
ORA-06550: line 939, column 3:
PL/SQL: ORA-00904: "CNVCOUNTRY": invalid identifier

All the Invalid Identifier objects are Transformation Functions.

The transformation functions, tables used in the mapping validated and deployed
without any issue, but when trying to deploy the mapping as a whole, getting the above error.

appreciate if you could you let me know what could be the causes for the ORA deployment error

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2007

Added on Aug 9 2007

#data-warehousing, #warehouse-builder

2 comments

1,158 views