Results for “igi_stp_net_type_alloc_all”

38 results




Overview
Explore in AI Chat

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

Overview

The IGI_STP_NET_TYPE_ALLOC_ALL table is a core configuration object within the IGI – Public Sector Financials International module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It stores the netting type allocations associated with each netting transaction type, effectively defining how receivable transactions are grouped, classified, and mapped to General Ledger allocation definitions during the netting and settlement process used by public sector agencies. In practical terms, the table acts as the bridge between a netting transaction type definition in Receivables and the allocation mechanism maintained in the General Ledger, allowing organizations to route specific customer transaction types and document categories to a designated allocation, expense account, or netting expense code combination.

From a dimensional modeling perspective, the metadata classifies this object heuristically as standalone within the Data Vault framework. That classification is a modeling suggestion rather than a strictly enforced construct: the table possesses recognizable foreign key relationships to two parent entities yet does not sit as a pure hub, link, or satellite in a classic Data Vault sense. Analysts building a warehouse layer on top of EBS would typically treat it as a configuration or reference table, potentially modeled as a link between the customer transaction type and GL allocation hubs, with the remaining attribute columns forming an associated satellite.

Key Information Stored

The table contains 13 documented columns. The following are the most significant for functional and integration purposes:

  • NETTING_TRX_TYPE_ID – Identifies the parent netting transaction type that owns the allocation mapping; this is the principal business discriminator.
  • CUST_TRX_TYPE_ID – Foreign key to RA_CUST_TRX_TYPES_ALL, indicating the Receivables transaction type to which the allocation applies.
  • ALLOC_ID – Foreign key to GL_ALOC_MST, the General Ledger allocation definition driving the netting allocation rules.
  • NETTING_EXPENSE_CCID – Code combination identifier for the netting expense account charged or credited during allocation.
  • APPLICATION – Identifies the owning application context (typically Receivables or General Ledger).
  • TRX_TYPE_CLASS – Classifies the transaction type being netted, such as invoice, credit memo, or debit memo.
  • DOC_CATEGORY_CODE – Document category used to further refine which documents fall within the allocation.
  • ORG_ID – Multi-org operating unit identifier, essential for security and reporting segregation.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns recording who created and last modified each allocation row.

The metadata does not document a single-column surrogate primary key or unique index for this table. The nearest business-key candidate is the combination of NETTING_TRX_TYPE_ID, CUST_TRX_TYPE_ID, APPLICATION, and DOC_CATEGORY_CODE, which functionally distinguishes one allocation mapping from another within an operating unit. The _ALL suffix indicates the table is partitioned by operating unit through ORG_ID, consistent with multi-org architecture.

Common Use Cases and Queries

Typical use cases include auditing configured netting allocations, troubleshooting netting or settlement failures, and reproducing allocation output for reconciliation reporting. A common query joins the allocation back to its parent transaction type and to the GL allocation master to trace how a given transaction is treated:

  • List all allocations for a netting transaction type: SELECT * FROM IGI_STP_NET_TYPE_ALLOC_ALL WHERE NETTING_TRX_TYPE_ID = :id AND ORG_ID = :org;
  • Resolve the Receivables transaction type and GL allocation: SELECT a.*, r.NAME trx_type_name, g.ALLOCATION_NAME FROM IGI_STP_NET_TYPE_ALLOC_ALL a JOIN RA_CUST_TRX_TYPES_ALL r ON r.CUST_TRX_TYPE_ID = a.CUST_TRX_TYPE_ID JOIN GL_ALOC_MST g ON g.ALLOC_ID = a.ALLOC_ID WHERE a.ORG_ID = :org;
  • Audit changes over time using LAST_UPDATED_DATE and LAST_UPDATED_BY for compliance reporting.
  • Feed downstream reconciliation extracts by selecting NETTING_EXPENSE_CCID and DOC_CATEGORY_CODE for a given period.

Related Objects

The following objects are most significant when working with this table, based on the documented foreign keys and module context:

  • RA_CUST_TRX_TYPES_ALL – joined on CUST_TRX_TYPE_ID; defines the Receivables transaction types eligible for netting.
  • GL_ALOC_MST – joined on ALLOC_ID; supplies the allocation definition applied during netting.
  • IGI_STP_NET_TRANS_TYPES – parent netting transaction type referenced by NETTING_TRX_TYPE_ID.
  • GL_CODE_COMBINATIONS – resolved from NETTING_EXPENSE_CCID to obtain the expense account segments.
  • IGI_STP_NET_TYPE_ALLOC – the base (non-multi-org) counterpart in the IGI schema.
  • IGI_STP_NET_SETTLEMENTS / IGI netting settlement tables – consume these allocations during settlement processing.

These relationships make the table a critical configuration reference for netting behavior in IGI public sector deployments.