Search Results psa_mf_trx_dist_u1

Overview

PSA.PSA_MF_TRX_DIST_ALL is a transaction data table in the Oracle E-Business Suite Receivables (AR) schema, owned by the PSA application. It stores the accounts receivable distributions for a multiple fund transaction. Each row represents a single accounting distribution line and captures the general ledger account, amount, and percentage of the accounting entry in addition to standard audit and descriptive flexfield columns. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and carries the FND Design Data reference PSA.PSA_MF_TRX_DIST_ALL.

Functionally, the table supports multi-fund accounting within Receivables, where a single transaction must be split across multiple funds or accounts. The AMOUNT and PERCENT columns are mandatory. The POSTING_CONTROL_ID column, populated by the GL Transfer program, carries a default of null or -3; rows with a null POSTING_CONTROL_ID are posted to the General Ledger. The primary key is CUST_TRX_LINE_GL_DIST_ID, reflecting that each row is uniquely identified by the receivable distribution identifier.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone, meaning the table primarily functions as a hub-like entity without an enforced parent-child dependency chain in the documented metadata. This classification is a modeling suggestion rather than a mandatory design constraint.

Key Information Stored

The most significant columns, drawn from the documented metadata, are:

• CUST_TRX_LINE_GL_DIST_ID — The receivable distribution identifier. This column is the surrogate primary key and is enforced by the unique index PSA_MF_TRX_DIST_U1 in the APPS_TS_TX_IDX tablespace, making it both the PK and the principal business-key candidate.
• MF_RECEIVABLES_CCID — The multi-fund account identifier (code combination ID) for the distribution line.
• POSTING_CONTROL_ID — The Receivables posting batch identifier; -3 or null indicates the row was not posted. This is the foreign key to AR_POSTING_CONTROL.
• PREV_MF_RECEIVABLES_CCID — The code-combination ID of the previous multi-fund receivable, supporting account-change tracking.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who audit columns capturing row creation and last modification metadata.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns providing extensibility for additional user-defined segments.

The unique index PSA_MF_TRX_DIST_U1 on CUST_TRX_LINE_GL_DIST_ID distinguishes the surrogate identifier from any business-key candidate that might be inferred from account or batch combinations.

Common Use Cases and Queries

Typical usage centers on reconciling multi-fund distributions, auditing GL transfer status, and reporting on accounting entries. A common query retrieves unposted distributions:

• SELECT CUST_TRX_LINE_GL_DIST_ID, MF_RECEIVABLES_CCID, POSTING_CONTROL_ID FROM PSA.PSA_MF_TRX_DIST_ALL WHERE POSTING_CONTROL_ID IS NULL OR POSTING_CONTROL_ID = -3;
• Joining to AR_POSTING_CONTROL on POSTING_CONTROL_ID to inspect posting batch details for a given distribution.
• Aggregating by MF_RECEIVABLES_CCID to summarize amounts and percentages across funds for a transaction.
• Comparing PREV_MF_RECEIVABLES_CCID against MF_RECEIVABLES_CCID to identify re-accounted distributions.

Reporting use cases include multi-fund balance reporting, GL transfer reconciliation, and audit trails for account changes.

Related Objects

The documented foreign key relationship points to AR_POSTING_CONTROL via POSTING_CONTROL_ID. Additional related objects include the parent Receivables transaction tables that supply CUST_TRX_LINE_GL_DIST_ID (such as AR_CASH_RECEIPT_HISTORY or AR_DISTRIBUTIONS_ALL), the GL code-combination table (FND_FLEX_VALUES or GL_CODE_COMBINATIONS) referenced indirectly through MF_RECEIVABLES_CCID, and standard Who lookup tables FND_USER and FND_LOGINS for the audit columns. The GL Transfer program is the primary concurrent process that populates POSTING_CONTROL_ID, making it a key operational dependency.