Search Results fa_transaction_headers_s




Overview
Explore in AI Chat

Overview

The APPS.FA_MODIFY_DISTRIBUTIONS_PKG package body provides the server-side distribution-processing logic used by Oracle E-Business Suite Fixed Assets when an asset's distribution lines must be changed after capitalization. Its principal role is to support mass external transfers and manual distribution reassignments, allowing the assignment of an asset (or a portion of its units) to move from one location, employee, or general ledger account to another. The package validates the request, rebuilds the assignment table, reverses the accounting pertaining to the old distribution, and inserts the new distribution rows so that depreciation can subsequently be recalculated against the corrected chart-of-accounts combination.

Because distributions are heavily tied to the transaction header that created them, the package works closely with FA_TRANSACTION_HEADERS and its sequence-backed counterpart FA_TRANSACTION_HEADERS_S. It is documented in ETRM as an OTHER-classified API (that is, an internal or supplementary API rather than a formally published interface) and is validated in both 12.1.1 and 12.2.2.

Key Procedures and Functions

  • LOAD_ASGN_TABLE — Populates the in-memory PL/SQL assignment table (backed by PLITBLM) with the current assignments for the asset being processed, forming the working set for later validation and update.
  • MODIFY_DISTRIBUTIONS — The main driver. Orchestrates validation, adjustment, and persistence of the modified distribution lines for an asset or unit.
  • INSERT_DIST_TABLE — Writes the newly computed distribution rows into FA_DISTRIBUTION_HISTORY after the change has been accepted.
  • PROCESS_UNIT_ADJUSTMENT — Handles partial-unit changes, where only a subset of an asset's units is reassigned rather than the entire asset.
  • PROCESS_TRANSFER — Executes transfer-type distribution changes, including mass external transfer scenarios.
  • GET_HEADER_INFO — Retrieves the relevant transaction header details (including the sequence value from FA_TRANSACTION_HEADERS_S) required to associate the modification with a valid transaction.
  • CHECK_IF_CORP_BOOK — Determines whether the book in context is a corporate book, since corporate and tax books are subject to different distribution and depreciation rules.
  • CHECK_LOCATION_CCID — Validates the location and the associated GL_CODE_COMBINATIONS identifier, ensuring the target account is valid before the change is committed.

Tables Accessed

The package reads and writes a focused set of Fixed Assets tables. FA_ADDITIONS_B and FA_LEASES supply the asset and lease context; FA_BOOK_CONTROLS and FA_FISCAL_YEAR establish book and period rules; FA_DEPRN_PERIODS and FA_DEPRN_SUMMARY provide the depreciation state that must remain consistent with the revised distribution. FA_DISTRIBUTION_HISTORY is the primary target for the new rows, while FA_LOCATIONS and GL_CODE_COMBINATIONS validate location and accounting-flexfield values. FA_TRANSACTION_HEADERS and FA_TRANSACTION_HEADERS_S link the distribution to its originating transaction, and FA_MASS_EXTERNAL_TRANSFERS supports the mass transfer workflow. PLITBLM is used as the PL/SQL table type backing the in-memory assignment set, and DUAL and PUBLIC are standard references.

Usage Notes

This package is not a published public API; it is invoked internally by Fixed Assets forms, concurrent programs such as Mass External Transfers and Mass Reclassification, and by FA_TRANS_API_PUB / FA_UTIL_PUB, both of which appear in its dependency list. Because FA_MODIFY_DISTRIBUTIONS_PKG is itself not referenced by any other database object according to ETRM, custom code should avoid calling it directly and instead use the supported distributed-asset APIs. Any modification to distribution history carries depreciation and accounting consequences, so it should only be run within the correct open period.