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:

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

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