Symptom
- You run program RH_SFI_TRIGGER_JOB_REQUISITION to transfer position/job requisition data from ERP / S4HANA to Success Factors.
- The number of records in the tables BALDAT & DBTABLOG grow considerably.
- You are looking for a way to reduce these records.
Environment
Integration Add-On for SAP ERP HCM and SuccessFactors HCM Suite -> Transfer of Job Requisition Data for Positions from SAP ERP
Resolution
* Check if the interval of the jobs for RH_SFI_TRIGGER_JOB_REQUISITION is too small.
* See the documentation of RH_SFI_TRIGGER_JOB_REQUISITION (via transaction SE38 or in the selection screen of the program).
* Check if any customer own code/enhancement might be a possible root cause of too many records in BALHDR, BALDAT and DBTABLOG.
------------------------------------------------------------------------------------------------------------------------------------------------------------
1. Regarding the growth of BALHDR, BALDAT, in context of RH_SFI_TRIGGER_JOB_REQUISITION, please refer to SAP notes 3266845 and 3421192
If assistance with the deletion of these tables is required, please create a Support Case for team/component BC-SRV-BAL, see for example SAP note 195157
2. Regarding DBTABLOG and the question if HRT1107 logging can be disabled:
Please decide internally if logging for this table can be disabled. Read and use manual instruction of SAP notes 3000730 and 1834803.
If you decide to disable logging for this table, delete the rows with report RSTBPDEL. Alternatively you can delete the logs of this table periodically, after a specific time. Please see SAP note 2388295.
Should you need assistance in handling logging (DBTABLOG), please create a Support Case for team/component BC-CUS-TOL-ALO.
See Also
SAP Notes:
- 3266845 - HRSFI_RCT_TRG_JOBREQ: no possibility to delete the error messages from the application logs (SLG1)
- 3421192 - HRSFI_RCT_TRG_JOBREQ: retention period of the error messages from the application logs (SLG1) cannot be less than 5 years
- 195157 - Application log: Deletion of logs
- 3000730 - Impact on enabling table logging with profile parameter rec/client
- 1834803 - Disable logging of changes on customizing tables
- 2388295 - RSTBPDEL | Delete logs periodically
Keywords
KBA , PA-SFI-TM , Integration with SuccessFactors BizX Talent Management , BC-CUS-TOL-ALO , Activity Log , BC-SRV-BAL , Basis Application Log , How To