Search Results pk_rct_dist

Overview

PSA_MF_RCT_DIST_ALL is a Public Sector Financials (PSA) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments that stores Accounts Receivable (AR) distribution information for cash receipts and credit memos applied against multiple-fund transactions. In the public sector accounting model, a single receipt or credit memo may be allocated across several funds, and this table captures the resulting fund-level accounting distributions, enabling accurate general ledger posting and multi-fund reporting. Its documented physical schema consists of 38 columns owned by the PSA schema, and the table carries a VALID status in the ETRM repository. From a data-modeling perspective, the metadata classifies this object as a standalone entity based on its foreign key topology, meaning it is not treated as a dependent child within a traditional hub-link-satellite pattern. Where a Data Vault treatment is considered, a heuristic modeling suggestion would be to regard the primary key pair as a composite business key, with descriptive and amount-oriented attributes behaving as satellite payload, though the documented structure shows only a single outbound foreign key to AR_POSTING_CONTROL.

Key Information Stored

The table is anchored by the composite primary key PK_RCT_DIST, which comprises RECEIVABLE_APPLICATION_ID and CUST_TRX_LINE_GL_DIST_ID. These two columns together function as the unique row identifier and are the strongest business-key candidates, linking a receipt application event to its corresponding transaction line distribution.

• RECEIVABLE_APPLICATION_ID — identifies the AR receipt application to a transaction; part of the primary key.
• CUST_TRX_LINE_GL_DIST_ID — identifies the customer transaction line GL distribution; part of the primary key.
• MF_CASH_CCID — the multi-fund cash code combination identifier used for the fund-level cash distribution.
• AMOUNT — the distributed monetary value assigned to the row.
• PERCENT — the percentage of the total allocation attributable to this distribution.
• DISCOUNT_CCID and UE_DISCOUNT_CCID — code combinations for taken and unearned discount accounting entries.
• DISCOUNT_AMOUNT and UE_DISCOUNT_AMOUNT — corresponding discount amounts.
• REVERSAL_CCID — code combination used when the distribution is reversed.
• POSTING_CONTROL_ID — the foreign key referencing AR_POSTING_CONTROL, governing GL posting activity.
• COMMENTS — free-text annotation for the distribution.
• REFERENCE1 through REFERENCE5 — flexible reference identifiers for reconciliation and traceability.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — the standard EBS descriptive flexfield columns enabling client-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit trail columns.

Common Use Cases and Queries

Typical usage centers on multi-fund receipts reconciliation, distribution reporting, and GL posting verification. A fund accountant may need to enumerate all distributions for a specific receipt application, or reconcile distributed amounts against the originating transaction line. Representative SQL patterns include joining PSA_MF_RCT_DIST_ALL to AR_POSTING_CONTROL via POSTING_CONTROL_ID to determine posting status, and aggregating AMOUNT and PERCENT by MF_CASH_CCID to validate that fund allocations total 100 percent. A further common query checks rows where POSTING_CONTROL_ID is null, indicating distributions that have not yet been picked up by the posting process. Analysts also extract REFERENCE and ATTRIBUTE columns for reconciliation with downstream fund accounting systems and audit documentation.

Related Objects

The most significant related object is AR_POSTING_CONTROL, referenced through PSA_MF_RCT_DIST_ALL.POSTING_CONTROL_ID, which links each distribution row to its GL posting event. Because the primary key comprises RECEIVABLE_APPLICATION_ID and CUST_TRX_LINE_GL_DIST_ID, the table relates logically to AR_RECEIVABLE_APPLICATIONS_ALL and AR_CUST_TRX_LINE_GL_DIST_ALL, from which those identifiers originate. Code combination columns such as MF_CASH_CCID, DISCOUNT_CCID, UE_DISCOUNT_CCID, and REVERSAL_CCID resolve through the GL_CODE_COMBINATIONS structure for account validation and reporting. Related PSA objects handling multi-fund processing and cash receipt application logic also depend on these distribution records to complete the public sector accounting cycle. Parent receipts are traceable through AR_CASH_RECEIPTS_ALL, and application details through AR_RECEIVABLE_APPLICATIONS_ALL. Together these objects provide the join path from a receipt through its applications, transaction line distributions, and fund-level GL entries.