You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?

in Reporting and Analytics for HCM 1 comment

Summary:

Hi Community,

I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM.

Context:

  • In the Time Card UI, I can see the Cost Code field populated with value "C10755" (see screenshot attached)
  • I need to extract this cost code information via SQL query for reporting purposes

What I've Tried:I've queried the following OTL extract views:

  1. HWM_EXT_TIMECARD_HDR_V - Time card header
  2. HWM_EXT_TIMECARD_DETAIL_V - Time entry details
  3. HWM_EXT_ATTRB_DETAIL_V

I also checked:

  • HWM_TM_COST_OVERRIDES
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!