Search Results psa_mf_adj_dist_all




Overview
Explore in AI Chat

Overview

PSA_MF_ADJ_DIST_ALL is a Public Sector Financials (PSA) table that stores accounts receivable distributions associated with adjustments made against multiple-fund transactions. In Oracle EBS 12.1.1 and 12.2.2, this table functions as the distribution detail layer for multi-fund adjustment processing, capturing how a single adjustment against a Receivables transaction is allocated across accounting flexfield combinations, funding sources, and posting controls. It bridges the Receivables adjustment layer and the General Ledger distribution layer for public-sector entities that must split receivables activity across multiple funds.

The ETRM relationship data classifies this object as standalone under a heuristic Data Vault assessment. From a modeling perspective, PSA_MF_ADJ_DIST_ALL is best treated as a link-style object that resolves many-to-many relationships between an adjustment and its associated Receivables line distributions. Because it carries descriptive and attribute columns alongside its key structure, it can also be modeled as a satellite attached to that link.

Key Information Stored

The table contains 30 documented columns. The most significant include:

  • ADJUSTMENT_ID — Identifier of the parent adjustment against a multiple-fund transaction; part of the composite primary key.
  • CUST_TRX_LINE_GL_DIST_ID — Reference to the Receivables line GL distribution that the multi-fund adjustment distribution relates to; the second component of the composite primary key.
  • MF_ADJUSTMENT_CCID — Code combination identifier for the multi-fund adjustment distribution account.
  • PREV_MF_ADJUSTMENT_CCID — The prior multi-fund adjustment accounting combination, useful for change tracking and audit.
  • PREV_CUST_TRX_LINE_ID — Reference to the prior transaction line, supporting historical reconciliation.
  • AMOUNT — Monetary value assigned to the distribution row.
  • PERCENT — Proportional allocation percentage applied to the adjustment.
  • POSTING_CONTROL_ID — Foreign key to AR_POSTING_CONTROL governing posting behavior and period control.
  • COMMENTS — Free-text annotation for the distribution line.
  • ATTRIBUTE_CATEGORY through ATTRIBUTE15 — Descriptive flexfield segments supporting client-specific extensions.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

The surrogate primary key is PK_ADJ_DIST, composed of ADJUSTMENT_ID and CUST_TRX_LINE_GL_DIST_ID. Both columns serve simultaneously as business-key candidates because they jointly identify a unique distribution for a given adjustment. POSTING_CONTROL_ID is a foreign-key business reference to AR_POSTING_CONTROL.

Common Use Cases and Queries

Typical uses include reconciling multi-fund adjustments, auditing allocation percentages across funds, and reporting adjustments by posting control or accounting combination. A common query joins the table to its parent adjustment and to AR_POSTING_CONTROL:

  • Allocation review: SELECT ADJUSTMENT_ID, MF_ADJUSTMENT_CCID, AMOUNT, PERCENT FROM PSA_MF_ADJ_DIST_ALL WHERE ADJUSTMENT_ID = :adj_id;
  • Posting control analysis: join on POSTING_CONTROL_ID to describe the posting rule applied.
  • Exception reporting: flag rows where PERCENT does not total to 100 per ADJUSTMENT_ID.
  • Audit trail: compare MF_ADJUSTMENT_CCID to PREV_MF_ADJUSTMENT_CCID to detect reallocation.

Related Objects