Search Results fa_reserve_transfer_pub




Overview
Explore in AI Chat

Overview

The APPS.FA_RESERVE_TRANSFER_PUB package is a public Oracle E-Business Suite API that supports Oracle Assets (FA) by transferring depreciation reserve between two group assets held in the same depreciation book. Reserve represents the accumulated depreciation recognized against an asset, and the ability to move a specific monetary amount of that reserve from one asset to another is a business requirement in group asset accounting, where several member assets are depreciated collectively and adjustments between members are periodically required. The package is classified as a PUB API in the ETRM repository, with an active lifecycle status, an owner of APPS, and a declared compatibility of S (supported). Its scope is public, meaning it is intended for invocation from external code, concurrent programs, or other APIs rather than being restricted to internal FA processing. The header identifier (FAPRSVXS.pls, version 120.4, dated 2009/03/27) confirms the file is delivered as part of the standard Oracle Assets schema and remains current in the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes a single documented public procedure, DO_RESERVE_TRANSFER. Its documented purpose is to transfer reserve between two group assets within the same book. The procedure accepts standard Oracle EBS API control parameters (API version, message-list initialization flag, commit flag, validation level, and calling function name), returns the standard API outcome parameters (return status, message count, and message data), and additionally requires the source asset identifier, the destination asset identifier, the book type code, and the amount of depreciation reserve to transfer. It also accepts and returns the source and destination transaction records using the FA_API_TYPES.trans_rec_type structure, allowing the caller to supply or receive transaction context for each side of the transfer. Because the metadata documents only this one procedure, there are no other public entry points to describe, and no function overloads or private helpers are exposed by the ETRM record.

Tables Accessed

The package operates against several standard Oracle Assets tables through APPS synonyms. FA_BOOK_CONTROLS is referenced to validate the book context and the accounting rules governing the reserve transfer. FA_TRANSACTION_HEADERS_S is used to create the transaction header that records the reserve transfer event. FA_TRX_REFERENCES_S stores reference information linking the generated transaction to its source and destination assets and to the originating business event. DUAL is used for single-row lookups and standard PL/SQL expression evaluation, and PLITBLM is the standard Oracle message-handling table used to assemble the API’s returned error and information messages. Together these tables allow the API to validate inputs, write a balanced reserve transfer transaction, and communicate results back through the standard message stack.

Usage Notes

FA_RESERVE_TRANSFER_PUB.DO_RESERVE_TRANSFER is typically invoked from custom PL/SQL, concurrent programs, or supporting integrations that need to move reserve between group asset members without using the Oracle Assets forms. Callers must supply valid source and destination asset identifiers, a valid book type code, and a positive transfer amount, and must initialize the transaction record structures before the call. Following Oracle EBS API conventions, the procedure should be called with FND_API.G_TRUE for message-list initialization, with the return status and message count inspected immediately after execution. Commit behavior is controlled by the commit flag, so callers performing multiple transfers can set it to false and commit once at the end of the logical unit of work. Because the ETRM record notes that this package is referenced by one other package, integrators should be aware that the procedure participates in a wider dependency chain within Oracle Assets and should avoid modifying underlying FA transaction data directly.