Results for “xtr_term_actions_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_TERM_ACTIONS_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 columns of the term action entity used by Treasury deal maintenance to record financial amendments applied to a deal over its life cycle. Term actions capture principal adjustments, interest rate reset or mass rate update events, coupon and maturity date changes, and payment schedule modifications, so that the full amendment history of a treasury deal (loan, deposit, or similar instrument) can be audited and replayed.
The view is a thin projection over the XTR_TERM_ACTIONS table and does not perform joins, aggregation, or filtering. Because its definition is a direct column list, it functions as a reporting and integration surface: concurrent programs, Oracle Reports, OBIEE extracts, and custom interfaces can select from XTR_TERM_ACTIONS_V to retrieve term action records without querying the base table directly. This indirection is consistent with Oracle EBS coding standards, which prefer views for read access so that underlying table structures may evolve while consuming code remains stable.
The name is significant to users searching for dual_authorisation_by. The view exposes both DUAL_AUTHORISATION_ON and DUAL_AUTHORISATION_BY, the columns that record whether a term action required dual (two-person) authorisation and which user performed that authorisation. This makes the view the natural source for segregation-of-duties and approval-trail reporting on treasury term actions.
Underlying Base Objects
The view is defined over a single documented base object, XTR_TERM_ACTIONS, referenced through a synonym. No other tables are joined in the view text, so all columns returned map one-to-one to columns of that base table. The relationship is therefore strictly hierarchical: one row in XTR_TERM_ACTIONS produces one row in XTR_TERM_ACTIONS_V, and no row multiplication or data transformation occurs.
XTR_TERM_ACTIONS itself is keyed at the term action level and is linked to the parent deal by DEAL_NO. Consumers requiring descriptive deal attributes, counterparty details, or currency information must join the view to the deal tables (for example, XTR_DEALS and related party or currency views) on DEAL_NO. Standard audit columns CREATED_BY and CREATED_ON are carried through from the base table and support change tracking and troubleshooting.
Key Columns
- DEAL_NO — Identifier of the treasury deal to which the term action applies; the principal join key to deal-level data.
- PRINCIPAL_ADJUST, PRINCIPAL_ACTION, PRINCIPAL_AMOUNT_TYPE, INCREASE_EFFECTIVE_FROM_DATE, NEW_PI_AMOUNT_DUE — Describe principal-related amendments, including the adjustment indicator, action taken, amount type, the date the increase takes effect, and the new principal and interest amount due.
- FROM_START_DATE, MATURITY_DATE — Start and maturity dates applicable after the term action, reflecting rollover or extension activity.
- PAYMENT_SCHEDULE_CODE, PAYMENT_FREQ, NEXT_COUPON_DATE — Payment and coupon schedule attributes changed by the action.
- NEW_INTEREST_RATE, EFFECTIVE_FROM_DATE, FIXED_UNTIL — Interest rate amendment details, including the new rate, when it becomes effective, and the date to which it remains fixed.
- DUAL_AUTHORISATION_ON, DUAL_AUTHORISATION_BY — Date/time of dual authorisation and the user who provided it; central to approval and access-control reporting.
- AUDIT_INDICATOR, MASS_RATE_UPDATE — Flags indicating audit status and whether the action originated from a mass rate update process rather than a single-deal amendment.
- CREATED_ON, CREATED_BY — Standard creation audit columns.
Common Use Cases and Queries
Typical uses include reconstructing the amendment history of a deal, auditing dual authorisation compliance, and validating mass rate update activity. A representative query retrieves all term actions for a deal:
SELECT deal_no, principal_action, effective_from_date, new_interest_rate, dual_authorisation_on, dual_authorisation_by FROM xtr_term_actions_v WHERE deal_no = :deal_no ORDER BY created_on;SELECT deal_no, dual_authorisation_by, dual_authorisation_on FROM xtr_term_actions_v WHERE dual_authorisation_by IS NOT NULL AND dual_authorisation_on >= :from_date;— approval-trail and segregation-of-duties reporting.SELECT deal_no, created_by, mass_rate_update, new_interest_rate FROM xtr_term_actions_v WHERE mass_rate_update = 'Y';— identification of actions generated by mass rate update processing.SELECT deal_no, maturity_date, next_coupon_date, payment_freq FROM xtr_term_actions_v WHERE maturity_date BETWEEN :start_date AND :end_date;— forward-dated maturity and coupon monitoring.
Because the view performs no filtering, queries should restrict rows by DEAL_NO, date range, or the dual authorisation columns to avoid full scans of XTR_TERM_ACTIONS. Oracle proprietary and confidential; refer to ETRM legal notices for distribution restrictions.
-
View: XTR_TERM_ACTIONS_V 12.2.2
APPS.XTR_TERM_ACTIONS_V·↳ XTR_TERM_ACTIONS·Explore XTR module →
-
View: XTR_TERM_ACTIONS_V 12.1.1
APPS.XTR_TERM_ACTIONS_V·↳ XTR_TERM_ACTIONS·Explore XTR module →
-
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.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
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.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96