Results for “prev_mf_adjustment_ccid”

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

Overview

PSA_MF_ADJ_DIST_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PSA – Public Sector Financials product family. Its documented status is VALID in both the 12.1.1 and 12.2.2 releases, and the ETRM metadata confirms it is a VIEW object residing in the APPS schema. The view exposes the distribution detail of multi-fund (MF) adjustments applied to receivable transactions, presenting one record per adjustment distribution line along with the accounting flexfield identifiers and allocation amounts associated with that line. Because it is a view rather than a table, it provides a read-only, current-version projection of the underlying adjustment distribution data, which makes it suitable for reporting, reconciliation, and outbound integration scenarios where consumers must not write back to the base table. Organizations that search on the term "prev_mf_adjustment_ccid" are typically seeking to understand how the view surfaces the prior multi-fund adjustment accounting flexfield, a column retained on each distribution row to preserve the accounting context before an adjustment was reclassified. The view therefore serves as the canonical read interface for adjustment distribution history in PSA-enabled receivables implementations.

Underlying Base Objects

The view is defined over a single referenced base object, documented in the ETRM 12.2.2 metadata as PSA_MF_ADJ_DIST_ALL, which is exposed in the APPS schema through a SYNONYM. The view text is a direct projection: it selects ADJUSTMENT_ID, CUST_TRX_LINE_GL_DIST_ID, MF_ADJUSTMENT_CCID, AMOUNT, PERCENT, POSTING_CONTROL_ID, PREV_MF_ADJUSTMENT_CCID, PREV_CUST_TRX_LINE_ID, the standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), COMMENTS, ATTRIBUTE_CATEGORY, and ATTRIBUTE1 through ATTRIBUTE15 from PSA_MF_ADJ_DIST_ALL without joins, filters, or aggregation. No additional base tables are documented for this view. Because the "_ALL" suffix on the base object indicates a multi-organization (partitioned by ORG_ID) table, the view as documented does not itself expose ORG_ID in the column list; consumers requiring organization-scoped results must account for the operating unit context supplied by the underlying table and by the application's security model rather than expecting an ORG_ID column in the view output.

Key Columns

• ADJUSTMENT_ID – Identifier of the adjustment header to which the distribution line belongs; the principal grouping key for reporting.
• CUST_TRX_LINE_GL_DIST_ID – Foreign reference to the receivable transaction line GL distribution that this adjustment distribution affects.
• MF_ADJUSTMENT_CCID – The multi-fund adjustment accounting flexfield code combination identifier, representing the target accounting distribution.
• PREV_MF_ADJUSTMENT_CCID – The prior multi-fund adjustment code combination identifier, preserving the accounting flexfield that applied before the current adjustment. This is the column most frequently targeted by the search term "prev_mf_adjustment_ccid".
• AMOUNT and PERCENT – The monetary value and proportional allocation of the distribution line, used to verify that distribution totals reconcile to the adjustment.
• POSTING_CONTROL_ID – Reference supporting posting control logic for the distribution.
• PREV_CUST_TRX_LINE_ID – Prior transaction line reference, used for traceability when lines are recreated or reclassified.
• COMMENTS and ATTRIBUTE1–ATTRIBUTE15 – Descriptive and descriptive-flexfield-style extension columns available for local reporting requirements.

Common Use Cases and Queries

Typical use cases include reconciliation of adjustment distributions to receivable line GL distributions, audit reporting on accounting flexfield changes captured via PREV_MF_ADJUSTMENT_CCID, and extraction feeds that publish adjustment distribution data to downstream ledgers or data warehouses. A representative query listing all distributions for a single adjustment follows:

SELECT adjustment_id, cust_trx_line_gl_dist_id, mf_adjustment_ccid, prev_mf_adjustment_ccid, amount, percent FROM apps.psa_mf_adj_dist_v WHERE adjustment_id = :adjustment_id;

To isolate records where the multi-fund adjustment code combination changed from a known prior value, query on the retained column directly:

SELECT adjustment_id, mf_adjustment_ccid, prev_mf_adjustment_ccid, amount FROM apps.psa_mf_adj_dist_v WHERE prev_mf_adjustment_ccid = :ccid;

Because the view performs no joins or filtering, it is inexpensive to query and can be joined to GL code combination and receivable transaction views by CCID or by distribution identifier to resolve descriptive accounting detail. All access is read-only.