Search Results submit_create_distributions




Overview
Explore in AI Chat

Overview

PSA_MF_CREATE_DISTRIBUTIONS is a PL/SQL package body owned by APPS that supports the Multifund (PSA) accounting feature set within Oracle E-Business Suite. Its principal business function is to derive and generate accounting distributions for Multifund transactions, thereby enabling correct revenue, receivable, and cash application accounting for transactions that span multiple funds. The package reads transactional data from Receivables tables and Multifund setup tables, evaluates the applicable transaction activity, and produces the distribution records required for downstream accounting and reporting.

The package is classified under the ETRM taxonomy as OTHER, which indicates that it is an internal supporting package rather than a formally published public API. The header comment block documents the addition of a p_mode parameter that branches processing according to activity type: Transaction (T) processes Multifund transactions, cash receipts, and adjustments; Miscellaneous Receipt (M) processes miscellaneous receipts; and All (A) processes all Multifund distributions. This design allows a single entry point to service several distinct accounting flows.

Key Procedures and Functions

The documented package exposes three procedures or functions:

  • CREATE_DISTRIBUTIONS — The core worker routine. It accepts the activity mode, a document identifier, and a set of books identifier, and returns status information including a return code, run number, error buffer, and error message. An optional report-only flag allows the same logic to be executed in validation or preview mode without committing distributions. Its internal cursors select customer transactions, receivable applications, and adjustments relevant to the requested activity.
  • SUBMIT_CREATE_DISTRIBUTIONS — The submission wrapper, which is the entry point most commonly associated with the search term "submit_create_distributions." It handles the orchestration of the distribution creation request, typically invoked from a concurrent program or form so that CREATE_DISTRIBUTIONS executes as a background request and its status can be reported as a concurrent program outcome.
  • CREATE_DISTRIBUTIONS_RPT — A reporting-oriented routine that supports the same distribution logic in report form, providing output suitable for review and reconciliation of generated Multifund distributions.

Tables Accessed

The package reads and writes against several documented tables, all accessed through APPS synonyms:

  • PSA_TRX_TYPES_ALL — Identifies which Receivables transaction types are configured for Multifund processing; used in the cursor that qualifies customer transactions.
  • RA_CUSTOMER_TRX — The source of transaction header records, joined to PSA_TRX_TYPES_ALL to select eligible transactions for the requested set of books.
  • AR_RECEIVABLE_APPLICATIONS — Provides cash application records linked to applied customer transactions, driving receipt-related distribution logic.
  • AR_ADJUSTMENTS and AR_CASH_RECEIPTS — Supply adjustment and cash receipt activity required for the Transaction mode processing path.
  • PSA_RECEIVABLES_TRX_ALL — Holds Multifund receivables transaction definitions used to determine distribution treatment.
  • RA_CUST_TRX_LINE_GL_DIST — The target area for generated accounting distributions.
  • PSA_MF_ERROR_LOG_S — Records error conditions encountered during processing, supporting the error message and return code outputs.
  • PLITBLM — A standard Oracle character table typically used for list processing or IN-list expansion.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, PSA_MF_CREATE_DISTRIBUTIONS is normally invoked through its submission routine from a Multifund concurrent program or from Multifund entry forms, with the concurrent manager supplying the set of books and document parameters. The report-only flag allows users to preview distributions before the accounting is finalized. Because the package is classified as OTHER and is referenced by two other packages, custom code should call SUBMIT_CREATE_DISTRIBUTIONS rather than the worker function directly, and any direct invocation must respect the activity mode branching rules documented in the package header.