Search Results transaction_validation_check

Overview

PSA_MFAR_VAL_PKG is an Oracle EBS PL/SQL validation package owned by the APPS schema. It belongs to the Public Sector Applications (PSA) suite and supports the validation of Multi-Fund Accounts Receivable (MFAR) transactions before they are processed, posted, or transferred to the General Ledger. In the context of Oracle EBS 12.1.1 and 12.2.2, the package functions as a central repository of validation logic invoked by related PSA packages and interface programs to ensure that Receivables transactions, receipts, adjustments, and quickcash operations conform to MFAR accounting rules. Its API classification is designated as OTHER, indicating that it is an internal validation utility rather than a public, supported API intended for direct external calls. The package is documented as VALID in ETRM 12.2.2, and its dependent package body is available for inspection.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, all oriented toward validating MFAR-related accounting events:

• AR_MFAR_VALIDATE_TRX_HEADER — Validates the header of a Receivables transaction against MFAR rules.
• AR_MFAR_CM_VAL_CHECK — Performs credit memo validation checks within the MFAR context.
• WILL — A utility function (documented without parameters) used in the package's validation flow.
• AR_MFAR_RECEIPT_CHECK — Validates receipt records for MFAR compliance.
• AR_MFAR_RECEIPT_REVERSAL_CHECK — Validates receipt reversal operations.
• AR_MFAR_QUICKCASH — Applies MFAR validation to quickcash transactions.
• AR_LOCKBOX_VALIDATION — Validates lockbox receipt data prior to MFAR processing.
• TRANSACTION_VALIDATION_CHECK — General transaction-level validation entry point.
• RECEIPT_HEADER_VALIDATION_CHECK — Validates receipt headers.
• RECEIPT_VALIDATION_CHECK — Validates individual receipt lines.
• ADJUSTMENT_VALIDATION_CHECK — Validates adjustments against MFAR rules.
• AR_MFAR_AUTOINV_TRX_HEADER — Validates autoinvoice transaction headers for MFAR.
• TO — A supporting routine (documented without parameters) within the validation framework.

Parameter lists are not published in the ETRM metadata; consumers should inspect the package specification directly before invoking any routine.

Tables Accessed

The package reads and writes a range of Receivables and PSA tables through APPS synonyms. Core Receivables tables include AR_ADJUSTMENTS_ALL, AR_CASH_RECEIPTS_ALL, AR_INTERIM_CASH_RECEIPTS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_RECEIVABLES_TRX_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_TYPES_ALL, which supply transaction, receipt, and adjustment data for validation. Setup tables such as AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, and AR_SYSTEM_PARAMETERS (with AR_SYSTEM_PARAMETERS_ALL) provide configuration values that govern validation rules. PSA-specific tables PSA_RECEIVABLES_TRX_ALL and PSA_TRX_TYPES_ALL hold MFAR transaction type definitions. Interface tables RA_INTERFACE_ERRORS and RA_INTERFACE_LINES_GT are used to surface validation failures and line-level data during AutoInvoice processing.

Usage Notes

PSA_MFAR_VAL_PKG is not typically invoked directly by end users. It is called by peer PSA packages including PSA_AR_GL_INTERFACE, PSA_MF_CREATE_DISTRIBUTIONS, and PSA_XFR_TO_GL_PKG, and is referenced by PSA_AR_GL_INTERFACE during transfer-to-GL preparation. Validation routines are triggered as part of Receivables transaction entry, receipt processing, adjustment creation, quickcash, and lockbox workflows, and during AutoInvoice import. Because the API classification is OTHER and the package is proprietary, customizations should call it only through documented PSA integration points rather than invoking procedures directly. The package's dependency on STANDARD indicates reliance on Oracle-supplied base PL/SQL functionality. All validation failures are expected to be routed to RA_INTERFACE_ERRORS for user review.