Setting Up RPD For Budgetary Control For PeopleSoft

You can set up the RPD for Budgetary Control for PeopleSoft.

1. In Oracle BI EE Administration Tool, edit the BI metadata repository (for example, OracleBIAnalyticsApps.rpd).

   The RPD file is located at:

   ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obisn\repository

2. In the Business Model and Mapping layer, go to the logical table Fact - Fins - GL Journals Budgetary Control.
3. Under Sources, select the Fact_W_GL_OTHER_F_PSFT logical table source.
4. Clear the Disabled option in the General tab and click OK.
5. Repeat step 4 for the logical table sources – Fact_W_GL_OTHER_GRPACCT_DAY_A_PSFT and Fact_W_GL_OTHER_GRPACCT_FSCLPRD_A_PSFT.
6. Under Sources, select the Fact_W_GL_OTHER_F_EBS logical table source.
7. Select the Disabled option in the General tab and click OK.
8. Repeat step 7 for the logical table sources - Fact_W_GL_OTHER_GRPACCT_DAY_A_EBS and Fact_W_GL_OTHER_GRPACCT_FSCLPRD_A_EBS.
9. In the Business Model and Mapping layer, go the logical table Fact - Fins - Activity Budgetary Control.
10. Under Sources, select the Fact_W_GL_BALANCE_F_PSFT logical table source.
11. Select the Disabled option in the General tab and click OK.
12. Repeat step 11 for the other logical table source – Fact_W_GL_BALANCE_A_PSFT.
13. Under Sources, select the Fact_W_GL_BALANCE_F_EBS logical table source.
14. Select the Disabled option in the General tab and click OK.
15. Repeat step 13 for the other logical table source - Fact_W_GL_BALANCE_A_EBS.