Use the ODI variable HR_ACCRUAL_EXTRACT_MTHS_INCR for extraction of HR Accrual module data when running in incremental mode.
Optional or Mandatory
By default, Oracle BI Applications sets the value of HR_ACCRUAL_EXTRACT_MTHS_INCR variable to 3 months. This variable ensures data from last 3 months is refreshed in the warehouse when incremental ETL is executed.If this value seems fine no changes are needed.
However, if the decision is to have incremental data collection to be different from the last 3 months of data, then this variable value must be set accordingly as per the need as a mandatory step.
Applies to
This applies to all extracts done for Absences Module from E-Business Suite 11.1.10 and R12.x.x.
Dependency
None.