Search Results igi_itr_acct_generator_pkg




Overview
Explore in AI Chat

Overview

IGI_ITR_ACCT_GENERATOR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API within Oracle's ETRM (E-Business Suite Technical Reference Manual) repository. It belongs to the IGI module — the family of application objects that support Oracle's intercompany and international trade functionality — and specifically to the IGI_ITR ("Intercompany Transaction Reconciliation" / intercompany transfer pricing) subsystem. The package's central role is the dynamic generation of accounting flexfield combinations for charge transactions processed through the intercompany transaction reconciliation flow. It builds account strings at runtime by deriving individual flexfield segment values and assembling them into a valid code combination, which is then used to create accounting entries for charges and service-related transactions.

The package drives this generation logic through a workflow-based mechanism, evidenced by the START_ACCT_GENERATOR_WORKFLOW procedure, which suggests that account generation is initiated as part of the Oracle Workflow process associated with intercompany charge accounting rather than through purely synchronous user actions.

Key Procedures and Functions

The package exposes eleven documented procedures and functions that collectively handle workflow initiation, account derivation, and segment resolution:

  • START_ACCT_GENERATOR_WORKFLOW — Launches the workflow process that orchestrates accounting combination generation for intercompany charge transactions.
  • ACCOUNT_TYPE — Determines or classifies the account type for which a combination is being generated.
  • FETCH_CREATION_ACCOUNT — Retrieves the account(s) associated with the creation of the transaction, providing the basis for the generated code combination.
  • FIND_NO_OF_SEGS — Identifies the number of segments in the target accounting flexfield structure, enabling the generator to iterate over all required segments.
  • INCREASE_COUNTER — Manages an internal counter, likely tracking the current segment position or iteration index during dynamic combination assembly.
  • FETCH_SEGMENTI_VALUE — Fetches the value of the "i-th" (indexed) accounting flexfield segment, supporting dynamic traversal of the segment structure.
  • FETCH_SEGMENTI_NAME — Fetches the name/label of the indexed segment, used to interpret or validate the segment being processed.
  • COST_CENTER_VALUE_CHOSEN — Handles the selection/derivation of the cost center segment value used in the generated account.
  • ADDITIONAL_SEG_VALUE_CHOSEN — Resolves the value for an additional (non-primary) segment in the account structure.
  • FETCH_ADDITIONAL_SEG_NAME — Retrieves the name of the additional segment being populated.
  • FETCH_SERVICE_RECEIVING_ACCT — Fetches the receiving account associated with a service charge, supplying the accounting destination for service-based intercompany transactions.

The naming pattern indicates a design that iterates over flexfield segments and resolves each segment's value individually, then combines them into a complete accounting flexfield combination.

Tables Accessed

The package interacts with the following tables, referenced through APPS synonyms:

  • FND_ID_FLEX_SEGMENTS — The Oracle Application Object Library table that stores the definition of key flexfield segments. The package reads this table to determine segment structure, ordering, and names, supporting FIND_NO_OF_SEGS, FETCH_SEGMENTI_NAME, and related procedures.
  • IGI_ITR_CHARGE_SERVICE — Stores service-charge data for intercompany transactions; read by FETCH_SERVICE_RECEIVING_ACCT to derive the receiving account.
  • IGI_ITR_CHARGE_SETUP — Stores charge configuration/setup information used to determine how accounts should be generated for given charges.
  • DUAL — The standard Oracle single-row dummy table, used for simple evaluations and function-based queries.

Usage Notes

IGI_ITR_ACCT_GENERATOR_PKG is invoked within the intercompany charge accounting flow, typically triggered by workflow processing rather than direct user data entry. Given the START_ACCT_GENERATOR_WORKFLOW entry point, the package is designed to be launched from an Oracle Workflow activity associated with intercompany transaction reconciliation. It is referenced by zero other packages according to the ETRM metadata, indicating that it functions as a top-level utility within its module rather than a shared library. Customizations should account for its dependency on flexfield definitions; changes to the chart of accounts structure in FND_ID_FLEX_SEGMENTS will directly affect the combination-generation behavior. Because the package is classified as OTHER rather than a public API, Oracle does not guarantee interface stability, and direct calls from custom code should be avoided in favor of the standard intercompany charge process.