Search Results psa_mfar_transactions




Overview
Explore in AI Chat

Overview

PSA_MFAR_TRANSACTIONS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the integration between Oracle Payables and Oracle Receivables within the Public Sector applications family. Its principal business function is the creation of accounting distributions for receivable transactions that originate from third-party or external funding sources and are processed through the Multi-Fund Accounts Receivable (MFAR) functionality. In government and public sector implementations, MFAR allows a single customer transaction to be funded from multiple sources, requiring distributions to be generated across several accounts rather than being derived solely from standard AutoAccounting rules.

The package is classified as an OTHER API, meaning it is not a fully published or supported public API in the same sense as an OPEN interface. It is instead an internal utility invoked by other program units and concurrent processes operating within the MFAR extension to Receivables. The header identifies the source file as PSAMFTXS.pls, and the version token indicates maintenance through Oracle's standard source control, with the last recorded revision dating to 2006. The package is documented in ETRM for both release 12.1.1 and 12.2.2, and its behaviour is consistent across these releases.

Key Procedures and Functions

The package exposes a single documented entry point: the CREATE_DISTRIBUTIONS function. This function is responsible for generating the distribution rows that record how a given customer transaction is to be accounted for within the MFAR framework. Its parameter list includes an error buffer and return code for concurrent program style error handling, identifiers for the customer transaction and the set of books, a run identifier used to group work performed within a single execution, and an output parameter carrying any error message produced during processing. The function returns a Boolean value indicating success or failure.

Because the metadata documents only this one program unit, no other functions or procedures should be assumed to exist as supported interfaces. The function is designed to be called with a specific transaction already identified in RA_CUSTOMER_TRX_ALL and a set of books context supplied by the caller, and it will populate the MFAR distribution records accordingly.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • PSA_MF_TRX_DIST_ALL — the principal target table, holding the MFAR transaction distributions created by the function.
  • RA_CUSTOMER_TRX_ALL — the source receivable transaction header, providing transaction context and validation.
  • RA_CUST_TRX_LINE_GL_DIST_ALL — the standard Receivables distribution table, used to reconcile or align generated distributions with existing line-level accounting.
  • RA_CUST_TRX_TYPES_ALL — the transaction type definition, used to determine eligibility and processing behaviour.

Usage Notes

PSA_MFAR_TRANSACTIONS is primarily invoked from concurrent programs and by other packages that orchestrate the MFAR accounting process. Three other packages are documented as referencing it, indicating it is a low-level building block rather than a top-level entry point. It is not typically called directly from Oracle Forms. Customisations should avoid modifying the package and should instead rely on documented extension points, since the function signature is internal and subject to change. When troubleshooting, callers should inspect the error message output parameter and the run ID to correlate failures with specific transactions.