Search Results psa_mf_mfar_adj_jes

Overview

APPS.PSA_MF_GL_TRANSFER_PKG is a PL/SQL package body that belongs to the Oracle E-Business Suite Public Sector/Projects accounting integration layer (PSA module). Its principal business function is to transfer multi-fund accounting and reporting (MFAR) distributions for receivables-related transactions into the General Ledger (GL) interface, while simultaneously writing the posting control identifier back to the corresponding distribution tables. The package therefore acts as a bridge between Oracle Receivables transaction, adjustment, and receipt distribution data and the GL journal import process. The version marker in the source header ($Header: PSAMFGLB.pls 120.3 2006/09/13) indicates this is a long-standing component that has been stable across 11i and the 12.1.1 and 12.2.2 releases. The package is classified as an OTHER API within ETRM, is owned by APPS, and is not referenced by any other packaged objects, which suggests it is invoked directly by concurrent processing or forms rather than by a public built-in calling chain.

Key Procedures and Functions

The 12.2.2 metadata documents twelve procedures and functions within this package. Three of these are the top-level transfer routines, each accepting a record type defined in PSA_MFAR_UTILS:

• PSA_MF_TRX_TRANSFER — Transfers invoice/transaction-level MFAR distributions. It calls PSA_MF_MFAR_TRX_JES and then updates PSA_MF_TRX_DIST_ALL with the posting control ID.
• PSA_MF_ADJ_TRANSFER — The routine matching the user search term "psa_mf_adj_transfer". It handles adjustments, invoking PSA_MF_MFAR_ADJ_JES and updating PSA_MF_ADJ_DIST_ALL with the posting control ID for the given adjustment.
• PSA_MF_RCT_TRANSFER — Handles receipt-related distributions, calling PSA_MF_MFAR_RCT_JES and updating PSA_MF_RCT_DIST_ALL by receivable application ID.

Three further functions perform the actual journal entry creation and GL interface insertion: PSA_MF_MFAR_TRX_JES, PSA_MF_MFAR_ADJ_JES, and PSA_MF_MFAR_RCT_JES. The remaining six functions — GET_ENTERED_DR_RCT, GET_ENTERED_CR_RCT, GET_ENTERED_DR_ADJ, GET_ENTERED_CR_ADJ, GET_ENTERED_DR_CRM, and GET_ENTERED_CR_CRM — are helper accessors that return entered debit and credit amounts for receipts, adjustments, and credit memos respectively, supporting balanced journal construction.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PSA_MF_TRX_DIST_ALL — Transaction MFAR distribution lines; updated with the posting control ID after journal transfer.
• PSA_MF_ADJ_DIST_ALL — Adjustment MFAR distribution lines; updated by adjustment ID.
• PSA_MF_RCT_DIST_ALL — Receipt MFAR distribution lines; updated by receivable application ID.
• RA_CUST_TRX_LINE_GL_DIST — Oracle Receivables' transaction line GL distribution table, queried to resolve the cust_trx_line_gl_dist_id values that drive the transaction update.

Usage Notes

PSA_MF_GL_TRANSFER_PKG is typically invoked during the accounting transfer step that precedes GL Journal Import. Because it is not referenced by any other packaged object, it is normally called from MFAR-specific concurrent programs or from custom extension code that loops over pending transaction, adjustment, and receipt records held in PSA_MFAR_UTILS record structures. Each transfer function returns a VARCHAR2 status value, allowing the caller to detect success or failure per record. The posting control ID written back to the distribution tables provides the audit link between the subledger distributions and their resulting GL journal entries, and is essential for reconciliation and for preventing duplicate transfer. Parameter lists should always be confirmed against the deployed package specification, since ETRM documents only procedure names and purpose.