Search Results xtr_ig_transfers_pkg




Overview
Explore in AI Chat

Overview

XTR_IG_TRANSFERS_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Treasury (ETRM) module. Its principal business function is to manage intergroup transfers — the movement of financial exposure, cash positions, or deals between distinct legal entities or groups within a corporate treasury structure. In Oracle Treasury, intergroup transfers allow a parent or central treasury entity to record and settle cross-entity obligations while preserving the applicable accounting and currency relationships.

The package supports the ingestion of intergroup transfer data from an open interface, validation of that data against treasury master and reference data, calculation of monetary and home-currency-equivalent (HCE) amounts, and the propagation of validated records into the base intergroup transfer tables. In Oracle EBS 12.1.1 and 12.2.2 it is a VALID database object and is classified as an API of type OTHER, meaning it is not a formally published public API but is invoked internally by ETRM programs and, in some implementations, by custom extensions.

Key Procedures and Functions

The package exposes 34 documented procedures and functions, which fall into three broad categories.

Tables Accessed

The package operates against a defined set of APPS synonyms, notably: XTR_INTERGROUP_TRANSFERS and XTR_DEALS_INTERFACE (the primary interface and destination tables for transfer records); XTR_DEALS_S and XTR_DEAL_DATE_AMOUNTS (deal header and dated amount data); XTR_ACCRLS_AMORT (accruals and amortization); XTR_AMOUNT_ACTIONS, XTR_DEALER_CODES, XTR_PARTY_INFO, XTR_BANK_ACCOUNTS, XTR_PRICE_MODELS, and XTR_MASTER_CURRENCIES_V (reference and master data used for validation and currency conversion); XTR_IG_JOURNAL_STRUCTURES and XTR_IG_JOURNAL_STRUCTURES_S (accounting journal generation for intergroup transfers); XTR_BATCHES and XTR_BATCH_EVENTS (batch processing control); and XTR_INTERFACE_ERRORS (error logging). It is additionally referenced by XTR_IMPORT_DEAL_DATA and XTR_WRAPPER_API_P.

Usage Notes

XTR_IG_TRANSFERS_PKG is typically invoked indirectly. The primary entry point is the deal import or intergroup transfer import flow, where a concurrent program or the wrapper API XTR_WRAPPER_API_P calls the package to validate and load staged interface records. Validation routines may also be called from Treasury forms during manual entry to provide immediate field-level checks. Custom code should invoke the package only with full awareness that it is an OTHER-classified API without documented parameter contracts; Oracle does not guarantee signature stability across patches. Customers upgrading between 12.1.1 and 12.2.2 should re-validate any custom dependencies, since underlying reference tables and journal structures may change.