Results for “psa_ap_bc_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSA_AP_BC_GRP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a GRP (Group) API, a designation used within ETRM release 12.2.2 for packages that consolidate a small set of related business logic rather than exposing a fully standing public API surface. The package resides within the Public Sector Financials family of modules, whose object prefix "PSA_" is shared by the budget, commitment control, and encumbrance tracking components used by public sector and government implementations.

The business function served by PSA_AP_BC_GRP is the determination of unencumbered balances in Payables (AP) purchasing activity. Encumbrance accounting requires that commitments created by purchase orders and relieved by subsequent invoice or payment activity be tracked so that available budget balances remain accurate. When a purchase order distribution is reversed or cancelled, the encumbrance previously placed against the budget must be released. This package supplies the amount side of that calculation, allowing budgeting and commitment control routines to restore funds that had been previously reserved.

Key Procedures and Functions

The documented package metadata identifies a single public program unit:

• GET_PO_REVERSED_ENCUMB_AMOUNT — Returns the encumbered amount associated with a reversed purchase order distribution, expressed as an unencumbered amount in the output parameter. The procedure accepts the standard EBS API boilerplate parameters (API version, initialization of the message list, return status, message count, and message data) together with the specific business keys it requires: the purchase order distribution identifier, a start GL date and an end GL date defining the accounting period range in which the reversal is to be measured, and a calling sequence string used for diagnostic and stack tracking. The unencumbered amount is returned through a dedicated numeric output parameter.

The API version, initialization, return status, message count, and message data arguments follow the standard Oracle Application Object Library API contract, meaning callers must inspect x_return_status and process the FND_MSG_PUB stack on failure. The calling sequence parameter is optional and defaults to NULL.

Tables Accessed

The documented metadata does not enumerate the base tables accessed through APPS synonyms. In practice, the procedure resolves purchase order distribution reversal amounts by reading the encumbrance and distribution data maintained by Payables and Purchasing, including PO_DISTRIBUTIONS_ALL and the corresponding encumbrance balances in GL. Because it is a group API invoked from within the APPS schema, all such access is performed through APPS synonyms rather than direct schema-qualified references.

Usage Notes

PSA_AP_BC_GRP is a supporting routine rather than an end-user facing interface. It is not attached directly to a form or a concurrent program; instead it is invoked from other PL/SQL code paths that manage encumbrance reversal. The ETRM metadata records that the package is referenced by two other packages, which indicates it functions as a shared utility within the Public Sector commitment control stack.

Customizations and extensions that need to reproduce the standard released encumbrance amount should call GET_PO_REVERSED_ENCUMB_AMOUNT rather than re-deriving the value, since the procedure encapsulates the release logic consistently with the delivered application. As with all GRP-class APIs, Oracle does not guarantee backward compatibility of this interface across releases, so implementers should validate the signature against the target EBS version (12.1.1 or 12.2.2) before relying on it in custom code. Note that the object name is unrelated to Oracle's BSA (Budgetary Control) tables; searches for "bsa customers" that surface this package reflect naming overlap rather than a functional relationship to customer or receivables data.