PJC: SQL To Find OTL Reference/linkages /With Project Expenditure Items (Doc ID 2456135.1)

Last updated on JUNE 10, 2022

Applies to:

Goal

Qn1:On : 11.13.18.05.0 version, Manage Project Costs

We are writing a report to query project expenditures and need to include OTL information for when the expenditure comes from Oracle Time and Labor expenditure source. In PJC_EXP_ITEMS_ALL are the columns ORIGINAL_HEADER_ID, ORIGINAL_LINE_NUMBER, ORIGINAL_DIST_ID. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. However, the IDs in PJC_EXP_ITEMS_ALL columns don't match any IDs in the HXT tables. I then take the INCURRED_BY_ID and expenditure date and am able to match to a timecard record in the HXT tables. But i would prefer that we use IDs to link between the project expenditure and the OTL records, if possible.

How can we find out what the original ID values join to?
 
Qn2:

(a) Is HWM_TM_REC available in any subject area?
(b) Which subject area is best for getting the project expenditures.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.