Payroll and OTL - EBS (MOSC)

MOSC Banner

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

edited Dec 23, 2014 10:02AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center