Search Results psa_feature




Overview
Explore in AI Chat

Overview

APPS.PSA_IMPLEMENTATION is a PL/SQL package body that provides the feature-flag and implementation-status control layer for Oracle Enterprise Business Suite's Public Sector / Grants and PSA (Public Sector Applications) modules. Its principal business function is to determine, at the organization level, whether a given PSA feature — commonly the MFAR (Multi-Fund Accounts Receivable) capability referenced throughout the source — is enabled, and to permit application code to query, enable, or disable that feature in a controlled and cached manner. In Oracle EBS 12.1.1 and 12.2.2, this package acts as a low-level utility rather than a user-facing API: it abstracts direct reads and writes against the feature-implementation table so that higher-level business logic can branch on configuration without repeatedly hitting the database.

Key Procedures and Functions

The package exposes three documented program units, all centered on the MFAR feature toggle:

  • GET — A function that returns a Boolean indicating whether the requested PSA feature is enabled for a given organization. It returns the enabled flag via an output parameter and, importantly, caches the result in a package global (g_mfar_enabled). If the organization identity changes between calls, the cache is invalidated, forcing a fresh lookup. A NO_DATA_FOUND exception is trapped and treated as "not enabled."
  • ENABLE_MFAR — A procedure that activates the specified PSA feature for a given organization. It first reads the current status; if already 'Y' it takes no action, and if 'N' it updates the existing row to 'Y'. When no row exists, it inserts a new record into the implementation table.
  • DISABLE_MFAR — A procedure that performs the inverse operation, deactivating the feature for the specified organization.

The package also defines standard FND_LOG severity-level constants and a path variable for diagnostic logging, reflecting Oracle's standard instrumentation conventions.

Tables Accessed

The package reads and writes a single documented table, PSA_IMPLEMENTATION_ALL, accessed through its APPS synonym. This table stores the per-organization feature status, keyed by ORG_ID and PSA_FEATURE, with a STATUS column holding 'Y' or 'N'. GET performs a SELECT to read the status; ENABLE_MFAR performs a SELECT, then either an UPDATE or an INSERT depending on whether a configuration row already exists; DISABLE_MFAR likewise modifies the status. This table is the authoritative source of truth for whether MFAR-related processing should activate for a given operating unit.

Usage Notes

PSA_IMPLEMENTATION is typically invoked from other PL/SQL packages, forms-based logic, or concurrent programs within the PSA and Grants product family rather than by end users directly. It is referenced by two other packages in the application schema, confirming its role as a shared dependency. Because GET employs package-level caching of the enabled flag, callers should be aware that status changes committed by other sessions are not reflected until the cache is refreshed (for example, when the organization context changes). The enable and disable routines are intended for controlled administrative or setup flows, ensuring that the feature-flag record in PSA_IMPLEMENTATION_ALL stays consistent with application expectations across Oracle EBS 12.1.1 and 12.2.2 environments.