Search Results create_distributions_rpt

Overview

PSA_MF_CREATE_DISTRIBUTIONS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Public Sector Applications (PSA) family of modules and is specifically associated with the Multi-Fund (MF) accounting feature used by public sector and government organizations. Its principal business function is the creation of accounting distributions for multi-fund transactions that originate in Oracle Receivables. In a multi-fund environment, a single receivable or receipt transaction may need to be split across multiple funds, and this package determines and generates the corresponding distribution lines that are subsequently transferred to the General Ledger.

The package is classified as OTHER in the API classification scheme, indicating it is an internal, supporting program rather than a formally published open interface. It is documented as VALID across Oracle EBS 12.1.1 and 12.2.2, and it depends on the SYS.STANDARD package, reflecting standard PL/SQL runtime usage.

Key Procedures and Functions

The documented package exposes three procedures:

• CREATE_DISTRIBUTIONS — The core processing routine. It performs the actual logic required to build accounting distribution records for multi-fund transactions, reading the relevant Receivables transaction data and writing the resulting distribution lines.
• SUBMIT_CREATE_DISTRIBUTIONS — A wrapper-style procedure that submits the distribution creation process, typically for execution as a concurrent program or batch job, rather than performing the distribution logic inline.
• CREATE_DISTRIBUTIONS_RPT — A reporting variant of the distribution creation logic, used where distribution output must be produced in a report-oriented context.

Only the procedure names and their broad purpose are documented; parameter signatures are not published in the available metadata.

Tables Accessed

The package references the following tables through APPS synonyms:

• AR_ADJUSTMENTS, AR_CASH_RECEIPTS, AR_RECEIVABLE_APPLICATIONS — Receivables adjustment, receipt, and application data used to determine the source amounts that must be distributed across funds.
• RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST — Transaction headers and existing transaction line distribution records, which are read and supplemented with new multi-fund distributions.
• PSA_RECEIVABLES_TRX_ALL, PSA_TRX_TYPES_ALL — PSA multi-fund setup tables that define transaction types and mapping rules governing how distributions are derived.
• PSA_MF_ERROR_LOG_S — The multi-fund error log, written when distribution creation encounters exceptions.
• PLITBLM — A generic PL/SQL index-by table type used for in-memory processing.

Usage Notes

PSA_MF_CREATE_DISTRIBUTIONS is an internal package and is not intended for direct invocation by end users. It is referenced by two other packages — PSA_MULTIFUND_DISTRIBUTION_EXT and PSA_XFR_TO_GL_PKG — indicating that it is invoked during multi-fund distribution processing and again when distributions are transferred to the General Ledger. It is typically triggered from Oracle Receivables forms activity or from concurrent programs that run multi-fund accounting generation. Customizations should extend behavior through the documented extension package PSA_MULTIFUND_DISTRIBUTION_EXT rather than modifying this package, since it is an Oracle-owned APPS object and direct changes would compromise supportability.