How to Enter Capital Debt Service in EPBCS Web Application


Overview

This article describes how to enter capital debt service via Task 8.1, which is one of the capital planning expenditure details that can be entered via the Capital Planning Tool.

Essential Information

Next Steps

  1. Navigate to Oracle to connect to the EPBCS environment and access the Capital Planning Tool.
  2. On the EPBCS Home Page, click on the Tasks tile


  3. Click on the caret to the left of 8 - Review and Manage Capital Planning to expand the Task List.
  4. Click on Task 8.1 Enter Capital Debt Services to open the form.


  5. Ensure the POV selections are set to the desired intersections.

    NOTE:
    • The POV is pre-populated with Years = FY23 (or relevant budget year); Scenario = Base Budget; Version = Working.
    • To edit a Dimension in the POV, click on the hyperlink of the desired Dimension and select the desired Dimension Member using the Member Selection window. If known, type the Dimension Member into the search bar; if unknown, navigate through the hierarchy to select the desired Dimension Member.


    • Verify that a blue checkmark displays next to the desired Dimension Member and click OK.


    • After selecting the desired Dimension Member and clicking OK, the cell of the Dimension will turn yellow. Click on the Go Arrow located in the top-right corner of the form to submit changes, and the cell of the Dimension will turn white again.


  6. Within the form, right-click on the blank square to the left of Project Start Date to initiate the Action Menu, then select Add Project Reference.


  7. A pop-up menu titled CX_AddProjectReference will appear.


  8. All Dimension fields, except for Project Reference, will pre-populate from the POV selections within Task 8.1 (specified in Step 5). Ensure the pre-populated Dimensions contain the desired selections.
  9. Enter the Project Reference if known, or click on the tree-structure icon to launch the Select a Member window.

    NOTE:
    • Project Reference is used to indicate the capital project being funded or the asset/loan for which debt is already being repaid.
    • For projects being planned or under construction (Active-Debt Pending and One-Time Outlay) Project Reference is pulled from the PPM Capital Project Hierarchy. These records start with ‘PR_’
    • For projects or debt already in repayment (Active-Debt Sold) Project Reference is pulled from the Debt File uploaded by the Campus Treasury Office. These records start with ‘SP_’


  10.  Locate and select the desired Project, and verify a blue checkmark displays to the left of your selected Project, then click OK.
  11. After clicking OK, the user will return to the CX_AddProjectReference pop-up menu. From here, verify the Project you selected in Step 9 is correct, then click Launch in the upper right-hand corner to populate form 8.1 with a new Capital Asset Detail row.
  12. An Information message will display indicating that the rule was run successfully, click OK to return to Task 8.1.


  13. Task 8.1 is now populated with a new Capital Asset Detail row using the information and Dimensions that were specified in Steps 6-12.


  14. Enter relevant details for the following columns:
    1. Required (Cell Color = Golden)
      • Funding Loan Amount
      • Funding Loan Years  
      • Funding Loan Rate  
      • Funding Payments
    2. Optional (Cell Color = White)  
      • Project Start Date  
      • Project End Date  
      • Capital – Funding Notes

        NOTE:
        • To specify dates in a pre-formatted cell, click on the cell requiring a date and enter the date in M(M)/DD/YY format OR:
          • Click on the calendar icon within the cell, and select a relevant date within the pop-up calendar.



          • Once you select a date, the cell turns from white to yellow with the selection displayed in M(M)/DD/YY format.


        • To select from a drop-down list in a pre-formatted cell, click on the cell and then select the down-arrow that appears in the right side of the cell.


          • Select an appropriate option to populate the cell with.


          • Once you make a selection, the cell turns from white to yellow with your current selection displayed.


  15. Once all relevant details have been entered, each cell that has been edited will change from its original color (white or golden) to yellow. To ensure entries are saved to the system, click Save located in the top-right corner of the form.



  16. An Information message will display indicating that the rule was run successfully, click OK to return to Task 8.1.


  17. After clicking Save, all previously yellow cells will turn back to white.


  18. Repeat Steps 6-17 as many times as relevant. Once all Project References have been added and relevant data entries saved, click Next in the top-right corner to bring up Task 8.2 One-Time Outlays and Capital Monthly Summary.

Questions?

If you need any additional assistance, please submit a ticket here.