Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Duplicate and Missing Payroll Payment Records for Employees
Content (please ensure you mask any confidential information):
I'm encountering an issue where the query returns two rows for a person one with the correct payment status and another incorrectly marked as "Unpaid." Additionally, some persons have a payment reference visible on the Fusion UI but are not included in the report. I’ve noticed that when I remove the OR conditions from the query, one case appears while the other disappears (e.g., "Paid Externally" appears and "Unpaid" disappears, or vice versa). Has anyone experienced a similar issue or can provide insight into resolving this?
Version (include the version you are using, if applicable):
Tagged:
0