Search Results misc_rct_to_gl

Overview

APPS.PSA_MF_GL_MISC_PKG is a PL/SQL package body residing in the APPS schema that belongs to the Oracle Public Sector Applications (PSA) family of modules, specifically the Miscellaneous Receipts to General Ledger integration area. Its principal business function is to move miscellaneous receipt accounting entries originating in the sub-ledger (Miscellaneous Receipts) into the Oracle General Ledger interface, where they can subsequently be validated, journaled, and posted. The package header declares global-scope variables and constants that drive the transfer: a batch naming prefix of 'AR ', a user identifier initialized from FND_GLOBAL.USER_ID, a status value of 'NEW', and an actual flag of 'A' (indicating actual, as opposed to budgetary, accounting entries). Together these values form the default context in which the package's routines execute and are characteristic of an EBS GL interface loading process that builds rows in GL_JE_BATCHES and GL_JE_HEADERS or GL_INTERFACE.

Key Procedures and Functions

The ETRM metadata documents a single callable routine, MISC_RCT_TO_GL. This procedure is the entry point that performs the miscellaneous receipt to General Ledger posting operation for a specified accounting period and ledger. Its IN parameters, as reflected in the source listing, supply the Set of Books identifier (p_set_of_books_id), a GL date range (p_gl_date_from, p_gl_date_to), a posted date (p_gl_posted_date), and the requesting concurrent program request identifier (p_parent_req_id). Two OUT parameters, errbuf and retcode, follow the standard Oracle concurrent program signature and are used by the concurrent manager to report errors and completion status. In the version documented by ETRM the procedure body contains a null statement, indicating the routine is stubbed or its implementation has been superseded. In operational EBS releases this procedure corresponds to the logic invoked when users run the "Miscellaneous Receipts to GL" transfer, and the module prefix PSA_MF_GL_MISC reflects the Miscellaneous Receipts (MF) to General Ledger (GL) flow.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. Because the routine operates within the Miscellaneous Receipts to GL integration, it is conventionally expected to read PSA miscellaneous receipt distributions and to insert or update the GL interface and journal batch tables (such as GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES, or GL_INTERFACE). No explicit table list is documented, so consumers should confirm dependencies through the actual package source or ALL_DEPENDENCIES in their environment. The absence of documented tables, combined with the null procedure body, supports the conclusion that the shipped object is a placeholder rather than an active data-touching implementation in the metadata version captured.

Usage Notes

The procedure’s signature (errbuf OUT, retcode OUT, plus ledger and date parameters) follows the Oracle EBS concurrent program standard, so MISC_RCT_TO_GL is typically invoked from a concurrent program registration rather than directly from a form or custom code. The parameter p_parent_req_id indicates it may be called as a sub-request of a parent concurrent request, allowing the parent to track the child’s completion. The batch prefix 'AR ' and status 'NEW' suggest the generated journal batches are created as new, unposted AR-related batches pending validation. The metadata further reports that the package is referenced by zero other packages, meaning no documented dependency exists on it internally. When integrating or troubleshooting, the recommended approach is to invoke the procedure through its concurrent program definition, verifying the set of books, GL date range, and posted date are consistent with the accounting period being processed, and to inspect GL interface and journal tables after execution for the resulting batch. Because the documented body is a stub, functional behavior should be validated against the installed version of the package in the target 12.1.1 or 12.2.2 environment.