Search Results ar_trx_dist

Overview

PSA_XFR_TO_GL_PKG is an Oracle E-Business Suite Accounts Receivable (AR) transfer utility responsible for moving accounting distributions from the subledger into the General Ledger interface tables. Under the Oracle EBS 12.1.1 and 12.2.2 release lines, this package is a sub-component of the PSA (Public Sector Applications / AR transfer) infrastructure that supports the transfer of unposted AR activity into GL for subsequent journal import and posting. Its primary business function is to consolidate receivable transaction, receipt, adjustment, and miscellaneous receipt lines, transform them into GL-compatible journal entries, and populate the GL interface so that Create Accounting and Journal Import can complete the last leg of the accounting cycle.

The package exposes a set of category and class global variables (for example l_trade_cat_name, l_ccurr_cat_name, l_class_cm, l_class_inv) that drive how each distribution type is mapped to a GL account. These variables are loaded by POPULATE_GLOBAL_VARIABLES at the start of a transfer run. The package header is version PSAMFG2B.pls 120.3 dated 2006/09/13 and is owned by the APPS schema, which is typical for a core AR subledger accounting component.

Key Procedures and Functions

Only the documented procedure and function names are listed below; parameter lists are intentionally not reproduced because the metadata does not disclose them.

• TRANSFER_TO_GL — Master entry point that coordinates the full transfer cycle for a GL submission group, iterating across transaction types and invoking the category-specific routines.
• MFAR_TRX_TO_GL — Transfers receivable transaction distributions (AR_DISTRIBUTIONS rows) to the GL interface.
• MFAR_RCPT_TO_GL — Transfers cash receipt distributions to GL.
• MFAR_ADJ_TO_GL — Transfers receivable adjustment distributions to GL.
• MISC_RCT_TO_GL — Transfers miscellaneous cash receipt distributions to GL.
• POPULATE_GLOBAL_VARIABLES — Reads AR setup and category configuration and populates the package-level mapping globals used throughout the transfer run.
• UPD_SEG_IN_GL_INTERFACE — Updates GL interface segment columns (accounting flexfield segments) after distribution rows are staged.
• REVERSE_CORE_ENTRIES_IF_ANY and CLEAR_REVERSAL_LINES — Identify and remove/clear any previously generated reversal lines in the GL interface to prevent duplicated journal entries.
• GET_ENTERED_DR_RCT, GET_ENTERED_CR_RCT, GET_ENTERED_CR_CRM, GET_ENTERED_DR_CRM, GET_ENTERED_DR_ADJ, GET_ENTERED_CR_ADJ — Retrieval functions that supply entered debit and credit amounts for receipts, credit memos, and adjustments.
• GET_ENTERED_DR_RCT_CLEAR, GET_ENTERED_CR_RCT_CLEAR — Retrieval functions for clearing receipt amounts.
• GET_ADJ_CCID, GET_MISC_ARD_ID, GET_ADJ_ARD_ID — Helper functions that resolve code combination IDs and source distribution identifiers used when constructing GL interface rows.

Tables Accessed

The package references AR subledger tables through APPS synonyms:

• AR_ADJUSTMENTS / AR_ADJUSTMENTS_ALL — source adjustment distributions.
• AR_CASH_RECEIPTS / AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY / AR_CASH_RECEIPT_HISTORY_ALL — receipt header and status history used to derive transfer eligibility.
• AR_DISTRIBUTIONS / AR_DISTRIBUTIONS_ALL — the primary transaction distribution source.
• AR_MISC_CASH_DISTRIBUTIONS / AR_MISC_CASH_DISTRIBUTIONS_ALL — miscellaneous receipt distributions.
• AR_RECEIVABLE_APPLICATIONS — application and unapplication detail used in the "applied/unapplied" mapping globals.
• AR_SYSTEM_PARAMETERS — SOB, functional currency, and posting configuration.
• FND_APPLICATION, FND_NEW_MESSAGES, FND_RESPONSIBILITY — application name resolution, messages, and responsibility security context.

Usage Notes

PSA_XFR_TO_GL_PKG is normally invoked indirectly. In a standard AR flow, the GL Transfer program (for example, the "Transfer to General Ledger" or Create Accounting/Journal Import concurrent program) calls this package for the submission set identified by l_pst_ctrl_id and the SOB in l_sob_id. Because it is called from concurrent programs, the package is not intended for interactive form execution. Custom code should call it only after POPULATE_GLOBAL_VARIABLES has run, and any invocation must respect the GL interface open-interface period and the reversal logic implemented in REVERSE_CORE_ENTRIES_IF_ANY to avoid duplicate accounting. The package is referenced by one other package in the AR transfer stack, confirming that it is a mid-tier component rather than a top-level entry point.