Overview

This article describes how to connect to the Resource Commitment Allocation Module (RCAM) through the Oracle Planning and Budgeting (EPBCS) Web Application or Smart View Excel Add-in. The RCAM allows user to record and report on resource commitments and facilitates manual transfer of resources on the General Ledger. Access to the tool is limited to a specific user base of campus, Vice Chancellor, and Dean’s Office level units who manage resources and subsequently transfer to departments for actual spending. Users are currently limited to Level B and above of the Financial Unit Hierarchy. 

Prerequisites

• Users must set their FinUnit User Variable prior to accessing the tool through either the EPBCS Web Application or Smart View Excel Add-In. 
• New users should submit a ticket to request an appointment to set their FinUnit User Variable in the Resource Commitment Allocation Module (RCAM).
• Before connecting via SmartView, users must install the Smart View Excel Add-In.
• After Smart View Excel Add-In is installed, users must set up their Private Connection to the relevant EPBCS environment(s).
  
  • • The Smart View Excel Add-In will not function properly on a Mac - Mac users should work with their IT support representatives to set up a virtual PC from which they can access Excel/Smart View.

Next Steps

Connecting via EPBCS Web Application

1. Navigate to EPBCS Production environment here.

2. On the sign-in page, click UCSD Single Sign-On.

3. On the Single Sign-On screen, log in using your Active Directory (AD) credentials.
4. From the EPBCS Home Page, select the Tasks tile.

5. Click on the caret, to expand the 7 - Create and Manage Resource Commitments task list.

6. Click on the relevant Task to enter the tool

- OR -

Connecting via Smart View Excel Add-In

1. Open Excel, in the top navigation ribbon, select Smart View from the ribbon, then Panel. If you have installed Smart View but do not see it in the navigation ribbon, navigate within the ribbon to Developer > COM Add-ins and make sure the box to the left of Oracle Smart View for Office is checked, and select OK.

2. From the Smart View panel, select Private Connections.

3. From the Private Connections drop-down menu, select the appropriate connection.

• Planning here is for the EPBCS Production environment.
• Planning2 here is for the EPBCS Training environment.
• The Production environment should only be used for real live data, while the Training environment may contain false data for training purposes.

4. If asked to sign in, on the sign-in page, click UCSD Single Sign-On.

5. Use the + signs to expand the UCSDPLAN and Task List menus, and double-click on 7 - Create and Manage Resource Commitments to open the relevant task list.

6. Double-click on the relevant task to launch the tool.