Search Results psa_utils




Overview
Explore in AI Chat

Overview

PSA_UTILS is a utility package body owned by the APPS schema in Oracle E-Business Suite, valid across releases 12.1.1 and 12.2.2. It is classified as an OTHER-type API and functions primarily as a shared services layer rather than a business transaction API. Its two dominant responsibilities are diagnostic logging and validation, together with a specialized set of accounting reversal routines for Subledger Accounting (XLA) entries originating from Oracle Payables and Purchasing. The package exposes sixteen documented procedures and functions that are consumed broadly across the EBS application stack; the ETRM metadata records that PSA_UTILS is referenced by thirty other database objects, confirming its role as a foundational dependency rather than a terminal consumer.

Internally, PSA_UTILS depends on FND_FILE for concurrent program output, FND_LOG and FND_LOG_MESSAGES_S for the application diagnostic framework, and FND_MESSAGE for message dictionary retrieval. This dependency profile indicates that debugging output can be routed either to the concurrent manager log file or to the FND logging tables depending on the runtime context.

Key Procedures and Functions

The documented entry points divide into three functional groups.

Parameter lists are not documented in the available metadata and should be confirmed against the deployed package specification before use.

Tables Accessed

PSA_UTILS accesses its tables through APPS synonyms. Payables-related objects include AP_INVOICES_ALL, AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_HOLDS_ALL, AP_PREPAY_APP_DISTS, AP_PREPAY_HISTORY_ALL, and AP_SELF_ASSESSED_TAX_DIST_ALL, reflecting the invoice validation and hold/prepayment inspection duties. FND_USER and FND_RESPONSIBILITY support the user and responsibility validations. FND_LOG_MESSAGES_S is written by the debugging routines. GL_BC_PACKETS, GL_LEDGERS, and GL_PERIOD_STATUSES support the CCID lookup and GL date validation, while GMS_AWARD_DISTRIBUTIONS is used by the grants-related distribution logic. The XLA reversal procedures operate primarily through the Subledger Accounting APIs rather than direct table DML.

Usage Notes

PSA_UTILS is not intended to be invoked by end users directly. It is called from concurrent programs, Oracle Forms personalizations and customizations, and other PL/SQL packages. The debugging procedures are typically guarded by a profile option or a local flag so that trace output is produced only when diagnostics are enabled. The validation routines are commonly used at the top of custom programs to fail fast on invalid input. The UNDO and REDO XLA procedures are used in correction scenarios where subledger accounting entries must be reversed and regenerated, and should be exercised with the same care as any accounting-affecting operation, including appropriate testing in a non-production environment.