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.

Symptoms

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.

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