Results for “calc_basis”

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

Overview

XTR_A_PRODUCT_TYPES_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the configured product types that drive Treasury deal processing, including the advice-generation flags that control whether confirmation and settlement advices are produced for a given product. In the ETRM (Enterprise Treasury Risk Management) data model, this view functions as the reporting and integration layer over the XTR_A_PRODUCT_TYPES base table, presenting product type definitions in a stable, query-friendly format for downstream consumers.

The view carries no transformation or filtering logic beyond column projection: it selects a defined set of attributes directly from the base table. This design makes it a canonical, low-risk read interface for reports, concurrent programs, interfaces, and integration extracts that need product-level Treasury configuration without depending on the full column set of the underlying table. Because the column list is fixed and documented, integrations can rely on a consistent contract across releases.

Underlying Base Objects

The view is defined over a single base object, XTR_A_PRODUCT_TYPES, which is accessed through a synonym in the APPS schema. All columns exposed by the view originate from that table; no joins, aggregations, or subqueries are present in the view text. As a result, the view inherits the base table's row-level semantics directly. Any DML or configuration changes made to XTR_A_PRODUCT_TYPES — for example, adding a new Treasury product type or toggling an advice flag — are immediately visible through the view without refresh or materialization. Both the view and the base table reside in APPS, so standard EBS schema privileges and the APPS synonym layer govern access.

Key Columns

• DEAL_TYPE — Identifies the Treasury deal category to which the product type belongs (for example, money market, FX, or debt instrument classes).
• PRODUCT_TYPE — The product type code that uniquely identifies the instrument configuration within the deal type.
• PRODUCT_DESC — Descriptive text for the product type, used in reports and user-facing listings.
• PRODUCT_AUTH — Authorization indicator controlling whether the product type can be used in deal entry.
• CALC_BASIS — The calculation basis applied for interest or yield computations on the product.
• CPARTY_ADVICE — Flag indicating whether a counterparty advice is generated for the product type.
• CLIENT_ADVICE — The column matching the user's search term; indicates whether a client advice is generated for the product type.
• REVAL_CROSS_REF — Cross-reference used in revaluation processing.
• AUDIT_INDICATOR, AUDIT_DATE_STORED — Audit trail fields capturing whether auditing applies and when the audit date was recorded.
• CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON — Standard EBS who/when audit columns.

Common Use Cases and Queries

The most frequent use is validating advice configuration. The following query lists all product types with client advice enabled:

SELECT product_type, product_desc, deal_type
FROM apps.xtr_a_product_types_v
WHERE client_advice = 'Y';

Integration and reconciliation extracts typically select the full auditable column set:

SELECT deal_type, product_type, calc_basis, cparty_advice, client_advice,
       created_by, created_on, updated_by, updated_on
FROM apps.xtr_a_product_types_v
WHERE product_auth = 'Y';

Other scenarios include populating value sets or lookup lists for Treasury deal entry, auditing changes to advice generation over time via UPDATED_ON, and feeding downstream confirmation systems that must know which products trigger counterparty versus client advice. Because the view is a simple projection with no filtering, all product types — including unauthorized or legacy configurations — are returned, so queries should apply PRODUCT_AUTH or DEAL_TYPE predicates as required.