Search Results psa_mf_misc_dist_pk

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.