The Task Hierarchy Dimension exposed by the Oracle Fusion Projects application for Transactional Business Intelligence uses an ATG-generated column-flattened BI view object (BICVO) named PjfTaskHierarchyBICVO. This BICVO is dependent on the PJF_PROJ_ELEMENTS_CF table to provide a column-flattened representation of the value-based trees defined by the PJF_PROJ_ELEMENTS_B table. As a postinstallation initialization step, the PJF_PROJ_ELEMENTS_CF table must be populated with data using an Enterprise Scheduler Service (ESS) job within the Oracle Fusion Projects application. PJF_PROJ_ELEMENTS_CF, when populated, contains the keys of each column-flattened level of the Task Hierarchy. It contains up to 20 uppermost levels of the Task Hierarchy, including the Structure level, plus the base or leaf level. The Task Hierarchy Dimension does not contain Task Structure level.
The PJF_PROJ_ELEMENTS_CF is populated with data from the PJF_PROJ_ELEMENTS_B table by any of the following actions:
User selects the option Synchronize Project Updates from the Actions menu on the Project Plan page.
User goes to the ESS Monitor page and selects the column-flattening ESS job. See Running the Column-Flattening ESS Job.
A Project is created by the application. You need not perform any specific actions. The Copy Project action internally invokes the ESS job to populate the PJF_PROJ_ELEMENTS_CF table.
Note: | When a Project is created from Microsoft Projects, an invocation of the ESS flattening job is not performed automatically. You must enter the Projects Application and run the ESS job directly. |