Results for “xtr_a_pro_param_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_A_PRO_PARAM_V is an APPS-owned database view in the Oracle E-Business Suite Treasury (XTR) module. It is registered in the EBS data dictionary with a status of VALID and is available across release levels 12.1.1 and 12.2.2. The view exposes parameter-driven configuration data used by Treasury processing logic, presenting a clean, uniquely-filtered projection of the underlying parameter store. Its naming convention follows the ETRM standard: the "XTR" prefix identifies the Treasury product, "A_" denotes an application-level (non-transactional) table, and the "_V" suffix marks the object as a view rather than a base table.
Functionally, the view serves reporting, integration, and diagnostic purposes. Parameters stored in Treasury control behaviours such as processing defaults, validation thresholds, and reference values consumed by Treasury programs. Because XTR_A_PRO_PARAM_V consolidates these settings into a queryable structure, it can be used in custom reports, concurrent program lookups, and interface extracts without requiring direct access to the base parameter table.
Underlying Base Objects
The view is defined over a single documented base object: the synonym XTR_A_PRO_PARAM. The view text is a straightforward projection:
- SELECT UNIQUE_REF_NUM, PARAM_NAME, PARAM_VALUE, PARAM_TYPE, UPDATED_ON, UPDATED_BY, DESCRIPTION, AUDIT_INDICATOR, AUDIT_DATE_STORED, CREATED_BY, CREATED_ON FROM XTR_A_PRO_PARAM
No joins, filters, or aggregation clauses are applied in the view definition. Consequently, the row set returned by XTR_A_PRO_PARAM_V mirrors the contents of the underlying synonym exactly. The purpose of the view is therefore standardisation and encapsulation rather than data transformation: it presents the parameter store under the ETRM "_V" naming convention and decouples dependent reports and interfaces from direct references to the base table.
Key Columns
The view exposes the following columns, each inherited directly from XTR_A_PRO_PARAM:
- UNIQUE_REF_NUM – Numeric reference identifier for the parameter record; the primary logical key used to link a parameter to its owning entity or context.
- PARAM_NAME – The name of the Treasury parameter. This is the column most frequently searched against when users query "param_type" scenarios, as it identifies which setting is being inspected.
- PARAM_VALUE – The current value assigned to the named parameter.
- PARAM_TYPE – Categorises the parameter, allowing values to be grouped by type (for example, by functional area or data class) and enabling type-driven filtering and reporting.
- DESCRIPTION – Free-text description clarifying the purpose of the parameter.
- UPDATED_ON / UPDATED_BY – Audit columns recording when and by whom the row was last modified.
- AUDIT_INDICATOR / AUDIT_DATE_STORED – Flags and timestamps supporting the Treasury audit trail for parameter changes.
- CREATED_BY / CREATED_ON – Standard EBS WHO columns capturing row creation context.
Common Use Cases and Queries
Because the view contains no filtering, queries executed against it behave identically to queries against the base synonym, but remain insulated from any future change to the underlying object. Typical usages include retrieving a specific parameter value, listing all parameters of a given type, and auditing recent configuration changes.
- Retrieve a specific parameter:
SELECT param_name, param_value, param_type FROM xtr_a_pro_param_v WHERE param_name = :p_name; - List parameters by type (the common "param_type" search pattern):
SELECT unique_ref_num, param_name, param_value FROM xtr_a_pro_param_v WHERE param_type = :p_type ORDER BY param_name; - Audit recent changes:
SELECT param_name, param_value, updated_by, updated_on FROM xtr_a_pro_param_v WHERE audit_indicator = 'Y' ORDER BY updated_on DESC;
These patterns make XTR_A_PRO_PARAM_V a practical access point for Treasury configuration data in custom reports, diagnostic scripts, and integration extracts across both 12.1.1 and 12.2.2 environments.
-
View: XTR_A_PRO_PARAM_V 12.2.2
APPS.XTR_A_PRO_PARAM_V·↳ XTR_A_PRO_PARAM·Explore XTR module →
-
View: XTR_A_PRO_PARAM_V 12.1.1
APPS.XTR_A_PRO_PARAM_V·↳ XTR_A_PRO_PARAM·Explore XTR module →
-
VIEW: APPS.XTR_A_PRO_PARAM_V 12.1.1
-
VIEW: APPS.XTR_A_PRO_PARAM_V 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96