Search Results xtr_portfolios




Overview
Explore in AI Chat

Overview

The XTR_PORTFOLIOS table is a core master data table within the Oracle E-Business Suite (EBS) Treasury (XTR) module. It serves as the definitive repository for defining and managing company portfolios. A portfolio in this context is a logical grouping of treasury transactions and instruments, such as foreign exchange deals, money market trades, or derivatives, used for management, reporting, and risk assessment. This table enables organizations to segregate their treasury activities by business unit, product line, currency, or risk strategy, providing a critical dimension for controlling and analyzing financial exposures. Its role is foundational, as it is referenced by transactional tables to categorize every deal booked within the system.

Key Information Stored

The table's structure is centered on uniquely identifying a portfolio within a specific company. Based on the provided metadata, the primary key is a composite of COMPANY_CODE and PORTFOLIO. This design enforces that a portfolio code is unique only within the context of a given company or legal entity. While the full column list is not detailed in the excerpt, the core columns logically include:

  • COMPANY_CODE: References the legal entity or company owning the portfolio, typically linked to an HR_ORGANIZATION_UNITS or similar table.
  • PORTFOLIO: The unique identifier (code) for the portfolio within the company.
  • Additional descriptive columns likely exist, such as a portfolio name (e.g., PORTFOLIO_NAME), status (e.g., ACTIVE_FLAG), and attributes for categorization, risk limits, or accounting rules.

Common Use Cases and Queries

The primary use case is to support all treasury deal entry and reporting by providing a valid portfolio for transaction assignment. A common operational query retrieves active portfolios for a company to populate a list of values during deal entry:

SELECT portfolio, portfolio_name FROM xtr_portfolios WHERE company_code = :p_company AND status = 'ACTIVE' ORDER BY portfolio;

For reporting and reconciliation, the table is frequently joined to transactional data. A fundamental query to summarize deal counts or amounts by portfolio would be:

SELECT p.company_code, p.portfolio, p.portfolio_name, COUNT(d.deal_number) AS deal_count FROM xtr_portfolios p, xtr_deals d WHERE p.company_code = d.company_code AND p.portfolio = d.portfolio_code GROUP BY p.company_code, p.portfolio, p.portfolio_name;

Portfolio data is also essential for generating risk reports, P&L statements, and compliance reports segmented by business activity.

Related Objects

As indicated by the foreign key metadata, XTR_PORTFOLIOS has a direct and critical relationship with the main transactional table in the Treasury module.

  • XTR_DEALS: This is the principal related object. The foreign key from XTR_DEALS (columns COMPANY_CODE, PORTFOLIO_CODE) to XTR_PORTFOLIOS ensures that every deal is associated with a valid, pre-defined portfolio. This relationship is fundamental to the integrity of the treasury data model.
  • Other Transactional Tables: It is highly probable that other XTR transaction tables (e.g., for settlements, revaluations, or accounting entries) also reference XTR_PORTFOLIOS to maintain portfolio context throughout the transaction lifecycle.
  • Portfolio-Specific Setup Tables: The table may be referenced by configuration tables that define limits, approval hierarchies, or accounting rules at the portfolio level.