GM_FFR_XRPT NOT CORRECTLY CALCULATE UNLIQUIDATED OBLIGATIONS (10.F) - INCORRECT CRV SIGN

(Doc ID 2341024.1)

Last updated on DECEMBER 19, 2017

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : Grants 9.2 version, Report

ACTUAL BEHAVIOR  
---------------
Line 10 f, "Federal share of unliquidated obligations" is calculated incorrectly due to CRV tranasctions being processed as positive amounts rather than negative amounts. This is resulting in the unliquidated obligation amounts being overstated by the amount of the CRVs.

EXPECTED BEHAVIOR
-----------------------
Unliquidated obligation should calculate COMs - CRVs

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Set Unliquidated Obligation Source to Projects on the Grants Installation Options
2) Change Tableset Control for FS_05 (Accounts) for Set Control Value EGV05 to SHARE in the TableSet Controls
3) Update the KK Budget Definition for EG_UNIV setting the Account chartfield to rollup to Level 2 of Tree CONTROL_BD_ACCTS on Keys and Translations
4) Modify End Date to 12/31/2017 for Project PI-PRJ10 under EG_UNIV on the KK Budget Definition Control Chartfield page
5) Modify End Date to 12/31/2017 for Project PI-PRJ10 under EG_UNIV_PR on the KK Budget Definition Control Chartfield page
6) Enter a Budget Journal for EG_UNIV and Post (Generate parent Budget(s) is checked) for EGV05 / PI-PRJ10 / IMPLEMENTATION for 100,000.00
7) Add a PO with a single line for 100.00 against the project / activity and dispatch
8) Create a voucher copied from the PO, Budget check, run Document Tolerance and post
9) Run PC_PO_TO_PC for purchase orders for the project
10) Run PC_AP_TO_PC for the project (run for summary)
11) Run PC_POADJUST for the project for PO Reversals
12) Grants > Interactive Reports > Federal Financial Report- Run the FFR

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Federal share of unliquidated obligations is overstated

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms