Search Results igi_iac_create_assets




Overview
Explore in AI Chat

Overview

IGI_IAC_CREATE_ASSETS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified as an OTHER API within the ETRM documentation. Its name and dependency footprint identify it as a component of the Oracle Financials for EMEA / International Assets and Capital (IAC) revaluation and inflation accounting feature set. In this context, the package is used to construct or refresh asset-level records that participate in periodic revaluation and inflation-adjusted asset processing. Specifically, it interacts with Fixed Assets base entities (additions, books, transaction headers, retirements) alongside a cluster of IGI_IAC-specific tables (revaluation rule, category, rate, balance and exception tables). This indicates that the package prepares the working data needed for revaluation rules to be applied to eligible assets, and it surfaces exception records when assets cannot be processed. The package status is VALID, confirming it is a supported runtime object in the 12.1.1 and 12.2.2 environments documented.

Key Procedures and Functions

The package exposes two documented callable units: LOG and GET_ASSETS.

  • LOG — A logging routine used to record diagnostic or processing messages generated during asset creation and revaluation activity. Log output supports troubleshooting when asset selection or revaluation rule evaluation fails, and is typically consumed during concurrent program execution.
  • GET_ASSETS — The principal driver routine. Based on its name and the tables referenced, it identifies or retrieves the set of Fixed Assets additions and related balances that qualify for inflation accounting or revaluation, applying the category-and-book rules defined in the IGI_IAC revaluation configuration tables.

No parameter signatures are documented in the ETRM metadata; parameter lists should be confirmed against the deployed package specification in the target environment before invoking either unit from custom code.

Tables Accessed

The package references the following tables via APPS synonyms:

Usage Notes

IGI_IAC_CREATE_ASSETS is not a general-purpose public API. The ETRM metadata records zero packages referencing it, which indicates it is invoked internally and is not part of a shared integration surface. Typical invocation paths are the IAC revaluation concurrent programs, where the program runs GET_ASSETS to build the candidate asset set and LOG to capture messages and exceptions. Custom code that calls this package directly should treat it as a private/internal API, confirm the specification signature on the target patch level (12.1.1 versus 12.2.2), and avoid reliance on its internal behavior across upgrades. Because it writes balance and exception data, any direct invocation should be coordinated with standard IAC revaluation cycles to prevent inconsistent revaluation results.