Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
EBS 12.2.6 - How to query assignment actions to identify a reversed check?
We have a custom process to pull pay information into a table in order to run grant labor reports. Staff found that a reversed check handed off during this data pull so it doubled that employee's labor cost.
In the SOE, when you view the reversed check, the Check Number field shows "Reversed" and if you click into that, it brings up a screen showing the check details (a Nacha as well as a check payment) with status "Reversed". I could use that flag to bypass that SOE during the custom data extract.
I cannot figure out where this data is stored. When I query the pay_assignment_actions table, the serial_number field is not populated (for any records that I can find).