GM_GMFACS Created WFA And SFA Rows On Archived Rows From PROJ_RESOURCE
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:
- 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.
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