How do we Integrate EPBCS workforce with HCM for custom dimensions like PC and CC.
We need to integrate Custom dimensions like Programme Code and Cost Centre and get the data from HCM for these dimensions into EPM Workforce.
These are custom dimensions and Oracle has asked us to implement the below.
1. Copy and create a new HCM extract in HCM. Do not modify the Out of the box extract.
2. Create a Oracle BI Publisher(BIP) template so that the column headers match the Output Label in the HCM Extract definition
3. Export the HCM Extract from HCM
4. Register the HCM Extract file as a Data Source application. When you register the Output Label will become the Dimension Name.