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?
This is most likely because you do not have the following PRE REQUISIUTE for PROJECT ANALYSTICS for 11.5.10:
requires Family Pack M (11i.PJ_PF.M) to be applied to Oracle eBusiness Suite 11.5.10.
You need this to run Project Analytics. Please mark response as CORRECT
Thanks for your reply.
I am not sure whether this Family pack has been applied on the environment which I am considering as a source.
Could you please let me know, how I can check whether this Family Pack is installed or not?