Results for “limit_weighting”

44 results




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

Overview

XTR_FX_PERIOD_WEIGHTINGS_V is an Oracle E-Business Suite database view owned by the APPS schema and delivered as part of the XTR (Treasury) product family. The view exposes foreign exchange period weighting definitions, which are the business rules used by Oracle Treasury to distribute limit consumption across time buckets of varying length. Rather than treating every exposure month as equally weighted, Treasury permits an exposure period to be assigned a weighting factor for a defined number of months. The view presents this configuration data in a normalized, read-only form suitable for reporting, integration, and diagnostic queries.

The object carries a VALID status in Oracle EBS 12.1.1 and 12.2.2. Users typically encounter it when investigating treasury limit configuration, particularly when searching on the column LIMIT_WEIGHTING, since that column name is the primary searchable attribute and frequently appears in troubleshooting and audit scripts.

Underlying Base Objects

The documented view text is a straightforward projection over a single base object:

  • XTR_FX_PERIOD_WEIGHTINGS — accessed in the view definition through the synonym XTR_FX_PERIOD_WEIGHTINGS (SYNONYM), which resolves to the APPS-owned base table.

Because there is no join, aggregation, or filter in the view definition, the view is effectively a thin security and naming layer over the base table. Row counts and cardinality match the base table exactly, and no DML is possible through the view. Any maintenance of weighting records must be performed against the base table itself or through the Treasury setup forms that maintain it.

The SELECT list preserves the four columns of the base table in their original order, without renaming or datatype conversion:

Key Columns

The view exposes four columns that together form the natural key and value pair of the weighting rule:

  • DEAL_TYPE — The treasury deal type to which the weighting applies, for example money market, foreign exchange, or swap instruments. This column scopes the rule to a specific category of transactions.
  • DEAL_SUBTYPE — A finer classification within the deal type. Combined with DEAL_TYPE, it identifies the precise instrument family governed by the weighting.
  • NOS_MONTHS — The number of months in the period bucket being weighted. This establishes the duration segment to which the weighting factor is applied.
  • LIMIT_WEIGHTING — The multiplier applied to the exposure amount when computing weighted limit consumption for the corresponding DEAL_TYPE, DEAL_SUBTYPE, and NOS_MONTHS combination. This is the value most often queried and audited.

Common Use Cases and Queries

Treasury administrators, auditors, and integration developers use this view to verify that period weighting rules are configured consistently across deal types before limit processing runs. A common diagnostic query retrieves all rules for a given instrument family:

SELECT DEAL_TYPE, DEAL_SUBTYPE, NOS_MONTHS, LIMIT_WEIGHTING FROM XTR_FX_PERIOD_WEIGHTINGS_V ORDER BY DEAL_TYPE, DEAL_SUBTYPE, NOS_MONTHS;

To locate a specific weighting value, or to confirm that no rule exceeds a threshold, the following pattern is typical:

SELECT DEAL_TYPE, DEAL_SUBTYPE, NOS_MONTHS, LIMIT_WEIGHTING FROM XTR_FX_PERIOD_WEIGHTINGS_V WHERE LIMIT_WEIGHTING > 1 ORDER BY LIMIT_WEIGHTING DESC;

Integration and reconciliation processes often extract the complete rule set for comparison against an external risk system:

SELECT DEAL_TYPE, DEAL_SUBTYPE, NOS_MONTHS, LIMIT_WEIGHTING FROM XTR_FX_PERIOD_WEIGHTINGS_V WHERE DEAL_TYPE = :p_deal_type;

Because the view is read-only and unjoined, these queries perform efficiently and can be safely executed during production hours. They are also useful for validating setup after a clone or upgrade between 12.1.1 and 12.2.2, since the underlying structure is unchanged across those releases.