Deleted Data Report using Audit Functionality
Deleted Data Report using Audit Functionality

 522 total views

In this article we will look into how to get the deleted data report for payroll objects. This works only if Audit functionality is enabled.

If you are not sure on where to turn the Audit functionality ON, look at this article.

This Seeded Deleted Data Report will fetch any deletes that occurred for the following Business Objects:

  • Deleted Payment Methods
  • Deleted Banks
  • Deleted Salaries
  • Deleted Assignments
  • Deleted Element Entries

We have a seeded Payroll Flow Pattern “Run Deleted Data Report” which runs the seeded HCM Extract “Deleted Data Report” which internally invokes the BI Report at path “Shared Folders/Human Capital Management/Payroll Interface/Deleted Data Report.xdo

Deleted Data Report
Deleted Data Report

Note: The Audit functionality for the business objects should be enabled and from then the application tracks the changes to these business objects.

We need to run this flow from Payroll > Checklist > Submit a Process or Report
Search for Run Deleted Data Report

The input parameters for this flow would look like below:

Input parameters for deleted data report
Input parameters for deleted data report

Process Start and End Dates are the only mandatory fields which gets the delete transactions done in between those dates.
Object Group: If you have created any object groups for payroll relationships, you can run it for that specific object group.
Payroll: If you have multiple Payrolls and want to run this report for only a specific payroll then select Payroll Name
Instance Name: Development/Production/QA Test. This will be passed on the XML output. If you are sending this info to the third party vendor, then use the right one. For testing purpose, it doesn’t matter what instance name you use.

The report will fetch the output based on all of the above inputs for the date range. It will fetch changes between Process Start Date – 7 to Process End Date.

The output will appear in .txt and .xml files. If there is a requirement to create any other format, then you can create a new template and attach it to report and add a new delivery option to the HCM Extract.

This process is mainly used for ADP Global Payroll Interface and is part of the standard seeded flow Run Standard Global Payroll Interface for ADP. But this can also be used independently if there is a need.

The output will look like:

Output Snapshot
Output Snapshot
Output Snapshot 1 Contd
Output Snapshot Contd

Tip: Even though it is an HCM Extract, it just calls the BI Report and the entire logic is in the BI Data Model, so you can copy the SQL and create your own deleted data reports if there is a requirement for other business objects.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has One Comment

  1. Mohan

    Nice article

Leave a Reply