Results for “psa_mf_adj_dist_all”

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

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

• AR_POSTING_CONTROL — Referenced via POSTING_CONTROL_ID.
• AR_CASH_RECEIPTS / AR_ADJUSTMENTS — Parent adjustment records linked through ADJUSTMENT_ID.
• RA_CUST_TRX_LINE_GL_DIST_ALL — Source of CUST_TRX_LINE_GL_DIST_ID references.
• PSA_MF_ADJ_ALL — Multi-fund adjustment header/link table.
• GL_CODE_COMBINATIONS — Resolves MF_ADJUSTMENT_CCID and PREV_MF_ADJUSTMENT_CCID.