Resolving Differences Between the GMS and the RFASI

Purpose

This document provides guidance on how to identify and resolve balance differences that may occur between GMS balance table and the RFASI balance. In addition, it provides a brief overview of why both tables exist and how they relate to transactions processing to a project/task/award.

Background

In the RF Award Summary Inquiry (RFASI) form of the Grants Management module of the Oracle business application, there are two balance lines that display:

Reasons for Balance Issues

The following reasons may create a balance discrepancy between the two tables and require corrective action:

Identifying and Resolving Balance Issues

Balance discrepancies can be identified by using the RF RFASI GMS Balance Comparison Report or may be detected when reviewing a project/task/award balance using the RFASI inquiry form in the Oracle application.

When balance discrepancies occur, the following steps should be taken to resolve the issue:

  1. Baseline the project/award. Note: This will immediately update the balance in the GMS balance table.
  2. After the baseline has completed successfully, resubmit the RFASI and review the balances.
  3. If the balance discrepancy remains after rebaselining and is greater than 1.00, there are purchase orders in a 'Closed' status that have a remaining
    balance and must be changed to 'Final Closed' or the remaining funds released.
  4. Review purchase orders in the PI Award Interface (PIAI) application using PO Inquiry. For instructions, review the work instruction: Inquiry on POs
    Creating a Balance Difference Using PIAI. If the results do not identify the POs required to correct, continue to step 4a. If the results do identify the POs,
    continue to step 5.
    1. Review purchase orders using the Purchasing module of the Oracle business application. For information on how to inquiry in the Purchasing
      Application, review the work instruction: Inquiry on POs Creating a Balance Difference Using Oracle Purchasing. Continue to step 5.
  5. Take corrective action; final close PO or release remaining funds.
  6. Baseline the project/task/award.
  7. Resubmit the RFASI and review the balances.

Monitoring and Prevention

To identify balance issues, the report RF RFASI GMS Balance Comparison Report should be used to monitor and correct balance discrepancies. This report should be run at the start of the business day before Accounts Payable (AP) and Purchasing (PO) transactions are processed which will effect the balance that is available in the GMS balance skewing the data displayed in the report.

To prevent these situations, the Discoverer report 650REPORTING.PO_Closed PO at the Header Level with Remaining Balance should be used to monitor purchase orders in a 'Closed' status that have a remaining balance and appropriate action taken.

Change History

 

 

Feedback
Was this document clear and easy to follow? Please send your feedback to webfeedback@rfsuny.org.

Copyright © 2011 The Research Foundation of State University of New York