Search Results hxc_mappings

Overview

The HXC_MAPPINGS table is a core repository for mapping definitions within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It serves as a master table that stores unique mapping configurations used to transform and translate timecard data. These mappings are fundamental to the processing rules that govern how time entry data is deposited to various Oracle applications, such as Payroll and Projects, and how it is retrieved and validated. The table's primary role is to provide a centralized, reusable definition that multiple Time and Labor processes can reference to ensure consistent data handling across different business rules and integration points.

Key Information Stored

The table's structure centers on a unique mapping identifier and name. The primary key, MAPPING_ID, is a unique numeric identifier for each mapping record. The NAME column, constrained by a unique key (HXC_MAPPINGS_UK1), holds the descriptive, user-recognizable name for the mapping configuration. While the provided metadata does not list all columns, the existence of foreign key relationships from several process tables indicates that HXC_MAPPINGS stores the foundational definition, while detailed mapping components and rules are stored in related child tables. The MAPPING_ID is the critical column used to join to these dependent objects.

Common Use Cases and Queries

This table is primarily accessed for setup, administration, and troubleshooting of Time and Labor processes. A common use case is identifying which mappings are used by specific deposit or retrieval processes during system configuration or an audit. For example, to list all mappings and their associated deposit processes, one would join HXC_MAPPINGS to HXC_DEPOSIT_PROCESSES. A typical diagnostic query might involve checking for mappings that are not currently in use by any process to identify obsolete configurations. Sample SQL to retrieve a basic list of mappings would be: SELECT mapping_id, name FROM hxc_mappings ORDER BY name;. Reporting often involves joining this table to its related usage tables to understand the full ecosystem of a specific mapping rule.

Related Objects

The HXC_MAPPINGS table has several key dependencies, as evidenced by its foreign key relationships. It is referenced as a parent table by the following critical Time and Labor objects:

• HXC_DEPOSIT_PROCESSES: Links via MAPPING_ID to define the mapping used for depositing timecard data to other applications.
• HXC_RETRIEVAL_PROCESSES: Links via MAPPING_ID to define the mapping used for retrieving data into timecards.
• HXC_TIME_ENTRY_RULES: Links via MAPPING_ID to associate a mapping with specific time entry validation and rule sets.
• HXC_MAPPING_COMP_USAGES: Links via MAPPING_ID; this child table likely stores the detailed components (like fields or attributes) that constitute the mapping definition.

These relationships confirm that HXC_MAPPINGS is a central control point for data transformation rules across the Time and Labor module.