Search Results xtr_pro_param_u1

Overview

The XTR.XTR_PRO_PARAM table is a Treasury (ETRM) system configuration object in Oracle E-Business Suite. It stores the settings that govern the behavior of the Treasury module, with each row representing a single system parameter and its assigned value. The table corresponds directly to the System Parameter window in the Treasury application, meaning that changes made through that window are persisted as rows in this table. The object resides in the XTR schema, is designated as VALID, and is registered under FND Design Data as XTR.XTR_PRO_PARAM.

From a modeling perspective, the mined relationship data classifies this object as standalone, with no foreign key dependencies to other database objects. Under a Data Vault heuristic, this classification suggests the table functions as a hub-like reference entity: it holds business keys that are not linked via referential constraints to other transactional tables, and is instead consumed as a lookup for parameter resolution. Physical storage is in the APPS_TS_TX_DATA tablespace with PCT Free 10, while its unique indexes reside in APPS_TS_TX_IDX.

Key Information Stored

The documented schema contains eleven columns. The surrogate primary key is UNIQUE_REF_NUM, a NUMBER column that uniquely identifies each parameter row. The business-key candidate is PARAM_NAME, a VARCHAR2(50) column that appears in the unique index XTR_PRO_PARAM_U1 (PARAM_NAME, ZD_EDITION_NAME), which supports edition-aware uniqueness in Release 12.2.x.

• PARAM_NAME — the Treasury system parameter name; the primary business identifier.
• PARAM_VALUE — the current setting or value assigned to the parameter.
• PARAM_TYPE — the classification or data type of the parameter.
• DESCRIPTION — a VARCHAR2(250) description of the Treasury system parameter.
• UNIQUE_REF_NUM — numeric surrogate identifier and primary key.
• AUDIT_INDICATOR — documented as not currently used.
• UPDATED_BY, UPDATED_ON — audit columns capturing the last user and timestamp of modification.
• CREATED_BY, CREATED_ON — audit columns capturing the creating user and creation timestamp.
• ZD_EDITION_NAME — the editioning column supporting Edition-Based Redefinition in 12.2.x.

Common Use Cases and Queries

The principal use case is retrieving and reporting on Treasury system configuration. Administrators and support analysts query this table to confirm parameter values after changes are made in the System Parameter window, and to compare settings across environments. A typical retrieval is:

• SELECT PARAM_NAME, PARAM_TYPE, PARAM_VALUE, DESCRIPTION FROM XTR.XTR_PRO_PARAM ORDER BY PARAM_NAME;
• Locating a single setting: SELECT PARAM_VALUE FROM XTR.XTR_PRO_PARAM WHERE PARAM_NAME = :param_name;
• Audit reporting on recent changes: SELECT PARAM_NAME, PARAM_VALUE, UPDATED_BY, UPDATED_ON FROM XTR.XTR_PRO_PARAM WHERE UPDATED_ON >= :from_date;

Because the table is small and reference-oriented, it is commonly joined into Treasury configuration extract reports and reconciliation queries that verify parameter consistency before period-close activities in Treasury.

Related Objects

The metadata documents that XTR_PRO_PARAM does not reference any database object; its relationships are captured through the dependent objects that reference it.

• XTR_PRO_PARAM (APPS synonym) — the APPS-level synonym exposing the table to the application layer; joined on UNIQUE_REF_NUM and PARAM_NAME.
• XTR_AU_PRO_PARAM_T — an audit shadow table referencing XTR_PRO_PARAM, typically linked via UNIQUE_REF_NUM to capture historical changes to parameter rows.

As a standalone configuration object, most integration occurs at the application tier through the System Parameter window rather than through foreign keys. Downstream PL/SQL APIs and concurrent programs read PARAM_NAME and PARAM_VALUE to drive Treasury processing behavior.