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!
OTL: Importing Timecards API
I did some research to make sure that I was using the appropriate API calls but I am a little lost as to where to get the correct data from. For example where to look to get the project & task id’s to pass into the sql statement.
Here is what my timecard looks like in Oracle
**wasn't able to paste a screenshot**
Project - Task - Type - Mon - Teus - Wed - Thu - Fri - Sat - Sun
And here I have pasted my P/SQL statement, and if you look through it you will see the areas I am a little lost on. Any help will be much appreciated. I have made some comments in red, i think if you just provide some feedback on those comments I will be able to execute these api calls appropriately. Also, I don’t see in any of these statements that need to be called, where I specify the number of hours.
0