Search Results update_invoice_desc

Overview

FA_ASSET_DESC_PUB is a public PL/SQL API package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Assets (FA) product family and provides a supported, programmatic interface for maintaining the descriptive text attributes associated with asset records throughout their lifecycle. The package is classified as a PUB (public) API, indicating that it is designed for external invocation by other Oracle EBS modules, third-party integrations, and customer-written customizations. Its principal role is to centralize the logic required to update asset description fields while enforcing the validation and multi-organization rules that Oracle Assets requires, rather than allowing direct DML against the underlying asset tables.

The package depends on the FA_API_TYPES, FND_API, and FND_GLOBAL packages. FA_API_TYPES supplies the standard Oracle Assets API data structures, FND_API provides the common API framework including the standard return-status conventions, and FND_GLOBAL supplies session context such as the current user and responsibility. This dependency set is characteristic of a well-formed public Oracle Assets API.

Key Procedures and Functions

The documented metadata lists three public procedures. Parameter lists are intentionally not reproduced here; only the documented purpose of each is described.

• UPDATE_DESC — Updates the descriptive text attributes of an asset. This is the primary entry point for revisions to an asset's description outside of a transaction-specific context.
• UPDATE_INVOICE_DESC — Updates the description associated with an asset's invoice-related information, allowing descriptive text that originates from an invoice line to be maintained consistently with the asset record.
• UPDATE_RETIREMENT_DESC — Updates the descriptive text associated with an asset retirement, ensuring that comments captured at retirement remain accurate and auditable.

Tables Accessed

The package references several Oracle Assets tables through APPS synonyms. FA_BOOKS and FA_MC_BOOKS_RATES are consulted to establish the asset's book context, including multi-currency book rates where applicable, so that description updates respect the correct book assignment. FA_BOOK_CONTROLS and FA_SYSTEM_CONTROLS are read to determine whether the relevant book is open or closed and to apply system-level defaults and validation rules. PLITBLM is a standard Oracle Applications PL/SQL table type used for array-style parameter processing within the API's internal logic. Together these tables allow the package to validate that an update is permissible in the current accounting environment before any change is committed.

Usage Notes

FA_ASSET_DESC_PUB is typically invoked programmatically rather than directly by end users. Its documented referencers include FA_AFE_TRANSACTIONS_PKG, FA_CUA_MASS_UPDATE1_PKG, FA_TRANS_API_PUB, OKL_ACTIVATE_ASSET_PVT, and OKL_ASSET_DETAILS_PVT. These relationships show that the package is called during asset mass updates, asset transaction processing, and Oracle Lease Management asset activation and detail maintenance, where descriptive text must be synchronized as assets are created, transferred, or retired. Custom code and extensions that need to modify asset descriptions in a supported manner should call this API instead of issuing direct UPDATE statements against Oracle Assets tables, thereby preserving validation, auditability, and upgrade compatibility. Because the procedures obey the standard FND_API return-status protocol, callers should inspect the returned status and message before assuming that a description update has succeeded.