Audit Fields Not Updating SFA_FWS_STG When Running File Parser Process that Updates/Imports Data to SFA_FWS_STG
(Doc ID 2985204.1)
Last updated on JANUARY 25, 2024
Applies to:
PeopleSoft Enterprise CS Financial Aid - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
The File Parser process (SCCFP_PARSE) does not populate the SCC_ROW_ADD_OPRID, SCC_ROW_ADD_DTTM, SCC_ROW_UPD_OPRID, and SCC_ROW_UPD_DTTM fields in SFA_FWS_STG.
The issue can be reproduced at will with the following steps:
1. Create a csv file that will be used to run for FWS Reporting to COD File Mapping Definition (Set Up SACR -> System Administration -> Utilities -> File Mapping Definition)
2. Run the File Parser Process (Set Up SACR -> System Administration -> Utilities -> Run File Parser) to populate the FWS Staging table SFA_FWS_STG
3. Once the File Parser Process runs, verify the data updates SFA_FWS_STG.
4. Note that the fields are blank or null.
Changes
The issue is seen after applying Patch 34858743 which delivered the functionality.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |