How to customize Standard HCM Extract - Periodic Payroll Activity Report

Summary:

How to customize Standard HCM Extract - Periodic Payroll Activity Report

Content (please ensure you mask any confidential information):

We have a requirement to Burst the Payroll Activity Report to Multiple Payroll Representatives. Payroll Representatives are AORs assigned at department level. I tried to copy the extract and running it, it is completing with alerts. When I check the logs I can see error message as "There was a ORA-00904: "RELACT"."SOURCE_ACTION_ID": invalid identifier".

Can anyone tell me how to fix this error and is there any document on customizing the Periodic Payroll Activity Report?

I know we can make changes extract and burst the complete report but here requirement is We have to Group by Payroll Representatives and Burst report to multiple emails, is it possible. Please tell me how can we achieve this.