Getting Started with Grants Forecasting (Oracle PBCS)

Summary

Provides departments the ability to forecast compensation and non-compensation expenses at the employee/subcode/account level for all grant accounts (entity 05).

Body

Overview

The Grants Forecasting application is a large-scale enterprise solution developed to provide departments the ability to forecast and budget at a grant/project specific level (entity 05 accounts only).  It is part of the University's Oracle Planning and Budgeting Cloud Services suite (PBCS) also known as Enterprise Performance Management (EPM).

Detail

Grants Forecasting gathers data from General Ledger, PittWorx, Purchasing, RPA, and SPAR. The tool lets you see the impact of future grant expenses, including compensation and non-compensation costs. Fiscal Panther gathers data from Concur, PantherExpress, PERIS, Pitt Worx, and PRISM which includes General Ledger, Payables, PCard, Purchasing, RPA, and SPAR.

The initiative represents a collaboration between the Budget and Financial Reporting Office and Pitt Information Technology and is based on department requests for centrally-supported grants management tools. These tools provide users with an alternative to department purchased grants management software.

Data from this application is exported nightly to the Fiscal Panther Hub dashboards created to provide University administrators greater visibility into all financial data in one platform, including transaction level details.  

Key Benefits

  • Automated daily updates to data sources that collectively promote process efficiency and allow you to manage both current grants-related data and projections without additional data entry

  • System driven calculations for indirect costs, mandatory cost share, fringe benefits, and annual salary increases 

  • An automated tool to assist you in generating your grant forecasting projections, analyzing grant trends, and compiling reports

Steps to Get Started

Access to Grants Forecasting is granted through completion of a user form. For access to the corresponding Fiscal Panther Hub dashboards, users must also have access to the GL Mart. GL Mart access is requested through the Federated Authorization process.

To request access:

  1. Complete the user form found here.
  2. Submit the form to Pitt IT via a help ticket.
  3. User guide information can be found on the applications SharePoint site.

To use Grants Forecasting:

  1. Log in to My Pitt (my.pitt.edu)
  2. Search for “Grants Forecasting,” then select the task from the results.

  3. At the Oracle Cloud sign in page, click Pitt Passport login option at the botton of the page
  4. In not already logged in, enter your University Computing Account username and password, then click Sign In.

More Resources

About Data Updates to Grants Forecasting

Posted General Ledger data is loaded to the PBCS Grants Forecasting application on a nightly basis, Monday through Friday.  As a reminder, GL month-end closing generally happens three business days into the following month.  When running reports on the first of the month for the prior month, not all transactions will be posted for month end yet. For example, Payroll Costing is not posted until the last day of the closing cycle.  For more information, see Understanding Data Timing.

Beginning April 1, 2019, encumbrance values are calculated in PRISM, summarized by account number, and exported nightly to PBCS. The detail for these encumbrances found in the Loaded Encumbrance columns may be obtained in PRISM by running the new report, FGAE138 Extract of Calculated Encumbrances by Entity and Department (PDF).

FAQs

 

Details

Details

Article ID: 435
Created
Fri 8/25/23 10:05 AM
Modified
Tue 12/17/24 10:46 AM

Related Articles

Related Articles (3)

Provides departments the ability to forecast compensation and non-compensation expenses at the employee/subcode/account level for all non-grant accounts (entities 02, 03, 04, 06, 09).
Oracle’s Planning and Budgeting Cloud Solution (PBCS) is a flexible suite of planning applications that support enterprise-wide planning, budgeting, and forecasting in a cloud-based deployment model.
List of enterprise dashboards available to authorized users

Related Services / Offerings

Related Services / Offerings (1)

FINANCIAL AND PROCUREMENT SYSTEMS Oracle Planning and Budgeting Cloud Solution (PBCS) also known as Enterprise Performance Management (EPM) helps you plan, budget, forecast, and report on business performance.