Results for “transfer_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_RGM_DIS_SRC_HDRS is a transactional header table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the details of the source organization from which a distribution transaction originates. In the context of the Oracle EBS regional localization for Asia/Pacific (notably India, where distribution and statutory reporting requirements demand detailed transfer tracking), this table functions as the originating side of a distribution movement, pairing with its destination counterpart, JAI_RGM_DIS_DES_HDRS, to form a complete distribution transaction record.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is satellite-leaning. This suggests it should be modeled as a descriptive satellite attached to a distribution transaction hub, with the TRANSFER_ID acting as the durable business key linking it to related header, tax, and destination records. The table is documented as VALID in the ETRM metadata and carries a documented physical schema of 15 columns.

Key Information Stored

The table is anchored by a surrogate primary key, JAI_RGM_DIS_SRC_HDRS_PK, defined on the TRANSFER_ID column. TRANSFER_ID is the sole documented unique index and therefore the primary business-key candidate and the principal join column across all related distribution records.

The most significant columns include:

• TRANSFER_ID — The primary key and business identifier for the distribution transfer header.
• TRANSFER_NUMBER — The user-facing document number for the distribution transaction.
• TRANSACTION_DATE — The effective date of the distribution movement.
• SETTLEMENT_ID — Foreign key to JAI_RGM_SETTLEMENTS, linking the transfer to its settlement record.
• PARTY_ID — Foreign key to HZ_PARTIES, identifying the trading partner or party associated with the source.
• PARTY_TYPE — Classifies the nature of the associated party.
• LOCATION_ID — Foreign key to HR_LOCATIONS_ALL, specifying the physical source location.
• SERVICE_TYPE_CODE — Indicates the service or distribution type applicable to the transaction.
• TRANSFER_TYPE — Categorizes the transfer (for example, by movement or statutory classification).
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the record and when.

Common Use Cases and Queries

This table is queried primarily in distribution reporting, statutory localization reporting, and reconciliation between source and destination sides of a transfer. A typical pattern joins the source header to its destination counterpart to reconstruct the full movement:

• Retrieving a distribution transaction by document number: SELECT * FROM JA.JAI_RGM_DIS_SRC_HDRS WHERE TRANSFER_NUMBER = :p_number;
• Listing source headers with their settlement details: SELECT s.TRANSFER_ID, s.TRANSFER_NUMBER, s.TRANSACTION_DATE, t.SETTLEMENT_ID FROM JA.JAI_RGM_DIS_SRC_HDRS s, JA.JAI_RGM_SETTLEMENTS t WHERE s.SETTLEMENT_ID = t.SETTLEMENT_ID;
• Pairing source and destination headers: SELECT sh.TRANSFER_ID, sh.TRANSFER_NUMBER, dh.TRANSFER_ID AS DES_ID FROM JA.JAI_RGM_DIS_SRC_HDRS sh, JA.JAI_RGM_DIS_DES_HDRS dh WHERE sh.TRANSFER_ID = dh.TRANSFER_ID;
• Resolving the source location and party for a transaction: joining LOCATION_ID to HR_LOCATIONS_ALL and PARTY_ID to HZ_PARTIES.
• Extracting source-side tax details via JAI_RGM_DIS_SRC_TAXES for statutory reporting.

Related Objects

The table participates in a defined network of related EBS objects:

• JAI_RGM_SETTLEMENTS — Joined via SETTLEMENT_ID; supplies settlement information for the transfer.
• HR_LOCATIONS_ALL — Joined via LOCATION_ID; provides the source organization's physical location.
• HZ_PARTIES — Joined via PARTY_ID; supplies trading-party details.
• JAI_RGM_DIS_DES_HDRS — The destination header, referencing this table by TRANSFER_ID; completes the distribution movement.
• JAI_RGM_DIS_SRC_TAXES — References this table by TRANSFER_ID; holds source-side tax lines for the transaction.