Search Results do_inv_sub_transfer




Overview
Explore in AI Chat

Overview

FA_INV_XFR_PUB is a public PL/SQL package in the APPS schema that supports the transfer of invoice-related asset transactions within Oracle Assets. It functions as the interface layer through which invoice-driven asset cost adjustments are validated, staged, and posted into the asset transaction model of Oracle E-Business Suite. The package is classified as a public API (PUB), indicating that it is designed for controlled external invocation by other Oracle Assets programs and by extension code, rather than functioning purely as internal implementation logic.

The package operates within the broader invoice transfer process, where costs, discounts, and related amounts originating from Payables invoices or other external sources must be matched to capitalized assets and reflected as adjustments of the appropriate transaction type. Because it writes to the transaction interface and transaction tables, it participates directly in the accounting and depreciation cycle that follows asset transaction posting. Its dependency on FA_API_TYPES, FND_API, and FND_GLOBAL confirms that it adheres to the standard Oracle API framework, using standardized return statuses and message handling rather than raising raw exceptions to the caller.

Key Procedures and Functions

  • DO_TRANSFER — The primary entry point for performing an invoice transfer. It accepts a set of asset invoice transaction details and drives the creation of the corresponding asset transaction records, performing validation against the transaction model before persistence. In practice it is the procedure called by higher-level packages when a transfer must be executed as a unit of work.
  • DO_INV_SUB_TRANSFER — Handles the subordinate portion of an invoice transfer, applying the detailed transactional lines associated with the transfer initiated by DO_TRANSFER. It allows the caller to break a composite transfer into manageable components, particularly useful where multiple asset lines or adjustment categories are involved.

The two procedures are complementary: DO_TRANSFER establishes the transaction context, while DO_INV_SUB_TRANSFER completes the detailed assignment of invoice amounts. Parameter lists are not enumerated here, as the documented metadata does not specify them.

Tables Accessed

  • FA_ADDITIONS_B — Read to resolve the target asset being adjusted by the transfer.
  • FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS — Written to record the cost adjustment arising from the invoice transfer, including the multi-currency form.
  • FA_BOOKS and FA_BOOK_CONTROLS — Consulted to identify the depreciation book and its control parameters governing the transaction.
  • FA_DEPRN_PERIODS — Used to determine the open depreciation period into which the transfer may be posted.
  • FA_TRANSACTION_HEADERS_S — Written to create the transaction header that groups the invoice transfer.
  • FA_TRX_REFERENCES_S — Used to store external references, such as the originating invoice identifier, against the transaction.
  • DUAL and PLITBLM — Employed for standard PL/SQL and server-side utility operations.

Usage Notes

FA_INV_XFR_PUB is referenced by three packages: FA_INV_XFR_PUB itself (internal recursion or sibling procedures), FA_MASSPSLTFR_PKG, and FA_TRANS_API_PUB. This confirms its role as a dependency of the mass asset transfer process and the general asset transaction API surface. It is typically invoked as part of mass transfer or invoice-driven adjustment processing, often launched through the Oracle Assets concurrent programs that manage mass transfers and invoice adjustment transfers, rather than from a standard maintenance form. Customers extending Oracle Assets should call the package through its public procedures using the FND_API return conventions, supplying a valid transaction context and ensuring the target depreciation period is open before invocation. Direct DML against the underlying transaction tables should not be performed in place of this package.