Results for “calc_type”

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

Overview

XTR_DEDUCTION_CALCS_V is a reporting view in the Oracle E-Business Suite Treasury (XTR) module, owned by the APPS schema and marked VALID in both 12.1.1 and 12.2.2 environments. The view exposes the deduction calculation setup definitions maintained by Treasury, presenting each deduction calculation rule together with the calculation type it belongs to, the amount type it produces, the basis against which the calculation is applied, a descriptive text field, and the deal type it serves. In effect, the view is a denormalized, read-only projection of the XTR_DEDUCTION_CALCS base table, which stores the configuration of automatic deductions applied to Treasury deals such as money market instruments, foreign exchange contracts, and loans.

The view plays a configuration-reference role rather than a transactional one. It is typically consumed by concurrent programs, validation logic, and custom reports that need to resolve how a particular deduction amount should be computed — for example, whether a charge is assessed on a percentage or flat basis, and what measure (such as principal or interest) forms the calculation basis. Because the view is a simple projection over the base table, it carries no additional filtering or aggregation, making it a straightforward and reliable source for lookup-style queries.

Underlying Base Objects

According to the documented view text, XTR_DEDUCTION_CALCS_V is defined as a direct SELECT over XTR_DEDUCTION_CALCS, referenced in the ETRM metadata as a synonym in the APPS schema. The view text selects five columns — CALC_TYPE, AMOUNT_TYPE, CALC_BASIS, DESCRIPTION, and DEAL_TYPE — from that base table with no WHERE clause, joins, or expressions. There is therefore a one-to-one relationship between rows in the base table and rows in the view. Any insert, update, or delete performed through the base table is immediately visible in the view, and the view itself is not updateable unless an INSTEAD OF trigger were added (none is documented). Because the synonym XTR_DEDUCTION_CALCS resolves to the underlying Treasury table in the same schema, the view inherits the base table's security and any row-level access restrictions applied to the APPS schema.

Key Columns

• CALC_TYPE — Identifies the category or method of the deduction calculation, distinguishing how the deduction rule is classified within Treasury setup.
• AMOUNT_TYPE — Indicates the type of amount the calculation yields or operates on, such as a charge, fee, or adjustment amount.
• CALC_BASIS — The calculation basis: the measure or reference value against which the deduction is computed (for example, principal, interest, or notional). This is the column most frequently referenced when users search for "calc_basis" in the context of deduction setup.
• DESCRIPTION — Free-text description of the deduction calculation rule, used for identification in setup and reporting.
• DEAL_TYPE — The Treasury deal type to which the calculation rule applies, linking the deduction configuration to the relevant instrument category.

Common Use Cases and Queries

The view is commonly queried during configuration review, integration mapping, and reconciliation between Treasury setup and downstream accounting or reporting. A typical lookup returns all deduction calculations for a given deal type:

SELECT calc_type, amount_type, calc_basis, description
FROM apps.xtr_deduction_calcs_v
WHERE deal_type = :p_deal_type;

To audit which calculation bases are in use across all configured deductions, a distinct query is useful:

SELECT DISTINCT calc_basis
FROM apps.xtr_deduction_calcs_v;

Integration and validation routines frequently select the full row for a specific calculation type to confirm that the amount type and basis are consistent before a deal is processed. Because the view carries no filtering logic, these queries are inexpensive and suitable for high-frequency validation use within concurrent programs.