Results for “flm_vendormerge_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FLM_VENDORMERGE_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its source file is FLMTCAS.pls, and the package header identifies it as a grouping ("GRP" API classification) of functions called by the Suppliers Merge program. The package supports the Oracle Supplier Merge process by providing a programmatic entry point through which two supplier records — a surviving "vendor" record and a duplicate "vendor" record — are consolidated. This capability is central to supplier master data cleansing, where duplicate supplier, supplier site, and trading partner (party) records are merged to preserve a single authoritative record and to reassign the dependent transactions that reference the duplicate.

The header comment credits development to Adrian Suherman (08/11/2005), and the $Header revision string indicates a last change at version 120.0 dated 2005/10/19. The object therefore has a long-standing presence in the EBS code line and remains part of the documented metadata in ETRM 12.2.2, applying equally to the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes a single documented procedure:

• Merge_Vendor — The procedure that performs the supplier merge operation. It accepts standard Oracle API control parameters (API version, initialization of the message list, commit flag, and validation level) together with output status/error parameters, and it is also passed the identifier pairs that define the merge: the vendor and duplicate vendor IDs, the vendor site and duplicate vendor site IDs, and the party, duplicate party, party site, and duplicate party site IDs. The presence of both supplier-level and party-level identifiers reflects that the Supplier Merge program operates across the supplier and the underlying trading-community party model. Rather than documenting an invented parameter list, the signature above is taken directly from the package specification.

Tables Accessed

The documented table reference for this package is FLM_KANBAN_SUMMARY, accessed through an APPS synonym. This table is part of the Flow Manufacturing module's kanban structures and is relevant because supplier merges can affect kanban summary information tied to supplier and supplier site identifiers. In practice the Supplier Merge program behind this package also touches the standard supplier and party tables (for example the PO vendor, vendor site, and HZ party/site tables) that hold the surviving and duplicate records; however, FLM_KANBAN_SUMMARY is the table explicitly documented in the available metadata.

Usage Notes

FLM_VENDORMERGE_GRP is a grouping API intended to be invoked by the Oracle Suppliers Merge concurrent program rather than by end users directly. Because it participates in the supplier merge workflow, it is executed when a user submits the Suppliers Merge program to combine a duplicate supplier into a surviving supplier, selecting the vendor, vendor site, party, and party site identifiers to be merged. Custom integrations should call the API with a valid API version, respect the validation level, and check the return status and message count/data outputs for errors before committing. Given the revision history and unchanged documentation, organizations upgrading between 12.1.1 and 12.2.2 can expect consistent behavior from this object, and custom code that depends on it should be regression-tested against the target release.