SAP Knowledge Base Article - Public

3613461 - RH_SFI_TRIGGER_JOB_REQUISITION: Too many records in tables BALDAT & DBTABLOG in short time.

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:

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

Product

integration add-on 3.0 for SAP ERP HCM and SAP SuccessFactors HCM Suite