Search Results get_entered_dr_rct

Overview

PSA_MF_GL_TRANSFER_PKG is an Oracle EBS Accounts Receivables support package owned by the APPS schema in the Oracle Public Sector / PSA (Public Sector Applications) product family. Its principal business function is the transfer and posting of PSA Multifund Accounts Receivable (MFAR) accounting entries into the Oracle General Ledger interface. The package packages the logic required to construct and insert journal entries created for MFAR transactions, adjustments, and receipts so that they can be picked up by the standard General Ledger Journal Import process.

The package header carries the source header marker PSAMFGLS.pls version 120.2 (dated 2006/09/13), confirming it is a long-standing, mature component of the PSA MFAR sub-ledger integration. In the ETRM 12.2.2 metadata it is classified as an OTHER API, and it is documented as referenced by zero other packages, indicating it is a terminal consumer of data rather than a utility reused across the application stack. Within Oracle EBS 12.1.1 and 12.2.2, the package therefore acts as the bridging layer between PSA MFAR distribution data and the GL_INTERFACE staging tables.

Key Procedures and Functions

The documented API exposes twelve procedures and functions organized around three accounting event types — transactions, adjustments, and receipts — plus helper functions that compute entered debit and credit amounts.

• PSA_MF_TRX_TRANSFER — posts MFAR transaction entries, returning a varchar2 status indicator.
• PSA_MF_ADJ_TRANSFER — posts MFAR adjustment entries, returning a varchar2 status indicator.
• PSA_MF_RCT_TRANSFER — posts MFAR receipt entries, returning a varchar2 status indicator.
• PSA_MF_MFAR_TRX_JES — inserts additional MFAR journal entries for transactions into the GL Interface.
• PSA_MF_MFAR_ADJ_JES — inserts additional MFAR journal entries for adjustments into the GL Interface.
• PSA_MF_MFAR_RCT_JES — inserts additional MFAR journal entries for receipts into the GL Interface.
• GET_ENTERED_DR_RCT / GET_ENTERED_CR_RCT — return the entered debit and entered credit amounts for receipt distributions, accepting a lookup code and amount plus optional discount and unearned discount values.
• GET_ENTERED_DR_ADJ / GET_ENTERED_CR_ADJ — return the entered debit and entered credit amounts for adjustment distributions.
• GET_ENTERED_DR_CRM / GET_ENTERED_CR_CRM — return the entered debit and entered credit amounts for credit memo / CRM distributions.

The user query "get_entered_dr_adj" resolves directly to GET_ENTERED_DR_ADJ, the adjustment-side debit calculation helper. Parameter lists for the remaining functions are not reproduced here to avoid inventing signatures; only their documented purpose is described.

Tables Accessed

The package reads and writes distribution data through the following APPS synonyms:

• PSA_MF_TRX_DIST_ALL — PSA MFAR transaction distribution lines, the source of journal entry amounts for transaction posting.
• PSA_MF_ADJ_DIST_ALL — PSA MFAR adjustment distribution lines, used by the adjustment transfer and debit/credit helper functions such as GET_ENTERED_DR_ADJ.
• PSA_MF_RCT_DIST_ALL — PSA MFAR receipt distribution lines, used for receipt posting and the RCT debit/credit helpers.
• RA_CUST_TRX_LINE_GL_DIST — the standard Receivables revenue and receivables distribution table, consulted to correlate PSA MFAR distributions with their originating AR accounting lines.

GL_INTERFACE insertion is implied by the documented purpose of the MFAR_JES functions, though that table is not listed among the documented synonyms.

Usage Notes

PSA_MF_GL_TRANSFER_PKG is not a general-purpose public API. It is invoked internally by the PSA Multifund Accounts Receivable posting and transfer logic — typically triggered by concurrent programs or forms that manage MFAR transactions, adjustments, and receipts, and by the GL transfer/posting flow that precedes Journal Import. Because the metadata records zero referencing packages and an OTHER API classification, direct custom calls should be treated as unsupported. Customizations that require the entered debit or credit figures for adjustments should call GET_ENTERED_DR_ADJ or GET_ENTERED_CR_ADJ rather than reimplementing the lookup-code and discount logic, since these helpers encapsulate the MFAR-specific amount derivation rules. The package behaves identically across 12.1.1 and 12.2.2, as it resides in the APPS schema and is not affected by the online patching editioning model.