Search Results psa_mf_misc_pkg




Overview
Explore in AI Chat

Overview

PSA_MF_MISC_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER-type API within the ETRM repository. The package belongs to the Public Sector Application (PSA) module family and specifically supports the Miscellaneous Receipts distribution generation functionality, as reflected in the "MF" (Miscellaneous Funds or Miscellaneous Receipts) naming convention and the presence of the PSA_MF_MISC_DIST_ALL table among its dependencies. The package operates as a supporting utility invoked by the higher-level PSA_MF_CREATE_DISTRIBUTIONS package, which the ETRM metadata confirms is the sole external package dependency referencing PSA_MF_MISC_PKG. Its role is to encapsulate the logic required to derive, validate, and generate miscellaneous cash distribution records against Oracle Receivables receipts, receipt methods, and receipt method account configurations. The package is in VALID status across the documented releases, indicating a functioning compiled unit in both Oracle EBS 12.1.1 and 12.2.2 environments. Because it is classified as OTHER rather than a formally published public API, it is intended for internal use within the PSA Miscellaneous Receipts workflow rather than for direct customer invocation.

Key Procedures and Functions

The documented ETRM metadata identifies a single program unit within the package:

  • GENERATE_DISTRIBUTIONS — The principal procedure exposed by PSA_MF_MISC_PKG. Its name indicates that it drives the creation of miscellaneous distribution records, reading the requisite receipt, receipt method, and receipt method account data and writing the resulting distribution lines to the PSA_MF_MISC_DIST_ALL table. No parameter list is documented in the ETRM repository; accordingly, parameter signatures must be obtained from the live database (for example, via ALL_ARGUMENTS or DESCRIBE on the package specification) before the procedure is referenced from custom code. The procedure is not documented as a public API, and its signature should be treated as subject to change across patches and point releases.

No additional procedures or functions are listed in the documented metadata; any further program units visible in the deployed package body are undocumented and should not be relied upon.

Tables Accessed

The package references the following tables through APPS synonyms, which are integral to the Receivables and PSA miscellaneous receipts data model:

  • AR_CASH_RECEIPTS and AR_CASH_RECEIPTS_ALL — The core Receivables cash receipt entities, providing header-level receipt information used to establish the context for distribution generation.
  • AR_CASH_RECEIPT_HISTORY — The receipt status history table, consulted to evaluate the current and prior states of a receipt before distributions are generated.
  • AR_MISC_CASH_DISTRIBUTIONS — The Oracle Receivables table storing miscellaneous cash distribution lines for receipts, serving as a source and modeling reference for the PSA-specific distribution logic.
  • AR_RECEIPT_METHODS — The receipt method definitions, supplying the method attributes that govern how a receipt is processed and therefore which distribution rules apply.
  • AR_RECEIPT_METHOD_ACCOUNTS — The accounting configuration associated with each receipt method, providing the general ledger account derivation rules required when constructing distribution records.
  • PSA_MF_MISC_DIST_ALL — The PSA-specific miscellaneous distribution detail table, which is the primary target of the GENERATE_DISTRIBUTIONS procedure.

Together these objects indicate that the package performs a Receivables-to-PSA mapping of receipt data, translating receipt method configuration into distribution line records.

Usage Notes

PSA_MF_MISC_PKG is not intended for direct invocation by end users or through standard Oracle EBS forms or concurrent programs. The documented dependency chain shows that PSA_MF_CREATE_DISTRIBUTIONS is the only external package that references it, confirming that the package is a subordinate utility invoked during the PSA miscellaneous receipts distribution creation process. Typical invocation occurs as part of a broader batch or programmatic workflow initiated by PSA_MF_CREATE_DISTRIBUTIONS, which in turn is driven by PSA Miscellaneous Receipts processing.

Customizations that require miscellaneous distribution generation should invoke PSA_MF_CREATE_DISTRIBUTIONS rather than PSA_MF_MISC_PKG directly. Where direct access to GENERATE_DISTRIBUTIONS is unavoidable, developers must first extract the parameter signature from the deployed specification, as it is not documented in the ETRM repository, and must account for the package's status as an internal component that Oracle may modify without notice in patches or upgrades. The package relies only on SYS.STANDARD at the database level, meaning its behavior is governed entirely by APPS-level schema objects and Receivables data, which simplifies impact analysis but also means its correctness depends directly on the integrity and accessibility of the referenced AR and PSA tables in the target environment.