Duplicate payroll payment in Payroll integration report when sent to bank

Summary:

There is a duplicate payroll payment in Payroll-to-Bank integration due to lack of status tracking for QuickPays.
The customized “Payroll Integration Report” on SaaS retrieves all QuickPay runs for the same employee in the same payroll period — including QuickPays already successfully paid via OIC and Bank — causing duplicated payment files.
⸻
Business Context
• Country: Saudi Arabia
• Bank: Bank
• Objective: Automate Payroll payments transfer through:
Payroll runs submitted in Fusion HCM
Custom Payroll Integration Report extracts run data
Data is sent to Oracle Integration Cloud (OIC)
OIC sends payment file to the Bank environment
⸻
Current Report Parameters

• Consolidation Set

• Payroll Name