Search Results fa_set_profile_pkg1

Overview

FA_SET_PROFILE_PKG1 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Assets (FA) module and is classified in the ETRM repository under the API classification "OTHER," indicating that it is an internal utility package rather than a formally published public API. Its documented purpose centers on the management of asset profile or system profile settings used by the Oracle Assets application. In Oracle Assets, profile options govern default depreciation conventions, prorate conventions, book controls, and accounting behaviors that affect how assets are added, adjusted, and retired. FA_SET_PROFILE_PKG1 encapsulates logic for reading and applying these profile-related values so that other parts of the FA schema can resolve the correct setup without duplicating the underlying query logic. The package is recorded with a status of VALID in the ETRM metadata for release 12.2.2, and the same object is documented for 12.1.1 and 12.2.2, confirming consistent presence across both release levels.

Key Procedures and Functions

The ETRM metadata documents a single callable program unit within this package:

• FA_SPRF — The only documented procedure or function in FA_SET_PROFILE_PKG1. Based on the naming convention (an abbreviated form of "Set Profile"), this routine is responsible for setting, initializing, or retrieving the Oracle Assets profile values that the calling session requires. It likely accepts the relevant profile identifiers or context and returns or applies the corresponding setup values. As the metadata does not expose a parameter list, no signature is asserted here; integrators should inspect the package specification in the target instance before invoking it directly.

No other procedures, functions, or overloads are documented in the ETRM extract. The package body is marked as present, but individual private routines are not itemized in the source metadata.

Tables Accessed

The documented metadata does not list any base tables referenced through APPS synonyms. The dependency information identifies only APPS.FA_API_TYPES and the SYS.STANDARD package as direct dependencies. FA_API_TYPES is a common Oracle Assets type-definition package that supplies record and table types used across FA APIs, suggesting FA_SET_PROFILE_PKG1 applies those types in its internal logic or in the FA_SPRF signature. Because no FA setup tables (such as FA_SYSTEM_CONTROLS or FND_PROFILE_OPTION_VALUES) appear in the documented dependency list, any table access performed by this package is either indirect or not captured in the ETRM extract. Consultants should treat the table-access layer as undocumented and verify it against the package body in the target environment.

Usage Notes

FA_SET_PROFILE_PKG1 is referenced by no other documented packages, and it does not itself reference other FA application packages beyond the type definitions in FA_API_TYPES. This isolated dependency profile indicates a low-level internal utility that is invoked narrowly rather than as a shared public API. In practice, such packages are typically called from Oracle Assets forms, concurrent programs, or internal FA processing logic during asset setup and validation, rather than from customer-written customization code. Because the package is classified as OTHER rather than as a supported public API, Oracle does not guarantee its signature or behavior across patches or upgrades. Custom code should avoid calling FA_SET_PROFILE_PKG1 directly; where equivalent functionality is required, developers should prefer documented public FA APIs or standard profile option retrieval mechanisms. Any investigation of this package should begin with the package specification and body in the specific 12.1.1 or 12.2.2 instance, since the ETRM metadata exposes only the name and a single documented routine without parameters, tables, or call sites.