Search Results time_source_id

Overview

The HXC_TIME_SOURCES table is a core reference table within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It serves as the master repository for defining and managing the various sources from which time entry data can originate. In the context of Oracle EBS 12.1.1 and 12.2.2, this table underpins the system's ability to process and validate time data submitted from disparate channels, such as web clocks, mobile applications, batch imports, or integration with external systems. Each record represents a distinct, configured source of time data, enabling the application to apply appropriate business rules, validations, and processing logic based on the entry's origin.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the table's purpose dictates its critical structure. The primary column is TIME_SOURCE_ID, a unique system-generated identifier for each time source. Other essential columns typically include a NAME or SOURCE_NAME for the descriptive label (e.g., "Web Clock," "Mobile App," "Batch Interface"), and a TYPE or similar column to categorize the source. The table may also contain configuration flags controlling whether the source is active, its order of precedence, and other attributes that govern how time from that source is handled by the Time and Labor Engine's deposit and validation processes.

Common Use Cases and Queries

A primary use case is administrative setup and reporting. System administrators query this table to review and maintain the list of enabled time entry sources. It is also crucial for diagnostic and audit reporting, where timecard data must be traced back to its point of origin. Common SQL queries include listing all active time sources or joining to transaction tables to analyze submission volumes by source. For example:

• SELECT time_source_id, name FROM hxc_time_sources WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE); (to find active sources).
• SELECT ts.name, COUNT(*) FROM hxc_time_building_blocks tbb, hxc_time_sources ts WHERE tbb.time_source_id = ts.time_source_id GROUP BY ts.name; (to count time entries by source, assuming a relationship exists).

Related Objects

As documented in the provided metadata, HXC_TIME_SOURCES has a direct foreign key relationship with the HXC_DEPOSIT_PROCESSES table. The HXC_DEPOSIT_PROCESSES.TIME_SOURCE_ID column references HXC_TIME_SOURCES.TIME_SOURCE_ID. This relationship is fundamental; it links a configured time source to the specific deposit process engine that manages the submission and validation workflow for time data originating from that source. This design ensures that time entries from a web clock and a batch file, for instance, can be processed through different, source-specific business rules.