Generate Balances Date Range


This report/process populates the balances in EiS payroll datamart for given check date range. These balances are used for reporting purpose in payroll module. The run schedule is done every night if SplashBI Payroll Triggers are disabled. In other words, Enable Triggers parameter is set to N for this process. This can be run by Oracle E-Business Suite Developer/System Administrator.


To run generate balances date range process:


  1. Navigate to Reports > All Reports.
  2. Search for Generate Balances Date Range in all reports tab.
  3. Click on Run icon to navigate to Submit page.



Generate Balances Date Range Parameters


Start Date: Enter Start Date from which balances to be generated.


End Date: Enter End Date till which balances to be generated.


Enable Triggers: (Y or N) enables the data mart triggers, which (for future payroll runs) will populate the data mart summary tables as soon as a payroll is run successfully. Data will be immediately available for reporting. The default value is Yes; set this value to No only if the user do not wish to populate data automatically. Retain the value as No to populate datamart on a nightly basis, keeping the triggers disabled.


Remove All Current Data: (Yes or No) removes all existing data and repopulates the data for given parameters. Balance Name can be used to populate a single balance. This report calls the concurrent program EIS Generate Balances Date Range which is a multi threaded process.


Balance Name: Select the Balance Name if Datamart has to be populated for any specific balances. Leave it blank to populate data for all the balances.


Employee Name: Select the Employee Name to whom data to be populated.


Business Group: Select name of the Business Group for which the data has to be populated.