Results for “misc_cash_distribution_id”

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

Overview

IGI_AR_MISC_CASH_DISTS_ALL is a transactional table owned by the IGI schema within the Oracle E-Business Suite R12 (12.1.1 and 12.2.2) Public Sector Financials International product. It stores cash posting control information associated with miscellaneous cash distributions processed through Oracle Receivables. The table acts as a control and sequencing repository that links miscellaneous receipt activity to the Receivables posting engine and to the General Ledger posting date, allowing the IGI localization layer to track and reconcile cash distributions that fall outside standard invoice-based receipt processing.

The table is documented in the ETRM 12.2.2 physical schema with nine columns and a single-row primary key constraint, IGI_AR_MISC_CASH_DISTS_ALL_PK, defined on MISC_CASH_DISTRIBUTION_ID. A unique index, IGI_AR_MISC_CASH_DISTS_U1, also exists on the same column. From a heuristic Data Vault modeling perspective, the object is classified as standalone, meaning no foreign-key dependencies were mined from the schema. This suggests it is best modeled as an independent hub or standalone reference satellite rather than as a link connecting multiple parent hubs. The "_ALL" suffix follows standard Oracle multi-organization convention and indicates the table is partitioned or filtered by operating unit through the ORG_ID column.

Key Information Stored

The most significant columns documented for this object are:

• MISC_CASH_DISTRIBUTION_ID — Surrogate primary key and the sole business-key candidate, enforced by both IGI_AR_MISC_CASH_DISTS_ALL_PK and the unique index IGI_AR_MISC_CASH_DISTS_U1. It uniquely identifies each miscellaneous cash distribution control record.
• ARC_POSTING_CONTROL_ID — Reference to the associated Receivables posting control record, tying the miscellaneous cash distribution to the AR posting run.
• ARC_GL_POSTED_DATE — The date on which the distribution was posted to the General Ledger, used for period reconciliation and GL transfer auditing.
• ORG_ID — The operating unit identifier, enabling multi-organization data segregation and supporting the "_ALL" naming convention.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle WHO columns capturing audit trail and concurrency information for each record.

Because the documented schema contains only nine columns, the table is deliberately narrow, functioning as a lightweight control or mapping structure rather than a full transaction ledger. The absence of descriptive attributes such as amounts or customer identifiers indicates those values reside in related Receivables tables, with this object providing the posting linkage.

Common Use Cases and Queries

Typical use cases center on reconciliation and audit of miscellaneous cash postings. Reporting queries commonly join this table to Receivables posting and GL interfaces to verify that every miscellaneous cash distribution has been successfully transferred. A representative query pattern:

• Retrieve all distributions for an operating unit and posting date: SELECT MISC_CASH_DISTRIBUTION_ID, ARC_POSTING_CONTROL_ID, ARC_GL_POSTED_DATE FROM IGI_AR_MISC_CASH_DISTS_ALL WHERE ORG_ID = :org_id AND ARC_GL_POSTED_DATE BETWEEN :from_date AND :to_date.
• Identify distributions whose GL posted date is null, indicating a pending or failed posting: ... WHERE ARC_GL_POSTED_DATE IS NULL.
• Audit trail review by joining to Receivables posting control tables on ARC_POSTING_CONTROL_ID.

These queries support period-close validation, GL transfer reconciliation, and troubleshooting of missing or duplicate miscellaneous receipt postings.

Related Objects

Although the heuristic Data Vault classification indicates no mined foreign-key relationships, the following objects are significant in practice based on the documented columns:

• AR_RECEIVABLES_APPLICATIONS_ALL — links via posting control context for receipt application activity.
• AR_MISC_CASH_DISTRIBUTIONS_ALL — standard Receivables miscellaneous cash distribution records that correspond to the IGI control rows.
• AR_CASH_RECEIPTS_ALL — cash receipt headers associated with miscellaneous distribution postings.
• IGI_AR_POSTING_CONTROL — referenced through ARC_POSTING_CONTROL_ID.
• GL_JE_BATCHES / GL_JE_HEADERS — GL transfer targets reconciled through ARC_GL_POSTED_DATE.
• FND_ORG_ACCESS — restricts ORG_ID visibility for multi-org reporting.

Together these objects complete the cash posting control chain within IGI Public Sector Financials.