PJC: SQL To Find OTL Reference/linkages /With Project Expenditure Items
(Doc ID 2456135.1)
Last updated on JUNE 10, 2022
Applies to:Oracle Fusion Project Costing Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.
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?
(a) Is HWM_TM_REC available in any subject area?
(b) Which subject area is best for getting the project expenditures.
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