Search Results fa_custom_ret_val_pkg




Overview
Explore in AI Chat

Overview

FA_CUSTOM_RET_VAL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, holding VALID status across both 12.1.1 and 12.2.2 releases. The package supports the Oracle Assets mass retirement process, which allows users to retire multiple assets in a single operation rather than processing individual retirements sequentially. Its name indicates a "custom retirement validation" role: the package encapsulates validation logic applied to retirement criteria before the mass retirement engine commits changes to asset data.

The API classification in the ETRM documentation is listed as OTHER, distinguishing it from the standard public APIs such as FA_RETIREMENT_PUB or FA_MASS_RET_PUB. This classification reflects its position as an internal helper rather than an externally published integration point, although it remains callable from registered custom code and from the concurrent program layer.

Key Procedures and Functions

The documented package specification exposes a single procedure:

  • VALIDATE_CRITERIA — Performs validation of the selection criteria supplied to the mass retirement flow. Based on the package's dependency profile and its role in the process, this routine checks that the criteria submitted by the user identify a coherent and eligible population of assets before the retirement is executed. It is invoked by the mass retirement public API layer rather than directly by end users.

No other procedures or functions are documented in the ETRM metadata for this package. Custom implementations should not assume the existence of undocumented entry points, as the package body is not a supported extension surface.

Tables Accessed

FA_CUSTOM_RET_VAL_PKG references one application table through its APPS synonym:

  • FA_MASS_RETIREMENTS — The interface and staging table for mass retirement requests. The validation routine reads rows from this table to evaluate the criteria and asset selections associated with a pending mass retirement batch. The table stores the parameters and asset identifiers that the mass retirement program subsequently processes.

The package also depends at compile time on the FA_API_TYPES package, which supplies the shared PL/SQL record and collection type definitions used throughout the Oracle Assets public API layer. This dependency confirms that the package participates in the standard API call stack rather than operating as a standalone utility.

Usage Notes

FA_CUSTOM_RET_VAL_PKG is referenced by FA_MASS_RET_PUB, the public API that fronts the mass retirement process. This relationship establishes the standard invocation path: an external program or form calls FA_MASS_RET_PUB, which in turn calls FA_CUSTOM_RET_VAL_PKG.VALIDATE_CRITERIA to screen the submitted criteria before the retirement is posted. The package therefore executes within the same database session and transaction as the calling API.

Typical invocation scenarios include the Oracle Assets mass retirement concurrent program, the Mass Retirements form in the Assets responsibility, and custom concurrent programs or scripts that call FA_MASS_RET_PUB directly. The package is registered in the ETRM as dependent on FA_MASS_RETIREMENTS and FA_API_TYPES and as being referenced by one other package, indicating a narrow and well-bounded footprint.

Because the package is designated OTHER rather than a public API, direct calls to VALIDATE_CRITERIA from custom code are not supported by Oracle and may change without notice across patch levels. Customizations should instead invoke FA_MASS_RET_PUB, allowing the supported layer to manage validation sequencing. Any diagnostic or troubleshooting activity around mass retirement validation errors should begin with the criteria and asset rows in FA_MASS_RETIREMENTS, since the package evaluates those records directly.