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 : How to retrieve HXC_ALIAS_VALUES reference that is associated with a time card entry
Hi,
I need some assisstance in locating the HXC_ALIAS_VALUES reference that is associated with a time card entry.
In the screenshot, there is Type field whose values are "Straight Time", "Overtime 1.65" etc. These values are sourced from HXC_ALIAS_VALUES.ALIAS_VALUE_NAME.
I need to to be able to reconstruct the Timecard after is has been imported into Project Accounting.
After importing the Time card to Project Accounting I am trying to retrieve the the Time Card details strating from PA_EXTENDITURE_ITEMS_ALL.
I have managed to get the ORIG_TRANSACTION_REFERENCE=28039:3 (for TRANSACTION_SOURCE=ORACLE TIME AND LABOR) from PA_EXPENDITURE_ITEMS_ALL.