Search Results xtr_deduction_calcs_u1

Overview

XTR.XTR_DEDUCTION_CALCS is a seeded reference table in the Oracle E-Business Suite Treasury (ETRM) module, owned by the XTR schema. It stores the pre-defined deduction calculation methods that drive the setup of tax and brokerage schedules. Each row defines how withholding tax and brokerage settlement amounts are derived for a given combination of deal type, amount type, calculation basis, and calculation type. Because it is stored in the APPS_TS_SEED tablespace, the table is treated as seeded configuration data rather than transactional data, and it is shipped with standard EBS content that installations extend or supplement as required.

Under the Oracle ETRM schema, the table is a foundational driver for rule-based deduction logic: downstream schedule setup records reference a valid calculation method defined here, ensuring that tax and brokerage computations resolve consistently across deals. From a Data Vault modeling perspective, the table's low-volume enumeration plus its single dependency from a setup table indicate that it behaves as a hub-leaning reference object. Its surrogate primary key — XTR_DEDUCTION_CALCS_PK on (DEAL_TYPE, AMOUNT_TYPE, CALC_BASIS, CALC_TYPE) — is the technically unique key, while the unique index XTR_DEDUCTION_CALCS_U1 on (DEAL_TYPE, AMOUNT_TYPE, CALC_BASIS, CALC_TYPE, ZD_EDITION_NAME) is the business-key candidate because it accounts for the Zero-Downtime edition discriminator.

Key Information Stored

• DEAL_TYPE — Code identifying the high-level deal category to which the deduction method applies; part of both the primary key and the unique business key.
• AMOUNT_TYPE — Code identifying the purpose of the amounts for a deal type (for example withholding or brokerage components).
• CALC_BASIS — The basis on which the deduction is calculated, such as a percentage or flat amount against a given base.
• CALC_TYPE — The calculation type governing the arithmetic performed for the deduction.
• DESCRIPTION — A 30-character textual description of the deduction calculation for reporting and setup clarity.
• ZD_EDITION_NAME — Edition discriminator supporting Oracle's online patching and edition-based redefinition model; part of the unique index XTR_DEDUCTION_CALCS_U1.

The table contains six documented columns. The natural composite key is the four business attributes (DEAL_TYPE, AMOUNT_TYPE, CALC_BASIS, CALC_TYPE); ZD_EDITION_NAME is an additional uniqueness qualifier rather than a business key per se, and DESCRIPTION is descriptive only. No single surrogate numeric ID is exposed; the primary key is the full natural composite.

Common Use Cases and Queries

The most frequent use is validating or listing available calculation methods before configuring tax and brokerage schedules. A typical query enumerates the seeded calculation methods for a given deal type:

• Lookup of all deduction methods for a deal type: SELECT amount_type, calc_basis, calc_type, description FROM xtr.xtr_deduction_calcs WHERE deal_type = :deal_type;
• Join to schedule setup to confirm that configured deductions resolve to a valid calculation method, using DEAL_TYPE as the common column with XTR_TAX_BROKERAGE_SETUP.
• Data-correctness audit that the unique business key is honored per edition: SELECT deal_type, amount_type, calc_basis, calc_type, COUNT(*) FROM xtr.xtr_deduction_calcs GROUP BY 1,2,3,4 HAVING COUNT(*) > 1;
• Reporting the description set used across all configured methods for a deal type to drive user-facing LOVs and setup screens.
• Extract of the seeded baseline into a comparison report against a target environment during upgrades or patches, keyed on the composite natural key.

Related Objects

• XTR_TAX_BROKERAGE_SETUP — The principal dependent table; its DEAL_TYPE foreign key references XTR_DEDUCTION_CALCS, linking each setup record to its deduction calculation method.
• XTR_DEDUCTION_CALCS# — The editioning view (or synonym target) used by the runtime layer, reflecting the current edition of the table.
• XTR_DEDUCTION_CALCS_PK — The composite primary key on (DEAL_TYPE, AMOUNT_TYPE, CALC_BASIS, CALC_TYPE), guaranteed by the unique index XTR_DEDUCTION_CALCS_U1.
• Tax and brokerage schedule setup screens in the ETRM module, which populate and validate against this table when defining schedules.
• Seeded reference data scripts delivered with EBS that insert the standard calculation methods into APPS_TS_SEED.

The table does not reference any other database objects; it is a reference source consumed by schedule configuration and settlement processing.