Search Results fa_trans_api_pub




Overview
Explore in AI Chat

Overview

FA_TRANS_API_PUB is the public PL/SQL API package within Oracle E-Business Suite Fixed Assets (FA) that centralizes the creation and processing of asset transactions. It belongs to the APPS schema and is classified as a public (PUB) API, indicating that it is designed for supported external invocation by other Oracle EBS modules, customer extensions, and integration code. The package provides a single, validated entry point for the full range of Fixed Assets transaction types, insulating callers from the underlying transaction tables and validation logic maintained by Oracle.

In Oracle EBS 12.1.1 and 12.2.2, all asset life-cycle events that are not recorded through the standard Assets forms — mass additions, adjustments, transfers, retirements, reinstatements, reclassifications, and capitalization — can be driven programmatically through this package. The API performs the same validations, accounting derivation, and book balance updates as the online forms, and it conforms to the Oracle Application Object Library (FND_API) standard, which supplies the common return-status and message-handling infrastructure. The package is documented as VALID and references FND_API and the SYS STANDARD package.

Key Procedures and Functions

The ETRM metadata documents 19 public procedures and functions in this package, each corresponding to a distinct Fixed Assets transaction:

Tables Accessed

The metadata documents access to FA_BOOK_CONTROLS and PLITBLM through APPS synonyms. FA_BOOK_CONTROLS is the Fixed Assets book control table; the API reads it to obtain the depreciation rules, accounting conventions, and period status governing the target book before any transaction is processed. PLITBLM is the PL/SQL internal table (index-by table) type used by the FND_API standard for passing message and error collections; its presence confirms the package follows the standard API error-handling pattern of returning messages to the caller rather than raising unhandled exceptions. Additional transaction and asset tables are updated indirectly through the private package body and its supporting dependencies.

Usage Notes

FA_TRANS_API_PUB is typically invoked from the Fixed Assets transaction forms, from concurrent programs such as the Mass Additions and depreciation processes, and from custom PL/SQL integration code that must post asset transactions automatically. The metadata shows it is referenced by FA_MODIFY_DISTRIBUTIONS_PKG and by itself, and it references FND_API. Callers should invoke the API within a properly initialized FND_API environment, respect the returned status and message table, and commit only after a successful return. Because it is a PUB API, it is the supported interface for programmatic asset transaction processing; direct DML against the underlying FA transaction tables is not supported.