Search Results igi_exp_du_type_headers




Overview
Explore in AI Chat

Overview

IGI_VENDOR_MERGE_GRP is a public PL/SQL group package in the APPS schema of Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its name and API classification (GRP) identify it as an entry point for vendor merge and duplicate-suppression processing within the Oracle Financials for EMEA / IGI product family. The business purpose of the package is to consolidate a duplicate or superseded supplier record into a surviving vendor record while preserving the transactional, payment, and expense relationships that reference the losing party. The package coordinates the merge across the base Accounts Payable vendor entities and the IGI-specific expense and payment voucher tables, delegating the heavy lifting to the stored logic exposed by IGC_VENDOR_MERGE_PVT. Because it is a group package it is not intended to be re-entered recursively; it operates as a coordinating driver rather than a standalone business API.

Key Procedures and Functions

The documented package metadata exposes a single program unit, MERGE_VENDOR. No parameter list is documented, and none is asserted here. Functionally, MERGE_VENDOR accepts the identity of the duplicate vendor and the surviving vendor, validates their presence and merge eligibility, and then orchestrates the update or reassignment of all dependent records to the surviving party. It relies on standard EBS infrastructure to sequence work, obtain the session context, and report outcomes.

  • MERGE_VENDOR — the sole documented entry point. It performs validation of the merge request, invokes the private merge logic in the IGC vendor merge package, and returns a completion status consistent with the calling application's expectations.
  • Helper procedures referenced internally include FND_API for the standard API return structure and success/failure constants, FND_GLOBAL for session and user context, FND_MSG_PUB for message stack handling, FND_PROFILE for profile option lookups (including operating unit scoping), and IGI_GEN for IGI-specific shared utilities.

Tables Accessed

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

  • AP_DUPLICATE_VENDORS — the duplicate vendor register maintained by Payables; the package consults it to identify and mark the vendor being merged.
  • AP_INVOICES — open and historical invoices that reference the losing vendor; these must be identified before reassignment to the surviving vendor.
  • IGI_EXP_DUS — the IGI expense distribution / duplicate usage records tied to the affected vendor.
  • IGI_EXP_DU_TYPE_HEADERS — the header table that classifies IGI expense duplicate-usage types. This dependency explains why the user searching on igi_exp_du_type_headers would surface this package, as it joins those header definitions to the expense duplication logic.
  • IGI_EXP_AP_TRANS — the IGI expense-to-AP transaction bridge, used to keep expense transactions consistent when the vendor reference changes.
  • IGI_CIS_PAYMENT_VOUCHERS — CIS payment voucher records that carry the vendor identifier and must be preserved through the merge.

Usage Notes

IGI_VENDOR_MERGE_GRP is typically invoked indirectly — through the Payables vendor merge functionality or a related concurrent program — rather than being called from a data-entry form. Because the metadata records that it is referenced by only one other database object and references the internal private package IGC_VENDOR_MERGE_PVT, customizations should call MERGE_VENDOR as the supported surface and should not manipulate the underlying tables directly. When invoking it in custom code, standard EBS conventions apply: initialize the FND session (FND_GLOBAL.APPS_INITIALIZE), ensure the correct operating unit profile context, and inspect the FND_MSG_PUB stack on failure. In 12.2.2 the object remains VALID, and the dependency set is unchanged from 12.1.1, so behavior is consistent across both releases.