Search Results check_location_ccid

Overview

FA_MODIFY_DISTRIBUTIONS_PKG is an Oracle EBS Applications (APPS) PL/SQL package that supports the Oracle Assets (FA) module. It provides the programmatic infrastructure for modifying the distribution of asset costs across accounting flexfield combinations (code combination IDs), most notably in the context of transfers, adjustments, and mass external transactions. An asset's distribution identifies the general ledger accounts to which that asset's cost, depreciation, and related balances are posted, so this package is central to keeping the accounting distribution synchronized when ownership, location, or expense assignment of an asset changes.

The package is owned by the APPS schema with a status of VALID, indicating it is a supported, compiled database object rather than a stub or a placeholder. In the metadata model it is classified as an "OTHER" API, meaning it is not part of the officially documented public API family, but it remains a functioning internal package referenced by other components of the E-Business Suite.

Key Procedures and Functions

ETRM documents eight procedures and functions within this package. The main entry point, MODIFY_DISTRIBUTIONS, drives the process of changing an asset's cost or depreciation distributions in response to a transaction. Supporting this, LOAD_ASGN_TABLE and INSERT_DIST_TABLE build and populate the internal distribution working structures from either assignment data or existing distribution records, so that the modification logic operates against a consistent in-memory model before committing changes.

PROCESS_TRANSFER handles the distribution changes arising from asset transfers, while PROCESS_UNIT_ADJUSTMENT addresses the redistribution required when units of a grouped or multi-unit asset are adjusted. CHECK_IF_CORP_BOOK determines whether a given book is a corporate book, which affects validation and the scope of distribution processing. CHECK_LOCATION_CCID validates that a location maps to a valid code combination identifier. GET_HEADER_INFO retrieves transaction header information needed to drive the distribution modification. Together these procedures form the low-level engine that Oracle Assets calls when distributions must be recalculated, validated, or rewritten.

Tables Accessed

The package interacts with a substantial set of Assets and General Ledger tables through APPS synonyms. FA_ADDITIONS_B, FA_LEASES, and FA_LOCATIONS supply the asset identification and location attributes. FA_BOOK_CONTROLS, FA_DEPRN_PERIODS, FA_DEPRN_SUMMARY, and FA_FISCAL_YEAR provide book and depreciation-period context. Distribution and transaction detail is drawn from FA_DISTRIBUTION_HISTORY, FA_TRANSACTION_HEADERS, FA_TRANSACTION_HEADERS_S, and FA_MASS_EXTERNAL_TRANSFERS. GL_CODE_COMBINATIONS is used to validate accounting flexfield combinations, and PLITBLM supplies additional supporting data. These references confirm that the package reads asset and book setup and writes distribution and transaction records.

Usage Notes

FA_MODIFY_DISTRIBUTIONS_PKG is invoked internally by Oracle Assets transaction processing — particularly transfer and adjustment workflows that change an asset's accounting distribution. It is also referenced by CSE_IFA_TRANS_PKG, which links Assets distribution handling to the iAssets/fixed-asset transfer integration, and it references itself for dependent code. Because it is designated as an OTHER API rather than a formally documented public API, it should be treated as internal. Custom code should prefer calling supported Assets APIs and would rely on this package only when replicating standard transfer or adjustment behavior, and then with careful attention to version-specific behavior.