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:
- Generate an award that will include F&A processing.
- Add some cost transactions to the resulting project.
- Run GM_GMFACS to create WFA/SFA rows for those cost transactions.
- Run PC_COMPRESS against the transaction for that project.
- 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