My Oracle Support Banner

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

Last updated on JULY 21, 2020

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.