Results for “trx_type_class”

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

Overview

IGI_STP_PACKAGES_ALL is a transactional table in the IGI (Public Sector Financials International) product family of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. The table stores information on Single Third Party (STP) netting transactions, which support netting arrangements in which a public sector entity consolidates reciprocal receivable and payable positions with a third-party counterparty into a single settlement package. Each row represents a netting package line/record within a batch, capturing the amount, currency, accounting context, and the accounting flexfield distributions required to post the netting entry.

Under Data Vault modeling heuristics inferred from its foreign-key structure, IGI_STP_PACKAGES_ALL is classified as satellite-leaning. Its dependency on IGI_STP_BATCHES_ALL (via IGI_STP_PACKAGES_ALL_BATCH_ID) indicates it functions as descriptive, transaction-level detail attached to a batch parent rather than as an independent hub or pure link. The table is owned by the IGI schema and, per the documented 12.2.2 physical schema, contains 36 columns.

Key Information Stored

The most business-significant columns are:

• BATCH_ID and IGI_STP_PACKAGES_ALL_BATCH_ID — the batch linkage; both tie the package record to IGI_STP_BATCHES_ALL, with the latter documented as the formal foreign key column.
• PACKAGE_ID — the internal package identifier, the primary surrogate key candidate for the row.
• STP_ID — identifies the Single Third Party netting transaction this package line relates to.
• SITE_ID — the operating site/party context for the netting entry.
• APPLICATION — the source application from which the netting transaction originated.
• AMOUNT and CURRENCY_CODE — the entered transaction amount and its currency.
• MRC_AMOUNT and the MRC_* columns (MRC_EXCHANGE_RATE, MRC_EXCHANGE_RATE_TYPE, MRC_EXCHANGE_DATE, MRC_EXCHANGE_STATUS) — the reporting (MRC) currency equivalent and the exchange-rate attributes used for revaluation.
• EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE — the transactional currency conversion details.
• TRX_NUMBER, REFERENCE, RELATED_TRX_NUMBER, PACKAGE_NUM — business identifiers and cross-references used to trace the netting package and its related transactions.
• TRX_TYPE_CLASS, LINE_TYPE_LOOKUP_CODE, DOC_CATEGORY_CODE, NETTING_TRX_TYPE_ID — classification and lookup values that determine the accounting and document treatment.
• ACCT_PAY_CODE_COMBINATION_ID, REC_CODE_COMBINATION_ID, TECHNICAL_CCID, REC_OR_LIAB_CCID — the accounting flexfield combinations (CCIDs) that drive the payable, receivable, and liability postings.
• ACCOUNTING_DATE — the date used for accounting entry generation.
• ORG_ID — the multi-org operating unit identifier, a standard partitioning business key.
• WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for audit and concurrency.

Common Use Cases and Queries

Typical reporting centers on package contents per batch, netting amounts by currency and site, and account distribution validation. A common pattern joins the package table to its batch parent:

• Batch reconciliation: SELECT p.PACKAGE_ID, p.PACKAGE_NUM, p.TRX_NUMBER, p.AMOUNT, p.CURRENCY_CODE FROM IGI.IGI_STP_PACKAGES_ALL p, IGI.IGI_STP_BATCHES_ALL b WHERE p.IGI_STP_PACKAGES_ALL_BATCH_ID = b.BATCH_ID.
• Currency/MRC reporting: aggregate AMOUNT versus MRC_AMOUNT by CURRENCY_CODE and ORG_ID to identify revaluation differences.
• Accounting validation: query ACCT_PAY_CODE_COMBINATION_ID, REC_CODE_COMBINATION_ID, and REC_OR_LIAB_CCID for packages missing valid distributions or unbalanced postings.
• Audit and traceability: filter on TRX_NUMBER, RELATED_TRX_NUMBER, or REFERENCE to follow a netting transaction across its package lines.

Related Objects

The principal related objects, grounded in documented relationships and standard IGI netting design, include:

• IGI_STP_BATCHES_ALL — the parent batch table; joined via IGI_STP_PACKAGES_ALL.IGI_STP_PACKAGES_ALL_BATCH_ID = IGI_STP_BATCHES_ALL.BATCH_ID (documented foreign key).
• GL_CODE_COMBINATIONS — referenced through ACCT_PAY_CODE_COMBINATION_ID, REC_CODE_COMBINATION_ID, TECHNICAL_CCID, and REC_OR_LIAB_CCID for account validation and reporting.
• FND_LOOKUP_VALUES — supplies descriptions for LINE_TYPE_LOOKUP_CODE and related lookup codes.
• FND_CURRENCIES and GL_DAILY_RATES — support currency and exchange-rate interpretation of CURRENCY_CODE and EXCHANGE_RATE.
• HR_OPERATING_UNITS / ORG_ORGANIZATION_DEFINITIONS — resolve ORG_ID to an operating unit name.
• IGI_STP_TRANSACTIONS (where present) — provides the STP_ID/TRX_NUMBER context for the underlying Single Third Party transaction.