Search Results hxc_dep_transactions




Overview
Explore in AI Chat

Overview

The HXC_DEP_TRANSACTIONS table is a core data object within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It functions as the primary transactional ledger for timecard data processed by the Time and Labor engine. The table stores high-level transaction records that represent the submission, approval, and processing of time entries. Its role is critical for managing the lifecycle of time data as it moves from initial entry through validation, approval, and eventual transfer to downstream applications like Oracle Payroll. The integrity of this transactional data is fundamental for accurate time reporting, labor costing, and payroll calculations in EBS implementations.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the structure indicates the table's purpose. The primary key, TRANSACTION_ID, uniquely identifies each transaction record. Based on its role as a transaction header table, typical columns would include metadata such as the transaction type (e.g., 'SUBMIT', 'APPROVE', 'RETRIEVE'), the date and time of the transaction, the person or resource ID associated with the timecard, the timecard or batch identifier, and the current status or processing phase of the transaction. It serves as the anchor point for detailed time entry data stored in related child tables.

Common Use Cases and Queries

This table is central to auditing timecard workflows and troubleshooting time processing issues. Common use cases include tracking the submission and approval history of a specific timecard, identifying time entries stuck in a particular processing state, and generating reports on time transaction volumes over a period. A typical query would join HXC_DEP_TRANSACTIONS to its detail table to analyze time data. For example, to find all approved transactions for a given date range, a query might pattern:

  • SELECT ht.transaction_id, ht.transaction_type, ht.resource_id, hd.time_attribute
  • FROM hxc_dep_transactions ht, hxc_dep_transaction_details hd
  • WHERE ht.transaction_id = hd.transaction_id
  • AND ht.transaction_type = 'APPROVE'
  • AND ht.transaction_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

The HXC_DEP_TRANSACTIONS table has a direct parent-child relationship with the HXC_DEP_TRANSACTION_DETAILS table, as documented in the provided metadata. The relationship is defined by a foreign key where HXC_DEP_TRANSACTION_DETAILS.TRANSACTION_ID references HXC_DEP_TRANSACTIONS.TRANSACTION_ID. This is the primary documented relationship, indicating that each transaction header in HXC_DEP_TRANSACTIONS can have multiple associated detail records storing the actual time entry attributes (e.g., hours, day, project code). This table is also a likely reference point for various Time and Labor APIs and public views that abstract the underlying transaction model for reporting and integration purposes.