Search Results include_imported_line

Overview

PSA_MFAR_RECEIPTS is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Multifund Accounts Receivable (MFAR) feature set within the Public Sector/Projects accounting functionality. Its core responsibility is to derive, create, and maintain receipt-based distribution records that must be staged before they can be transferred to the General Ledger. In the MFAR architecture, accounting entries generated by receipt activity in Oracle Receivables cannot be posted directly to GL; instead, they are captured in staging tables (PSA_MF_RCT_DIST_ALL for receipts and PSA_MF_TRX_DIST_ALL for transactions) where fund, agency, and other budgetary attributes are applied. PSA_MFAR_RECEIPTS serves as the engine that populates and reconciles these staging records. It bridges the gap between the customer-facing cash receipt and application records in the Receivables subledger and the MFAR-specific distribution table that downstream processes, such as PSA_XFR_TO_GL_PKG, consume when submitting distributions to General Ledger.

Key Procedures and Functions

• CREATE_DISTRIBUTIONS — The central routine of the package. It evaluates receipt and application activity and generates the corresponding Multifund distribution rows. This is the procedure most commonly invoked by the MFAR workflow to build the distribution records required for GL transfer.
• INCLUDE_MANUAL_LINE — Accommodates distribution lines that were entered manually rather than derived from standard receipt processing. This permits users or administrators to incorporate ad hoc entries into the the distribution set so they are carried through to GL.
• INCLUDE_IMPORTED_LINE — Handles distribution lines originating from an external or imported source, ensuring that receipt data loaded through interface mechanisms can still be captured and included alongside natively created distributions.
• PURGE_ORPHAN_DISTRIBUTIONS — Performs cleanup by removing distribution records that no longer have a valid parent receipt or application. This prevents stale or unmatched rows from being forwarded to General Ledger and keeps the staging table consistent with current Receivables activity.

Tables Accessed

The package draws heavily on the Receivables data model and writes to the MFAR staging tables. On the source side, it reads AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL for receipt header and status information; AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL for how cash has been applied to transactions; RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES, and RA_CUSTOMER_TRX_LINES_ALL for invoice and line detail; and RA_CUST_TRX_LINE_GL_DIST and RA_CUST_TRX_LINE_GL_DIST_ALL for the underlying revenue accounting distributions that receipts settle against. AR_SYSTEM_PARAMETERS and RA_TERMS_B supply configuration and payment term context. On the output side, PSA_MF_RCT_DIST_ALL and PSA_MF_TRX_DIST_ALL receive the generated Multifund distribution records, while PSA_MF_ERROR_LOG_S records exceptions encountered during processing.

Usage Notes

PSA_MFAR_RECEIPTS is an internal MFAR component rather than a public API, and its classification is listed as OTHER. It is referenced by PSA_MF_CREATE_DISTRIBUTIONS and PSA_XFR_TO_GL_PKG, indicating that distribution creation is triggered through MFAR's own processing chain and that the resulting rows are subsequently picked up for GL transfer. It is typically invoked when receipt activity must be reflected in the Multifund distribution staging tables—for example, before the MFAR-to-GL transfer is run. Because the package manipulates data that ultimately posts to General Ledger, it should not be called ad hoc; use it only through the standard MFAR programs and workflows, and always in coordination with PSA_XFR_TO_GL_PKG. When troubleshooting missing or duplicated Multifund receipt distributions, investigate PSA_MF_ERROR_LOG_S first, then review AR_RECEIVABLE_APPLICATIONS data for the affected receipts. Custom code should never write directly to PSA_MF_RCT_DIST_ALL while this package or its parents are active, as PURGE_ORPHAN_DISTRIBUTIONS may remove manually inserted rows that are not tied to valid source activity.