Search Results fetch_service_receiving_acct




Overview
Explore in AI Chat

Overview

The APPS.IGI_ITR_ACCT_GENERATOR_PKG package body is a component of Oracle E-Business Suite's International Trade Management (ITM) / Intercompany Transaction Reconciliation (ITR) accounting infrastructure. Its primary business function is to generate and derive accounting flexfield combinations (CCIDs) used in intercompany charge processing. The package resolves charge service setups into valid Oracle General Ledger account combinations, applying the appropriate chart of accounts structure, account types, and segment values configured for intercompany billing relationships.

The best-known entry point, START_ACCT_GENERATOR_WORKFLOW, launches an Oracle Workflow process (item type ITRWKFAG) that drives account derivation. Supporting private logic resolves segments, counts, and names dynamically from the accounting flexfield definition. A private diagnostic helper, diagn_msg, writes conditionally filtered messages to the FND_LOG diagnostic framework based on the current runtime log level.

Key Procedures and Functions

  • START_ACCT_GENERATOR_WORKFLOW — Public entry point. Initiates the accounting generator workflow, accepting parameters that identify the chart of accounts, set of books, account type, charge center, preparer, charge service, cost center value, and additional segment value, and returns the derived CCID and concatenated segment string.
  • ACCOUNT_TYPE — Determines or derives the relevant account type for the transaction being processed.
  • FETCH_CREATION_ACCOUNT — Retrieves the account combination created during processing, typically used to confirm the generated CCID.
  • FIND_NO_OF_SEGS — Determines the number of segments defined for the applicable accounting flexfield structure.
  • INCREASE_COUNTER — Maintains an internal segment index/counter used while iterating over flexfield segments.
  • FETCH_SEGMENTI_VALUE and FETCH_SEGMENTI_NAME — Retrieve the value and descriptive name of the i-th segment in the accounting flexfield.
  • COST_CENTER_VALUE_CHOSEN and ADDITIONAL_SEG_VALUE_CHOSEN — Resolve the cost center and additional segment values selected by the caller into usable segment data.
  • FETCH_ADDITIONAL_SEG_NAME — Returns the descriptive name associated with the additional segment value.
  • FETCH_SERVICE_RECEIVING_ACCT — Derives the receiving-side account for the intercompany charge service being processed.

Tables Accessed

  • FND_ID_FLEX_SEGMENTS — The Application Object Library table defining accounting flexfield segments. It is queried to determine segment counts, segment values, and segment names.
  • IGI_ITR_CHARGE_SERVICE — Stores intercompany charge service definitions; supplies the receiving account and related accounting attributes.
  • IGI_ITR_CHARGE_SETUP — Stores intercompany charge setup configuration that governs how accounts are derived.
  • DUAL — Used for simple single-row expression evaluation and function calls.

Usage Notes

The package is invoked programmatically rather than through a standard form. Its principal public function, START_ACCT_GENERATOR_WORKFLOW, is designed to be called from intercompany charge processing logic, which then hands control to the ITRWKFAG workflow to complete account generation. Customizations and extensions should call the public function only; the remaining routines are private helpers whose signatures may change between patches.

The diagn_msg helper is significant for troubleshooting: it compares a supplied level against FND_LOG.G_CURRENT_RUNTIME_LEVEL and forwards messages to FND_LOG.STRING only when the level threshold is met, prefixing paths with IGI.PLSQL.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.. Administrators diagnosing account-generation failures should enable FND logging at the appropriate module level to surface these messages. Because no other packages reference this one, its usage is confined to the ITR charge accounting flow.