Search Results xtr_amount_actions




Overview
Explore in AI Chat

Overview

The XTR_AMOUNT_ACTIONS table is a core reference table within the Oracle E-Business Suite Treasury (XTR) module. It functions as a master control table that defines and governs the permissible financial actions or operations that can be performed on specific monetary amounts associated with different types of treasury deals. Its primary role is to enforce business rules by establishing a valid relationship between a deal type, an amount type, and an action code. This ensures data integrity and process consistency across the treasury management lifecycle, from deal capture and valuation to accounting and settlement in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key, which underscores its purpose as a validation entity. The key columns are DEAL_TYPE, AMOUNT_TYPE, and ACTION_CODE. The DEAL_TYPE column categorizes the financial instrument (e.g., Foreign Exchange, Money Market, Derivatives). The AMOUNT_TYPE specifies the nature of the monetary figure (e.g., Principal, Interest, Fee, Market Value). The ACTION_CODE defines the operation applicable to that amount for the given deal type, such as 'PAY', 'RECEIVE', 'ACCRUE', 'AMORTIZE', or 'REVALUE'. Together, these columns create a rule set dictating which actions are valid for specific amount categories within each deal class.

Common Use Cases and Queries

This table is predominantly used for validation and reference in transactional processing and reporting. A common use case is the validation of user entries during deal input or accounting event creation, where the system checks if a proposed action on an amount is permitted. For reporting, it is often joined to transactional tables to decode action codes. A typical query might retrieve all valid actions for a specific deal and amount type to populate a list of values (LOV) in an application form:

  • SELECT action_code FROM xtr_amount_actions WHERE deal_type = 'FXSPOT' AND amount_type = 'PRINCIPAL';

Another critical pattern involves joining XTR_AMOUNT_ACTIONS to the XTR_DEAL_DATE_AMOUNTS table to generate detailed deal schedules or accounting entries, ensuring only configured business logic is executed.

Related Objects

As indicated by its foreign key relationships, XTR_AMOUNT_ACTIONS is central to several key treasury tables. It is a parent table to XTR_DEAL_DATE_AMOUNTS, which stores the actual scheduled or historical cash flows and accounting amounts for deals, validating their ACTION_CODE. It is also a parent to XTR_JOURNAL_ENTRY_ACTIONS, which controls the accounting rules (mapping to GL accounts) for each valid action. Furthermore, the table references XTR_AMOUNT_TYPES via a foreign key on (DEAL_TYPE, AMOUNT_TYPE), confirming that the amount type is valid for the specified deal type. This network of relationships positions XTR_AMOUNT_ACTIONS as a crucial configuration point between deal types, financial amounts, and their downstream accounting treatment.