Search Results xtr_parcel_splits

Overview

XTR_PARCEL_SPLITS is a Treasury (XTR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores parcel split detail information for discounted securities deals. A "parcel" in ETRM terminology refers to a discrete tranche or portion of a discounted instrument (such as a treasury bill, commercial paper, or discount note) that has been carved out of a parent deal for separate tracking, selection, or resale. The table therefore acts as the operational ledger of how a given deal's face value has been subdivided, and which parcels remain available, reserved, selected, or partially consumed.

Under the heuristic Data Vault classification supplied in the metadata, XTR_PARCEL_SPLITS leans toward a satellite role. Its primary key is composite, combining the parent deal identifier with a parcel split sequence number, and it carries descriptive and mutable attributes (amounts, status, selection flags) rather than standing alone as a business hub. Modeling guidance would therefore place the true business hub at the deal level, with XTR_PARCEL_SPLITS attached as a dependent detail satellite keyed by DEAL_NO and PARCEL_SPLIT_NO.

Key Information Stored

The documented physical schema contains 19 columns. The most significant include:

DEAL_NO — Identifier of the parent discounted securities deal; part of the composite primary key and the FK to XTR_DEALS.
PARCEL_SPLIT_NO — Sequence number distinguishing each split within a deal; completes the primary key.
PARCEL_SIZE and FACE_VALUE_AMOUNT — The nominal size of the parcel and its associated face value.
ORIGINAL_AMOUNT — The original recorded amount for the parcel prior to subsequent selection or consumption.
PARCEL_REMAINING — The unallocated remainder, central to availability reporting.
CONSIDERATION — The discounted purchase consideration associated with the parcel.
INTEREST — Accrued or associated interest amount.
SELECT_NUMBER, OLD_SELECT_NUMBER, and SELECT_FV_AMOUNT — Selection tracking fields linking the parcel to selection events and the face value selected.
RESERVE_PARCEL and AVAILABLE_FOR_RESALE — Flags controlling whether the parcel is reserved or offered for resale.
SERIAL_NUMBER, SERIAL_NUMBER_IN, REFERENCE_NUMBER, and ISSUE_BANK — Instrument identification and issuer details.
DEAL_SUBTYPE and STATUS_CODE — Classification and lifecycle state of the split.

The surrogate primary key is XTR_PARCEL_SPLITS_PK (DEAL_NO, PARCEL_SPLIT_NO); the two columns together also serve as the natural business key.

Common Use Cases and Queries

Typical scenarios include reconciling parcel remainders against deal face value, identifying parcels available for resale, and tracing selection activity across a deal. A representative query lists all parcels for a deal with their outstanding balance:

SELECT deal_no, parcel_split_no, parcel_size, parcel_remaining, status_code FROM xtr_parcel_splits WHERE deal_no = :deal_no ORDER BY parcel_split_no;
SELECT deal_no, parcel_split_no, select_fv_amount FROM xtr_parcel_splits WHERE select_number IS NOT NULL AND available_for_resale = 'Y';
Aggregate remaining face value by deal: SELECT deal_no, SUM(parcel_remaining) FROM xtr_parcel_splits GROUP BY deal_no;

Related Objects

XTR_DEALS — Parent table; joined on XTR_PARCEL_SPLITS.DEAL_NO = XTR_DEALS.DEAL_NO.
XTR_ROLLOVER_TRANSACTIONS — References parcels via DEAL_NUMBER and PARCEL_SPLIT_NO, enabling rollover handling at parcel granularity.
XTR_PARCEL_SPLITS_PK — Primary key constraint enforcing uniqueness of DEAL_NO and PARCEL_SPLIT_NO.
Treasury deal and parcel inquiry forms and related selection/resale views that consume this detail.

Table: XTR_PARCEL_SPLITS 12.2.2
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_PARCEL_SPLITS, object_name:XTR_PARCEL_SPLITS, status:VALID, product: XTR - Treasury , description: Parcel split detail information for discounted securities deals , implementation_dba_data: XTR.XTR_PARCEL_SPLITS ,
Table: XTR_PARCEL_SPLITS 12.1.1
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_PARCEL_SPLITS, object_name:XTR_PARCEL_SPLITS, status:VALID, product: XTR - Treasury , description: Parcel split detail information for discounted securities deals , implementation_dba_data: XTR.XTR_PARCEL_SPLITS ,
View: XTR_P_SPLIT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:XTR.XTR_P_SPLIT_V, object_name:XTR_P_SPLIT_V, status:VALID, product: XTR - Treasury , implementation_dba_data: APPS.XTR_P_SPLIT_V ,
View: XTR_P_SPLIT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:XTR.XTR_P_SPLIT_V, object_name:XTR_P_SPLIT_V, status:VALID, product: XTR - Treasury , implementation_dba_data: APPS.XTR_P_SPLIT_V ,
View: XTR_PARCEL_SPLITS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:XTR.XTR_PARCEL_SPLITS_V, object_name:XTR_PARCEL_SPLITS_V, status:VALID, product: XTR - Treasury , implementation_dba_data: APPS.XTR_PARCEL_SPLITS_V ,
Table: XTR_ROLLOVER_TRANSACTIONS 12.1.1
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_ROLLOVER_TRANSACTIONS, object_name:XTR_ROLLOVER_TRANSACTIONS, status:VALID, product: XTR - Treasury , description: Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals , implementation_dba_data: XTR.XTR_ROLLOVER_TRANSACTIONS ,
View: XTR_PARCEL_SPLITS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:XTR.XTR_PARCEL_SPLITS_V, object_name:XTR_PARCEL_SPLITS_V, status:VALID, product: XTR - Treasury , implementation_dba_data: APPS.XTR_PARCEL_SPLITS_V ,
Table: XTR_ROLLOVER_TRANSACTIONS 12.2.2
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_ROLLOVER_TRANSACTIONS, object_name:XTR_ROLLOVER_TRANSACTIONS, status:VALID, product: XTR - Treasury , description: Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals , implementation_dba_data: XTR.XTR_ROLLOVER_TRANSACTIONS ,
Table: XTR_DEALS 12.2.2
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_DEALS, object_name:XTR_DEALS, status:VALID, product: XTR - Treasury , description: Information for all financial instrument deals except exposure transactions , implementation_dba_data: XTR.XTR_DEALS ,
Table: XTR_DEALS 12.1.1
owner:XTR, object_type:TABLE, fnd_design_data:XTR.XTR_DEALS, object_name:XTR_DEALS, status:VALID, product: XTR - Treasury , description: Information for all financial instrument deals except exposure transactions , implementation_dba_data: XTR.XTR_DEALS ,