Search Results psa_mf_gl_misc_pkg

Overview

PSA_MF_GL_MISC_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment. Its module prefix identifies it as a component of the Public Sector Applications (PSA) product family, specifically within the Grants Accounting / Funds Control functional area. The "_MF_" infix indicates the package is part of the Multi-Fund / Miscellaneous processing layer that supports the integration between PSA transactional modules and the Oracle General Ledger (GL) application. The suffix "_GL_MISC_" and the presence of the MISC_RCT_TO_GL procedure confirm its role in moving miscellaneous or residual transaction amounts—summarized in the detail-gl (RCT, or "Reconciliation/Receipt") tables—into the General Ledger interface. In the context of Oracle EBS 12.1.1 and 12.2.2, the package is a server-side utility that supports period-end accounting, balancing, and funds-check reconciliation processing originating in PSA modules and terminating in the GL submission cycle.

Key Procedures and Functions

ETRM documentation records a single procedure or function within PSA_MF_GL_MISC_PKG, namely MISC_RCT_TO_GL. Given the package title and the PSA naming conventions, the procedure is responsible for taking miscellaneous RCT (reconciliation or receipt) entries maintained within the PSA data model and converting, summarizing, or staging them for transfer into the GL interface tables. It abstracts the logic that determines the appropriate GL account, debit/credit vector, and amount mapping, then writes the resulting journal lines for subsequent posting. No parameter list is documented, and no additional overloading or sibling routines are recorded in the ETRM metadata.

Tables Accessed

The ETRM excerpt does not expose the underlying base tables via direct references, using SYS and STANDARD only as compilation dependencies. In practice, GL-transfer packages of this class read from PSA detail tables—such as PSA receipt/reconciliation tables that hold miscellaneous RCT amounts—and write to the GL interface tables (for example GL_INTERFACE) that feed the GL journal import. Custom installations may extend the procedure's body to reference site-specific PSA distributions or accounting repositories.

Usage Notes

As a miscellaneous GL conversion routine, MISC_RCT_TO_GL is typically invoked during month-end or period-end processing, either from a concurrent program scheduled within Funds/Awards Accounting or from a menu-driven GL submission process. It is rarely called interactively from a form; more often it is triggered by a feeder program that has completed its reconciliation step. Because the package is not referenced by other documented PL/SQL packages, it behaves as a leaf-level utility and can be wrapped in custom concurrent executables when project-specific mapping is required. When extending or tuning it, administrators should verify the version-specific 12.1.1 versus 12.2.2 GL interface column definitions (for example the Journal Source and Category name assignments) and confirm that the PSA RCT source tables retain sufficient balance data for a clean period-to-period roll-forward.