Results for “yield_rounding”

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

Overview

XTR_DEAL_SUBTYPES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product module. It exposes the configuration of deal subtypes used throughout Treasury deal capture, deal lifecycle processing, and limit management. A deal subtype is the secondary classification applied beneath a deal type (for example, a foreign exchange deal type may carry subtypes such as spot, forward, swap, or option). Because Treasury uses the subtype as a controlling attribute for pricing behavior, authorization, tolerance checks, and limit consumption, the view serves as the canonical reference for applications, concurrent programs, and external interfaces that must resolve subtype-level rules without querying the base table directly.

The object is documented as VALID in both the 12.1.1 and 12.2.2 releases. The metadata confirms that the view is a thin projection over its base object: it does not perform aggregation, filtering, or joins, and it exposes every column required to interpret subtype setup. This makes it suitable both for online validation lookups and for bulk extraction into downstream reporting or integration layers.

Underlying Base Objects

The view is defined over a single base object, documented as the synonym XTR_DEAL_SUBTYPES. The view text selects directly from that synonym, with no WHERE clause, GROUP BY, or analytical function. Consequently, XTR_DEAL_SUBTYPES_V is a one-to-one, row-per-subtype representation of the underlying configuration table, and row counts between the view and the base object are identical. Because the view references a synonym, the physical table is resolved at runtime within the APPS schema context; implementations should therefore grant SELECT on the view rather than on the base table when exposing subtype setup to reporting users or integration accounts.

As with most XTR setup views, the object carries no materialization and no caching. Any change committed to the base table — for example, a revised tolerance or a toggled authorization flag — is immediately visible through the view, which is an important characteristic for Treasury environments where setup changes must take effect in the same business day.

Key Columns

• DEAL_TYPE — The parent deal type that the subtype belongs to; together with DEAL_SUBTYPE it forms the logical key of the record.
• DEAL_SUBTYPE — The internal subtype code used by Treasury processing logic.
• USER_DEAL_SUBTYPE — The user-facing or descriptive subtype identifier presented on Treasury forms and reports.
• NAME — The descriptive name of the subtype as displayed to users.
• LIMIT_WEIGHTING — The weighting factor applied when the subtype's exposure is consumed against Treasury limits.
• TOLERANCE — The permitted tolerance threshold used during deal validation.
• AUTHORISED — Flag indicating whether the subtype may be used for authorized deal entry.
• PRICE_ROUNDING — The rounding convention applied to prices for deals of this subtype.
• YIELD_ROUNDING — The rounding convention applied to yields. This is the column most directly relevant to searches for "yield_rounding," and it governs how computed yield values are rounded when stored or displayed for deals assigned to the subtype.
• SEEDED_DESCRIPTION — The description supplied by Oracle for seeded subtypes, distinguishing delivered configuration from user-defined entries.
• UPDATED_BY — The user identifier of the last person to modify the subtype record, supporting audit and change-review requirements.

Common Use Cases and Queries

Typical uses include validating that a subtype is authorized before allowing deal entry, retrieving the limit weighting applied to a subtype during exposure calculations, and extracting rounding conventions for downstream pricing or yield-curve processing. The YIELD_ROUNDING column is frequently queried when reconciling discrepancies between calculated and displayed yields, because the value stored here determines how Treasury rounds yield figures for the subtype.

The following query lists all authorized subtypes together with their price and yield rounding settings:

• SELECT DEAL_TYPE, DEAL_SUBTYPE, USER_DEAL_SUBTYPE, NAME, PRICE_ROUNDING, YIELD_ROUNDING FROM XTR_DEAL_SUBTYPES_V WHERE AUTHORISED = 'Y' ORDER BY DEAL_TYPE, DEAL_SUBTYPE;

To inspect limit and tolerance configuration for a specific deal type:

• SELECT DEAL_SUBTYPE, NAME, LIMIT_WEIGHTING, TOLERANCE, SEEDED_DESCRIPTION FROM XTR_DEAL_SUBTYPES_V WHERE DEAL_TYPE = :p_deal_type;

Because the view performs no transformation, these queries can be joined directly to deal, limit, and exposure tables on DEAL_TYPE and DEAL_SUBTYPE without intermediate staging, making the view a reliable foundation for Treasury reporting and integration extracts in both 12.1.1 and 12.2.2.