Results for “hxc_retrieval_processes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HXC_RETRIEVAL_PROCESSES is a core configuration table within the Oracle Time and Labor Engine (HXC) schema. It defines named retrieval process definitions that control how time and labor data is collected and processed from external or internal time sources for a specific time recipient. Each row represents a single retrieval process instance, binding together a time recipient, a mapping, and a set of retrieval rules that govern how time data is fetched and transformed.

In Oracle EBS 12.1.1 and 12.2.2, HXC_RETRIEVAL_PROCESSES acts as the parent object for retrieval rules and retrieval ranges, meaning the process definition is the top-level container for the operational logic that drives time collection. From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning, suggesting the table may best be treated as a satellite that hangs off a hub or link (the time recipient and mapping associations), though this is a modeling suggestion rather than a documented physical characteristic.

Key Information Stored

The table contains eleven documented columns in the 12.2.2 physical schema. The most significant are:

• RETRIEVAL_PROCESS_ID — The surrogate primary key, defined by the HXC_RETRIEVAL_PROCESSES_PK unique index. Uniqueness is enforced on the combination of RETRIEVAL_PROCESS_ID and ZD_EDITION_NAME, which supports edition-based redefinition for online patching in 12.2.x.
• TIME_RECIPIENT_ID — Foreign key to HXC_TIME_RECIPIENTS, identifying the recipient for whom the process retrieves time.
• MAPPING_ID — Foreign key to HXC_MAPPINGS, linking the process to the mapping that translates source time data into the target structure.
• NAME — The business-facing name of the retrieval process, used in setup and administrative screens.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the application to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO (audit) columns capturing creation and modification metadata.
• ZD_EDITION_NAME — Edition identifier supporting Oracle's online patching architecture; it participates in the primary key's uniqueness constraint.

Note that RETRIEVAL_PROCESS_ID and ZD_EDITION_NAME together form the documented unique index. The business-key candidate is RETRIEVAL_PROCESS_ID alone in single-edition contexts, while the effective key includes the edition name in a multitenant or patched environment.

Common Use Cases and Queries

Administrators and developers query this table to audit which retrieval processes exist, which recipient and mapping each uses, and how processes relate to their retrieval rules. Typical scenarios include troubleshooting missing time data, verifying setup after a patch, and reporting on process configuration.

• Retrieve all processes for a recipient: SELECT retrieval_process_id, name FROM hxc_retrieval_processes WHERE time_recipient_id = :recipient_id;
• Join to mappings: SELECT p.retrieval_process_id, p.name, m.mapping_name FROM hxc_retrieval_processes p, hxc_mappings m WHERE p.mapping_id = m.mapping_id;
• Count rules per process: SELECT p.retrieval_process_id, COUNT(r.retrieval_rule_id) FROM hxc_retrieval_processes p, hxc_retrieval_rules r WHERE p.retrieval_process_id = r.retrieval_process_id GROUP BY p.retrieval_process_id;
• Audit recently changed configurations: SELECT * FROM hxc_retrieval_processes WHERE last_update_date > SYSDATE - 30;

Related Objects

The following objects have documented relationships to HXC_RETRIEVAL_PROCESSES:

• HXC_TIME_RECIPIENTS — Referenced via HXC_RETRIEVAL_PROCESSES.TIME_RECIPIENT_ID. Identifies the recipient of the retrieved time.
• HXC_MAPPINGS — Referenced via HXC_RETRIEVAL_PROCESSES.MAPPING_ID. Supplies the data transformation mapping.
• HXC_RETRIEVAL_RULES — Foreign table referencing HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID. Defines the individual retrieval rules for the process.
• HXC_RETRIEVAL_RANGES — Also references RETRIEVAL_PROCESS_ID, providing range definitions used during retrieval execution.

Together these tables form the retrieval configuration model within Time and Labor, with HXC_RETRIEVAL_PROCESSES serving as the central parent object linking recipients, mappings, rules, and ranges.