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“
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:
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:
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.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM