Results for “detail_object_version”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.HXC_TIMECARD_DETAIL_HOURS_V view is a reporting and integration object within the Oracle E-Business Suite Time and Labor Engine (HXC) module. It exposes timecard detail hours records along with dynamically resolved mapping attributes drawn from the OTL Deposit Process Mapping configuration. The view is documented as VALID in the APPS schema on both EBS 12.1.1 and 12.2.2. Its primary purpose is to present timecard detail lines—including hours, start/stop times, resource identifiers, and measures—enriched with a concatenated context/segment value pair derived from the mapping attributes configuration. This supports downstream payroll deposit, costing, and interface processes that require both the raw timecard detail and the mapping context needed to route those hours to the correct elements or accounts.
Underlying Base Objects
The view is constructed over two primary SELECT-level sources, as defined by the documented ETRM metadata:
- HXC_TIMECARD_DETAILS_V (aliased HTD): supplies the timecard detail records, including the detail identity, version, timestamps, parent references, resource, measure, unit of measure, and 30 attribute columns (DETAIL_ATTRIBUTE1 through DETAIL_ATTRIBUTE30).
- HXC_MAPPING_ATTRIBUTES_V (aliased HM): supplies the mapping configuration, filtered to
HM.MAP = 'OTL DEPOSIT PROCESS MAPPING'andHM.FIELD_NAME = 'DUMMY ELEMENT CONTEXT'. This join is an outer join ((+)), so detail rows are retained even where mapping attributes are absent. - HR_GENERAL (PACKAGE): referenced as a base object, typically used to resolve lookup meanings or descriptive flexfield context values exposed alongside the mapping segment.
The view also uses an inline scalar subquery against HXC_TIMECARD_DETAILS_V to isolate the maximum DETAIL_OBJECT_VERSION for each DETAIL_TIMECARD_ID, ensuring only the current (latest) version of each detail line is returned.
Key Columns
- DETAIL_TIMECARD_ID: the identifier of the underlying timecard detail row; central to any query the user is likely building when searching for
detail_timecard_id. - DETAIL_OBJECT_VERSION: version number of the detail record; the view returns only the row matching the maximum version per detail ID.
- DETAIL_START_TIME / DETAIL_STOP_TIME: the start and stop timestamps for the detail interval.
- DETAIL_PARENT_TIMECARD_ID / DETAIL_PARENT_OBJECT_VERSION: reference back to the parent timecard and its version.
- DETAIL_RESOURCE_ID: the resource (typically the person or assignment) associated with the detail.
- DETAIL_MEASURE / DETAIL_UNIT_OF_MEASURE: the quantity measured and its unit (for example, hours).
- Resolved attribute: the
SUBSTR(DECODE(HM.SEGMENT, ...), 11, 20)expression selects the correct DETAIL_ATTRIBUTEn based on the mapping segment and extracts characters 11–20, producing the mapped element context value. - HM.CONTEXT / HM.SEGMENT: carried through from the mapping attributes view to identify which attribute and context the resolved value came from.
Common Use Cases and Queries
Typical uses include payroll deposit processing, timecard detail reconciliation, and diagnostic queries that trace a detail_timecard_id to its resolved mapping context. Because the view already filters to the latest object version and applies the deposit process mapping, it is well suited to integration extracts.
SELECT detail_timecard_id,
detail_object_version,
detail_start_time,
detail_stop_time,
detail_resource_id,
detail_measure,
detail_unit_of_measure
FROM apps.hxc_timecard_detail_hours_v
WHERE detail_timecard_id = :p_detail_timecard_id;
Analysts commonly join this view to HXC_TIMECARDS or payroll element lookups to confirm that hours deposit to the intended element, and filter on HM.SEGMENT or the resolved context when investigating mapping discrepancies in the OTL Deposit Process Mapping setup.
-
APPS.HXC_TIMECARD_DETAIL_HOURS_V·↳ HR_GENERAL·↳ HXC_MAPPING_ATTRIBUTES_V·↳ HXC_TIMECARD_DETAILS_V·Explore HXC module →
-
APPS.HXC_TIMECARD_DETAIL_HOURS_V·↳ HR_GENERAL·↳ HXC_MAPPING_ATTRIBUTES_V·↳ HXC_TIMECARD_DETAILS_V·Explore HXC module →
-
View: HXC_TIMECARD_DETAILS_V 12.2.2
APPS.HXC_TIMECARD_DETAILS_V·↳ HR_GENERAL·↳ HXC_TIME_ATTRIBUTES·↳ HXC_TIME_ATTRIBUTE_USAGES·Explore HXC module →
-
View: HXC_TIMECARD_DETAILS_V 12.1.1
APPS.HXC_TIMECARD_DETAILS_V·↳ HR_GENERAL·↳ HXC_TIME_ATTRIBUTES·↳ HXC_TIME_ATTRIBUTE_USAGES·Explore HXC module →
-
eTRM - HXC Tables and Views 12.1.1
Transaction Details Archive
-
eTRM - HXC Tables and Views 12.2.2
Used in Generic Upgrade