My Oracle Support Banner

GM_GMFACS Created WFA And SFA Rows On Archived Rows From PROJ_RESOURCE (Doc ID 1558448.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Grants - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


When using the project process PC_COMPRESS to summarize project transactions in order to save space, the resulting PROJ_RESOURCE rows are created with a blank FA_STATUS. The next time the Grants GM_GMFACS process runs, it sees these compressed rows as new because of that blank FA_STATUS and it therefore creates new WFA / SFA rowseven though FNA had already been processed on the uncompressed rows. This leads to invalid SFA/WFA rows and overstated amounts.

The PC_COMPRESS process needs to set a value for FA_STATUS on the resulting PROJ_RESOURCE rows so that those new compressed rows are not selected by GM_GMFACS.

The issue can be reproduced at will with the following steps:

  1. Generate an award that will include F&A processing.
  2. Add some cost transactions to the resulting project.
  3. Run GM_GMFACS to create WFA/SFA rows for those cost transactions.
  4. Run PC_COMPRESS against the transaction for that project.
  5. Run GM_GFACS again.

Due to this issue, invalid SFA and WFA rows were created and posted to the PROJ_RESOURCE table resulting in overstated F&A costs for Grants Awards.


To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.