Search Results fa_distributions




Overview
Explore in AI Chat

Overview

FA_ADDITION_PVT is the private implementation package for the Oracle E-Business Suite Fixed Assets addition API. It belongs to the APPS schema and carries the PVT (private) API classification, meaning its procedures are not part of the public integration surface. The package is designed to be invoked indirectly by FA_ADDITION_PUB, the public wrapper that exposes asset addition functionality to forms, concurrent programs, and custom code. Its principal responsibility is to validate, default, and persist a new asset addition transaction together with its associated financial, depreciation, distribution, and invoice information.

A significant portion of the package deals with the fa_distributions search term: the px_asset_dist_tbl (asset distribution table) parameter, which is of type fa_api_types.asset_dist_tbl_type, is threaded through the initialization routine and subsequently written to the FA_DISTRIBUTIONS table when an addition transaction is inserted. The distribution records supply the accounting flexfield segments to which the asset cost is charged, and they are essential to a complete addition transaction.

Key Procedures and Functions

  • INITIALIZE — Sets up and validates the full set of transaction, asset, and invoice records passed by the caller. It accepts the transaction record, a separate distribution transaction record, the asset header, description, type, category, hierarchy, financial, and depreciation records, the asset distribution table, and the invoice table. It defaults values from category book defaults (category chart of accounts, segment arrays, and concatenated distribution accounts), retrieves group asset default options such as gain/loss recognition, tracking method, excess allocation, and depreciation options, and returns a return status plus a log level record. It is the entry point that prepares all data structures before Insert_Asset executes.
  • INSERT_ASSET — Performs the actual database insertion of the asset addition, writing rows into the asset master and related transaction tables, including the distributions derived from px_asset_dist_tbl, and updating depreciation and book records as required by the addition.
  • INITIALIZE_JP — A country-specific (Japan) variant of the initialization logic, supplying localized defaults and validation rules before the standard insert processing.

Tables Accessed

The package reads and writes a broad set of Fixed Assets tables through APPS synonyms. Master asset data is written to FA_ADDITIONS_S and supplemented by FA_BOOKS, FA_BOOK_CONTROLS, and FA_DEPRN_SUMMARY for financial and depreciation balances. Distribution records from px_asset_dist_tbl are persisted to FA_DISTRIBUTIONS, linking asset cost to accounting flexfields. Setup and validation data are read from FA_CATEGORIES, FA_CATEGORY_BOOK_DEFAULTS, FA_DEPRN_BASIS_RULES, FA_DEPRN_RULE_DETAILS, FA_DEPRN_PERIODS, FA_CALENDAR_PERIODS, FA_CALENDAR_TYPES, and FA_FISCAL_YEAR. Invoice and adjustment information is stored in FA_ASSET_INVOICES, FA_ADD_WARRANTIES, and FA_ADJUSTMENTS.

Usage Notes

This package is never called directly by end users. It is referenced by one other package and is invoked through the FA_ADDITION_PUB public API from the Fixed Assets asset addition form (FAXASSET), from concurrent programs that load assets in bulk, and from custom PL/SQL integration code that must create asset additions programmatically. Because it is a PVT package, Oracle does not guarantee backward compatibility of its signature; integrators should always target FA_ADDITION_PUB and treat FA_ADDITION_PVT as an internal dependency.