Search Results fa_sprf

Overview

The APPS.FA_SET_PROFILE_PKG1 package body is a small utility package within the Oracle E-Business Suite Fixed Assets (FA) module. Its single documented purpose is to manipulate the value of a specific FND profile option, CONC_SINGLE_THREAD, for the duration of a call and then restore the previous value. The package header for FA_SET_PROFILE_PKG1 is defined alongside the body shown in the ETRM extraction, and the body carries the source header identifier faxsprfb.pls 120.4, last revised 2009/03/27. In the context of Oracle EBS 12.1.1 and 12.2.2, this package is classified as a generic OTHER API and is not exposed as a public concurrent program or form-based API in its own right. It exists to support internal Fixed Assets processing that needs to temporarily toggle single-threaded concurrent processing behavior.

Key Procedures and Functions

• FA_SPRF — The only documented procedure in the package. It accepts a profile value as an IN OUT NOCOPY parameter and a logging parameter of type FA_API_TYPES.log_level_rec_type. Internally the procedure captures the current value of the CONC_SINGLE_THREAD profile option using FND_PROFILE.VALUE, writes the caller-supplied value into that profile option using FND_PROFILE.PUT, and then returns the previously stored value to the caller through the IN OUT parameter. In effect, the procedure performs a swap-and-restore cycle so that the caller can temporarily force single-threaded execution and later recover the original setting.

Tables Accessed

The package does not directly reference any Fixed Assets base tables, and no tables are recorded in the ETRM metadata. All persistence of profile option values is handled indirectly through the FND profile value layer (FND_PROFILE.VALUE and FND_PROFILE.PUT), which reads and writes the underlying profile option data owned by the FND schema. Because the profile is a session- or user-level setting, the effective storage is managed by the FND_PROFILE package rather than by direct DML from FA_SET_PROFILE_PKG1.

Usage Notes

FA_SET_PROFILE_PKG1 is not intended for direct invocation by end users. It is a private utility used by other Fixed Assets packages or concurrent processes that require the CONC_SINGLE_THREAD profile option to be temporarily altered. A calling program would invoke FA_SPRF, supplying the desired profile value, perform the work that depends on single-threaded behavior, and then pass the returned value back into a second call to restore the original setting. Standard Oracle guidance applies: any caller that changes profile option values at runtime must ensure the prior value is restored, since profile options are global to the session and leaving CONC_SINGLE_THREAD modified could affect subsequent concurrent requests. The package was shipped under the EBS code line and remains present in 12.1.1 and 12.2.2; it is not referenced by any other documented packages, so its use is effectively internal to Fixed Assets processing code.