Search Results xtr_time_restrictions




Overview
Explore in AI Chat

Overview

The XTR_TIME_RESTRICTIONS table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module. It serves as a master repository for defining and enforcing term limits, a critical control mechanism in treasury operations. The table's primary role is to establish the permissible maturity periods or tenors for specific types of financial deals, based on a combination of deal characteristics and counterparty. By storing these business rules, the table enables the system to validate proposed transactions, ensuring they comply with internal risk management policies and external regulatory requirements before execution. Its integrity is maintained through foreign key relationships to other master data tables within the XTR schema.

Key Information Stored

The table's structure is designed to uniquely identify a term limit rule and its associated parameters. The primary key is a composite of several columns, indicating the granularity at which rules are defined. The most significant columns include:

  • DEAL_TYPE and DEAL_SUBTYPE: Categorize the financial instrument (e.g., Foreign Exchange, Money Market).
  • CPARTY_CODE: Identifies the counterparty involved in the transaction.
  • SECURITY_NAME: Specifies the security type, relevant for certain deal categories.

While the specific limit columns (e.g., MINIMUM_TERM, MAXIMUM_TERM) are not detailed in the provided metadata, the table's description confirms it holds the term limits information itself, which would typically define allowable ranges in days, months, or years for the deal's tenor.

Common Use Cases and Queries

This table is central to pre-trade compliance checks. When a user initiates a new deal in the Treasury module, the application logic will query XTR_TIME_RESTRICTIONS to validate the proposed maturity date against the configured limits for that deal type, subtype, and counterparty. A common reporting use case is to audit and review all established term limit rules for governance purposes. A typical SQL query might retrieve the complete rule set or check a specific scenario:

SELECT deal_type, deal_subtype, cparty_code, security_name, minimum_term, maximum_term FROM xtr.xtr_time_restrictions WHERE deal_type = 'MM' ORDER BY cparty_code;

Another critical pattern involves joining this table with its referenced master data tables to produce more descriptive reports, linking codes to their meaningful names.

Related Objects

The XTR_TIME_RESTRICTIONS table does not exist in isolation; it is part of a tightly integrated master data model within the XTR product. As per the provided foreign key constraints, it has direct relationships with:

These relationships ensure that term limits can only be defined for valid, pre-existing deal classifications and product types. The table is also likely referenced by various application forms, validation APIs, and control reports within the Treasury module's workflow.