Oracle EPM/HFM 11.1.2.1 Process Management History Report
All, our customer is upgrading from HFM 11.1.2.1 to 11.1.2.4. In order to sunset their 2.1 environment, they want a historical report of the Process Management. I know it's not available in the UI and I know the tables that store the data. Here is what we are trying to achieve and I wanted to see if anyone else has built a query for this purpose. Oracle Support noted it's outside of their area to provide guidance.
What I’m trying to tie back is the following: [On the PFLOW table]
- Logical name for lPeriod. It’s a big number, but isn’t there a table that shows the Period info…ie Period 8, 2014, etc…