This discussion is archived
3 Replies Latest reply: Nov 2, 2012 9:09 AM by Ahsan Shah RSS

BI Apps - Workflow Task got "invalid identifier" error

Harish Nunna Newbie
Currently Being Moderated
Hi All,

I am loading seeded Projects subject area using DAC client for 11.5.10 container. And my data source is Oracle EBS 11.5.10 only. Few of the workflows tasks got failed. For example: “SDE_ORA_TaksDimension”. When I checked the session logs, its showing as “ORA-00904 " PA_PROJ_ELEMENT_VERSIONS "." FINANCIAL_TASK_FLAG ": invalid identifier” error for few Projects (PA) tables. I have verified in Oracle 11.5.10 database and noticed that the column(FINANCIAL_TASK_FLAG) itself is not there in the table (PA_PROJ_ELEMENT_VERSIONS).
I have also verified the SDE_ORA_TaksDimension mapping in “SDE_ORA11510_Adaptor” in Informatica PowerCenter Workflow designer, PA_PROJ_ELEMENT_VERSIONS table is having the column ‘FINANCIAL_TASK_FLAG’.

In other words, there is some discrepancy between available “SDE_ORA11510_Adaptor” and Oracle EBS 11.5.10 database. Could anyone please help me or guide me to resolve this issue?

Harish Nunna


  • Correct Answers - 10 points
  • Helpful Answers - 5 points