My Oracle Support Banner

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

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Fusion Project Costing Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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