Search Results fa_util_pvt




Overview
Explore in AI Chat

Overview

The APPS.FA_UTIL_PVT package body is a private utility package within the Oracle E-Business Suite Fixed Assets (FA) module. Unlike public APIs such as FA_ASSET_API or FA_ADJUSTMENT_API, a _PVT classification indicates that this package is intended strictly for internal consumption by the Fixed Assets application tier. It is not exposed to external callers and carries no committed interface guarantee.

Its role is to centralize low-level record retrieval and data-loading logic that is shared across the Fixed Assets API stack, concurrent programs, and forms-based processing. Rather than duplicating queries against the core asset, book, and depreciation tables in each calling program, the FA codebase routes common lookups through this utility layer. This reduces redundancy and ensures consistent handling of key Flexfield structures, depreciation calendars, and multi-reporting-currency (MRC) views. The package is a foundational dependency: it is referenced by 67 other database objects yet references no other FA business logic beyond shared infrastructure packages such as FA_CACHE_PKG and FA_QUERY_BALANCES_PKG.

Key Procedures and Functions

The package body documents 17 procedures and functions, largely organized around record acquisition and value assignment:

Tables Accessed

The package reads from the core Fixed Assets schema via APPS synonyms. Asset master data is accessed through FA_ADDITIONS, FA_ADDITIONS_B, and FA_ADDITIONS_VL. Book and depreciation data come from FA_BOOKS, FA_BOOK_CONTROLS, and FA_DEPRN_SUMMARY. Transactional and historical information is sourced from FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_INVOICE_TRANSACTIONS, FA_TRANSACTION_HEADERS, and FA_RETIREMENTS. Lease information is obtained from FA_LEASES, and warranty data from FA_ADD_WARRANTIES. Fiscal period logic uses FA_FISCAL_YEAR. Where MRC is enabled, the package queries the _MRC_V views for invoices, retirements, and books, plus FA_MC_DEPRN_SUMMARY for multi-currency depreciation balances. It also uses the FND_ID_FLEX_SEGMENTS table to support asset key Flexfield validation.

Usage Notes

FA_UTIL_PVT is invoked internally rather than directly by end users. It is exercised whenever Fixed Assets forms (such as the Asset Workbench), concurrent programs (depreciation, capitalization, and retirement processing), and other FA APIs require reusable record-fetch and lookup logic. Because it is a private package, customizations should not call it directly; doing so risks breakage on patching, since Oracle may alter _PVT signatures without notice. Its extensive inbound dependency count of 67 objects confirms its position as a shared internal service layer rather than a public integration point. The dependency on FND_LOG indicates integrated diagnostics logging, useful for debugging during support. It is not referenced by any external database object, underscoring its private scope.