Search Results gmf_sync_vendor




Overview
Explore in AI Chat

Overview

The APPS.GMF_SYNC_VENDOR package is a PL/SQL synchronization utility within the Oracle E-Business Suite, belonging to the Process Manufacturing (GMF) product family. Its principal business function is to reconcile and synchronize vendor (supplier) information between the Process Manufacturing application tables and the core Oracle Payables / Oracle Purchasing vendor master. In process manufacturing environments, vendor records often originate in disparate operational systems and must be aligned with the centralized supplier records maintained by the Financials applications. GMF_SYNC_VENDOR provides the programmatic mechanism that performs this reconciliation.

The package is declared with AUTHID CURRENT_USER, indicating that it executes with the privileges of the invoking schema rather than the definer. The header comment reflects a maintenance history dating to 2002, and Bug#1677297 introduced two auxiliary printing procedures used for diagnostic and logging output during synchronization runs.

Key Procedures and Functions

The package exposes three documented procedures:

  • GMF_SYNC_VENDOR — The primary synchronization routine. It accepts an error buffer, a return code, and a company (CO) code to drive the vendor synchronization process, returning status information to the caller through its OUT parameters.
  • PRINT_LINE — A utility procedure that outputs a line of text, typically used to format diagnostic or audit messages generated during synchronization.
  • PRINT — A companion output procedure that emits textual information, generally used alongside PRINT_LINE for logging purposes.

The two printing procedures were added under Bug#1677297 to support visibility into the synchronization activity, providing developers and administrators with a means of tracing execution. Parameter lists are not reproduced here as documented; the procedures should be referenced according to their declared signatures in the package specification.

Tables Accessed

The package references two tables through APPS synonyms:

  • FND_PRODUCT_GROUPS — The Applications product groups table, which stores installation and product-group configuration information (such as the company/organization code). This is read to resolve the operating context and validate the CO code supplied to the synchronization routine.
  • GL_PLCY_MST — A policy master table used in the Financials/General Ledger domain, consulted during processing to apply the correct policy definitions relevant to the vendor synchronization.

Additional vendor and supplier tables may be manipulated indirectly through the synchronization logic, but only these two are documented as referenced within the package metadata.

Usage Notes

GMF_SYNC_VENDOR is typically invoked in process manufacturing implementations to align vendor data across application boundaries. It may be called from concurrent programs, from custom PL/SQL routines, or from internal process manufacturing flows that require vendor records to be consistent with the Financials supplier master. Because it is classified as OTHER rather than as a public API, it should be treated as an internal utility; direct invocation from custom code should be undertaken cautiously and only where the calling context supplies valid company codes and properly handles the returned error buffer and return code. The presence of the PRINT and PRINT_LINE routines suggests the package is also used interactively or in batch jobs where diagnostic output aids troubleshooting.