Search Results hxc_retrieval_rule_comps




Overview
Explore in AI Chat

Overview

The HXC_RETRIEVAL_RULE_COMPS table is a core data structure within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC) for versions 12.1.1 and 12.2.2. It functions as a child table that stores the individual components or conditions that constitute a retrieval rule. Retrieval rules are critical for determining which timecard data is retrieved and displayed to a user based on specific criteria, such as their role or assignment. This table enables the modular construction of complex retrieval logic by linking specific time recipients (like employees or managers) to overarching retrieval rule definitions.

Key Information Stored

The table's primary purpose is to associate a retrieval rule with its constituent time recipients. The key columns, as indicated by the metadata, are the foreign keys that establish these relationships. The primary identifier for each row is the RETRIEVAL_RULE_COMP_ID. The two critical foreign key columns are RETRIEVAL_RULE_ID, which links to the parent rule definition in the HXC_RETRIEVAL_RULES table, and TIME_RECIPIENT_ID, which links to a specific recipient entity defined in the HXC_TIME_RECIPIENTS table. This structure allows a single retrieval rule to be composed of multiple components, each potentially pointing to a different time recipient.

Common Use Cases and Queries

This table is primarily accessed for system configuration, troubleshooting, and auditing retrieval rule setups. A common operational query would be to list all components for a specific retrieval rule to verify its configuration. For example:

  • SELECT retrieval_rule_comp_id, time_recipient_id FROM hxc_retrieval_rule_comps WHERE retrieval_rule_id = <RULE_ID> ORDER BY retrieval_rule_comp_id;

Another frequent use case involves diagnosing timecard visibility issues by joining to related tables to see which recipients are associated with a rule. Reporting may involve queries that aggregate component counts per rule or validate that all expected time recipients are correctly linked.

Related Objects

As defined by the foreign keys in the metadata, HXC_RETRIEVAL_RULE_COMPS has direct dependencies on two key parent tables:

  • HXC_RETRIEVAL_RULES: The parent table containing the master definition of the retrieval rule (e.g., rule name, type). The RETRIEVAL_RULE_ID column references this table.
  • HXC_TIME_RECIPIENTS: The reference table defining the entities (such as persons, groups, or roles) eligible to receive time data. The TIME_RECIPIENT_ID column references this table.

This table is integral to the retrieval rule engine, and any custom programs or interfaces that create or modify retrieval rules must populate this table accordingly to maintain system integrity.