Search Results psa_mf_misc_dist_all




Overview
Explore in AI Chat

Overview

PSA_MF_MISC_DIST_ALL is a Public Sector Financials (PSA) transactional table that stores the multi-fund distributions generated for a miscellaneous receipt in Oracle E-Business Suite. It is the PSA extension that allows a single miscellaneous receipt to be distributed across multiple funds, supporting government and public-sector accounting requirements where a cash receipt must be allocated to more than one fund or accounting combination. The table exists in both EBS 12.1.1 and 12.2.2 and is owned by the PSA schema with a documented status of VALID. The physical schema in ETRM 12.2.2 records 34 columns, anchored by the primary key constraint PSA_MF_MISC_DIST_PK on the MISC_MF_CASH_DIST_ID column.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests that PSA_MF_MISC_DIST_ALL is best modeled as its own entity rather than folded into a hub, link, or satellite construct of another subject area. It references AR_POSTING_CONTROL through POSTING_CONTROL_ID, so it behaves as a dependent distribution detail that inherits posting context from the Accounts Receivable posting engine.

Key Information Stored

The table's surrogate primary key is MISC_MF_CASH_DIST_ID, defined by the PSA_MF_MISC_DIST_PK constraint. The most significant columns and their roles are:

  • MISC_MF_CASH_DIST_ID — Surrogate primary key uniquely identifying each multi-fund distribution row.
  • MISC_CASH_DISTRIBUTION_ID — Business-key candidate linking the multi-fund row back to the underlying miscellaneous cash distribution.
  • DISTRIBUTION_CCID — The distribution accounting flexfield combination to which funds are allocated.
  • CASH_CCID — The cash accounting flexfield combination associated with the receipt.
  • REVERSAL_CCID — The accounting combination used when the distribution is reversed.
  • POSTING_CONTROL_ID — Foreign key to AR_POSTING_CONTROL, tying the distribution to an AR posting batch.
  • GL_DATE — The general ledger date on which the distribution is accounted.
  • COMMENTS — Free-text annotation on the distribution line.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking creation and modification.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments for client-specific extensions.
  • REFERENCE1–REFERENCE5 — Additional reference identifiers supporting reconciliation and traceability.

Common Use Cases and Queries

The primary use case is reporting and reconciliation of multi-fund miscellaneous receipts, particularly for public-sector entities that must demonstrate fund-level allocation. A typical query joins the distribution to its parent receipt distribution and to AR posting control:

  • Listing all fund allocations for a receipt: SELECT MISC_MF_CASH_DIST_ID, MISC_CASH_DISTRIBUTION_ID, DISTRIBUTION_CCID, CASH_CCID, GL_DATE FROM PSA_MF_MISC_DIST_ALL WHERE MISC_CASH_DISTRIBUTION_ID = :dist_id;
  • Reconciling to the GL by posting batch: SELECT d.DISTRIBUTION_CCID, SUM(d.amount) FROM PSA_MF_MISC_DIST_ALL d, AR_POSTING_CONTROL p WHERE d.POSTING_CONTROL_ID = p.POSTING_CONTROL_ID GROUP BY d.DISTRIBUTION_CCID;
  • Auditing reversals by examining rows where REVERSAL_CCID is populated.
  • Flexfield-based reporting using ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 for client-defined dimensions.

Related Objects

  • AR_POSTING_CONTROL — Referenced via POSTING_CONTROL_ID (foreign key); supplies posting batch context.
  • PSA_MF_MISC_DIST_ALL itself is the multi-fund detail for miscellaneous cash distributions, so the parent receipt distribution table (referenced by MISC_CASH_DISTRIBUTION_ID) is the principal related object.
  • AR_CASH_RECEIPTS / AR_MISC_CASH_DISTRIBUTIONS — Source receipts and single-fund distributions whose multi-fund splits are stored here.
  • GL_CODE_COMBINATIONS — Resolves DISTRIBUTION_CCID, CASH_CCID, and REVERSAL_CCID to accounting flexfield values.
  • GL_JE_LINES / GL_IMPORT_REFERENCES — Downstream journal lines generated from these distributions.

The table is populated by PSA multi-fund miscellaneous receipt processing and is consumed by General Ledger transfer and public-sector fund reporting.