Search Results insert_exceptions

Overview

IGI_IAC_CREATE_ASSETS is an Oracle E-Business Suite package body owned by the APPS schema and classified under the API classification OTHER. In the context of Oracle EBS 12.1.1 and 12.2.2, it forms part of the IGI (Oracle Financials for Government/Public Sector) asset-related extension set, specifically the IAC (Intelligent Asset Creation or asset revaluation support) family of packages. Its principal business function is to assemble and create asset records within Oracle Assets, deriving cost and balance information from the IGI asset-balance, revaluation, and exception tables and reconciling that information against the standard FA base tables such as FA_ADDITIONS, FA_BOOKS, FA_RETIREMENTS, and FA_TRANSACTION_HEADERS. The package also centralizes diagnostic logging through a small wrapper procedure so that asset creation activity and exception conditions can be traced during batch execution.

Key Procedures and Functions

Two procedures are documented in the ETRM metadata:

• LOG — A diagnostic helper that emits a message to the concurrent request log file. It is controlled by a profile option (IGI_DEBUG_OPTION) and uses fnd_file.put_line to write to the log destination. It is used throughout the package to trace processing steps and to surface error or exception messages.
• GET_ASSETS — The principal driver routine that retrieves the set of assets to be processed. It gathers asset identifiers and their associated balances and revaluation data so that downstream logic can create or adjust the corresponding Oracle Assets records.

The source excerpt also shows an internal helper, GET_ADJUSTED_COST, which returns the adjusted cost of an asset for a given book and period counter by selecting from IGI_IAC_ASSET_BALANCES at the maximum period counter available. Portions of this helper were disabled by bug fix 3451539, removing the prior dependency on the FA_BOOKS period_counter_fully_reserved column.

Tables Accessed

The documented tables referenced through APPS synonyms are:

• FA_ADDITIONS, FA_BOOKS, FA_RETIREMENTS, FA_TRANSACTION_HEADERS — standard Oracle Assets tables read to validate assets, books, retirements, and transaction context before creation or update.
• IGI_IAC_ASSET_BALANCES — holds adjusted cost and balance information used to derive asset values.
• IGI_IAC_CATEGORY_BOOKS — category-to-book mapping used to resolve revaluation and accounting rules.
• IGI_IAC_EXCEPTIONS — stores exceptions raised or captured during asset creation, closely related to the user search term "insert_exceptions".
• IGI_IAC_REVALUATIONS, IGI_IAC_REVALUATION_RATES, IGI_IAC_REVAL_ASSET_RULES, IGI_IAC_REVAL_CATEGORIES — revaluation definitions, rates, asset-level and category-level rules that determine adjusted values.
• PLITBLM — a PL/SQL index-by table type used internally.

Usage Notes

This package is typically invoked from concurrent programs within the IGI asset revaluation and creation flows rather than from a standard Oracle Assets form. It is not referenced by any other package, so it functions as a top-level entry point called directly by a concurrent manager or a scheduled batch job. The "insert_exceptions" search term aligns with its exception-handling path, where failed or rejected asset lines are recorded via IGI_IAC_EXCEPTIONS. Custom code should not call the internal helper routines directly; integration should occur through the documented procedures and the concurrent program that drives them.