Purge Payroll Datamart


This process purges the payroll data for the given date range i.e., it removes the data from EIS_BALNACE and EIS_BALNACE_LINES tables. Based on the below parameters data can be purged specific to a date range, balance and a Business Group, run on a need basis by an Oracle E-Business Suite Developer/System Administrator.


To run purge payroll datamart:


  1.  Navigate to Reports > All Reports.
  2.  Search for Purge Payroll Datamart in all reports tab.
  3. Click on Run icon to navigate to Submit page.



Purge Payroll Datamart Parameters         

   

Responsibility: Select the responsibility from the drop down.


Start Date: Start Date for which balances need to be purged.


End Date: End Date for which balances need to be purged.


Balance Name: Enter the name of the Balances if Datamart has to purge for any specific balances, else leave it blank (which purges for all the balances).


Business Group: Enter the name of the Business Group for which the data has to purge


NOTE: If there are multiple Business Groups, it's recommended to purge one after the other.