Search Results xtr_parcel_splits




Overview
Explore in AI Chat

Overview

The XTR_PARCEL_SPLITS table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the transactional repository for storing detailed information related to the splitting of parcels for discounted securities deals. In treasury operations, a parcel represents a portion or lot of a security holding. This table is essential for managing the lifecycle of complex financial instruments, enabling the system to track and account for the division of these parcels over time, which is a common requirement for portfolio management, settlement, and accounting processes.

Key Information Stored

While the provided metadata does not list individual columns, the primary key structure and foreign key relationships define its critical data elements. The table is uniquely identified by a composite primary key consisting of DEAL_NO and PARCEL_SPLIT_NO. The DEAL_NO column links the split detail directly back to the parent transaction in the XTR_DEALS table. The PARCEL_SPLIT_NO is a sequence number that uniquely identifies each split record within a specific deal. The table's purpose is to store the granular details of each split event, which would typically include data points such as the original parcel identifier, the new split quantities, effective dates, associated cost bases, and references to the underlying security. This data is fundamental for accurate profit/loss calculation and audit trails.

Common Use Cases and Queries

The primary use case for this table is supporting the operational and reporting needs surrounding discounted securities where parcels are divided. A common business scenario involves generating a report of all parcel splits for a specific deal for reconciliation purposes. Another critical use is feeding data into the general ledger during the accounting process, where split details affect cost allocation. A typical analytical query would join this table to the master deal information to assess portfolio activity.

SELECT d.deal_no, d.deal_type, ps.parcel_split_no, ps.split_date, ps.original_parcel_id
FROM xtr_deals d,
     xtr_parcel_splits ps
WHERE d.deal_no = ps.deal_no
AND d.deal_no = :p_deal_number
ORDER BY ps.parcel_split_no;

Data from this table is also crucial for downstream processes like rollovers, as indicated by its foreign key relationship with XTR_ROLLOVER_TRANSACTIONS.

Related Objects

The XTR_PARCEL_SPLITS table is centrally connected to other key treasury tables through documented foreign key relationships.

  • XTR_DEALS: This is the parent table. The foreign key on XTR_PARCEL_SPLITS.DEAL_NO references XTR_DEALS, ensuring every parcel split is associated with a valid treasury deal.
  • XTR_ROLLOVER_TRANSACTIONS: This table has a foreign key referencing XTR_PARCEL_SPLITS. The columns XTR_ROLLOVER_TRANSACTIONS.DEAL_NUMBER and XTR_ROLLOVER_TRANSACTIONS.PARCEL_SPLIT_NO together reference the primary key of XTR_PARCEL_SPLITS, indicating that rollover transactions can be initiated against specific, split parcels.

These relationships enforce data integrity and are vital for constructing accurate joins in custom reports, interfaces, or data extracts for treasury analytics.