Search Results create_iac_acctg




Overview
Explore in AI Chat

Overview

IGI_IAC_REVAL_ACCOUNTING is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the accounting side of the Inventory Asset Clearing (IAC) revaluation process. Its role is to convert revaluation results maintained in the IGI_IAC tables into balanced, subledger-ready accounting entries. In practice the package evaluates revalued asset distributions, determines the appropriate debit and credit accounting flexfield combinations, and creates the accounting lines required to record revaluation gains, losses, and supporting adjustments. The package is part of the broader IGI_IAC module used by public sector and asset-intensive organizations that apply periodic asset revaluation and Inventory Asset Clearing reconciliation.

The body includes FND logging infrastructure (g_state_level, g_proc_level, g_event_level, g_excep_level, g_error_level, g_unexp_level, g_path) which indicates the package is designed for diagnostic tracing and controlled error handling consistent with Oracle's FND_LOG framework.

Key Procedures and Functions

Per the documented metadata, the package exposes a single documented entry point, CREATE_IAC_ACCTG. Internally, the source excerpt shows a companion private routine named create_acctg_entry. Both serve the same fundamental purpose: assembling a debit/credit accounting pair from revaluation detail and writing the resulting accounting record.

  • CREATE_IAC_ACCTG — The documented public procedure of the package. It is the callable interface through which revaluation accounting is generated for a given asset distribution and revaluation rate context.
  • create_acctg_entry — A private helper (defined within the body) that accepts a debit CCID, a credit CCID, an amount, an adjustment type for each side, a set of books identifier, a detail balance row type, a transfer-to-GL flag, and an event identifier (R12 uptake). It selects units_assigned from FA_DISTRIBUTION_HISTORY and, in bug fix 2448787, swaps the debit and credit CCIDs when the amount is negative. It also short-circuits and returns when the amount is zero, logging a debug message through igi_iac_debug_pkg.

The parameter names (p_dr_ccid, p_cr_ccid, p_amount, and others) are visible in the excerpt; parameter lists are not otherwise described here.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

  • IGI_IAC_TRANSACTION_HEADERS — header records that group and identify revaluation accounting transactions.
  • IGI_IAC_DET_BALANCES — detailed asset balance records whose book_type_code, asset_id, and distribution_id drive entry creation.
  • IGI_IAC_REVALUATION_RATES — revaluation rate rows used to compute or validate amounts.
  • FA_DISTRIBUTION_HISTORY — source of units_assigned for the asset distribution being accounted.
  • GL_CODE_COMBINATIONS — validation and resolution of debit and credit code combinations (CCIDs). This is directly relevant to the search term "check_ccid," since CCID values referenced by the package correspond to rows in GL_CODE_COMBINATIONS.

Usage Notes

The package is an internal accounting engine rather than a user-facing interface. It is invoked by the IAC revaluation processing flow, typically launched from concurrent programs or from other IGI_IAC packages that manage revaluation runs. The metadata notes it is referenced by one other package, reinforcing its role as a called component. Because the package constructs GL code combination references, any custom integration or extension that calls CREATE_IAC_ACCTG must supply valid CCIDs sourced from GL_CODE_COMBINATIONS and observe the transfer-to-GL flag and R12 event_id conventions. When customizing or debugging, enabling FND logging will surface the debug traces emitted by the create_acctg_entry helper, including the zero-amount skip path.