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!
SQL to retrieve who submitted a timecard for an employee
We are on EBS R12.2.7.
We have a requirement to do an OBIEE report to retrieve OTL records where another person submitted a timecard for someone else. For example, employee is out unexpectantly and manager enters/submits the employee's timecard. We need a report that shows the employee name, the timecard start date, and the name of the last person to submit that timecard.
Does anyone have any SQL they would share that would retrieve that data? Or any pointers to what tables show who submitted a timecard would be helpful.
Thanks!
Melinda
0