Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Project Execution Management - Operational Milestones

Question
2
Views
0
Comments
User_WJ43I
User_WJ43I Rank 1 - Community Starter

I am trying to report on operational milestones in FDI. I can see the execution tasks feeding into the DW_PROJECT_ELEMENT_D table. However, those same tasks do not seem to appear in the DW_PROJECT_PLAN_LINE_DETAIL_CF table. I'm assuming they do not feed in because they are operational, not transactional. They do not have any cost or revenue associated with them. I also do not see these non-transactional milestones showing in OTBI PPM subject areas either. I can build a BIP report to get the infromation I need such as Planned Start and End Dates and Actual Finish Dates, but I was hoping to use either FDI or OTBI. Has anyone else tried to report on these non-transactional tasks/operational milestones?

Tagged: