Search Results sync_item

Overview

ITG_SYNCITEMINBOUND_PVT is a private (PVT-classified) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its principal business function is the inbound synchronization of item master records into the EBS item interface tables, originating from external or legacy procurement and supply-chain systems. The package name and the retained ARCS/CVS header annotations (itgvsiib.pls) indicate it belongs to the Oracle iProcurement / Advanced Procurement item synchronization family, and the public entry point Sync_Item carries an explicit reference to logic originally held in poisibio.sql.

At a functional level, the package accepts externally supplied item attributes — item number, unit of measure, description, status, type, commodity classifications, hazardous material indicators, and reference routing — and stages them for processing by the standard item interface import. It operates within an autonomous transaction so that it may independently commit or roll back its work without affecting the calling session.

Key Procedures and Functions

The documented interface comprises one public business-object API and four supporting procedures:

• SYNC_ITEM — The primary inbound API. It declares itself as an "Apps Business Object API call" and is the mechanism through which an external caller submits a single item synchronization request. It initializes the standard API return status, resolves the organization context, and orchestrates the staging of item data. Documented parameters include the synchronization indicator, organization identifier, hazardous material indicator, creation date, item name, UOM, description, status, type, reference routing, and two commodity attributes.
• GET_NEXTPROCESSSETID — Allocates the next processing set identifier, allowing a batch of synchronized items to be grouped and tracked as a single unit of work.
• START_BATCHPROCESS — Initiates the batch processing run for a previously identified item set, driving the staged rows toward the item interface import.
• REAP_BATCHRESULTS — Collects and reconciles the outcome of a completed batch, determining success or failure for the constituent records.
• ERROR_TRANSACTIONS — Handles failed records, surfacing error information for the transactions that could not be processed successfully.

Tables Accessed

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

• MTL_SYSTEM_ITEMS_INTERFACE — The principal staging table for inbound item attributes.
• MTL_SYSTEM_ITEMS_INTF_SETS_S — Supplies processing set identifiers used by GET_NEXTPROCESSSETID and START_BATCHPROCESS.
• MTL_ITEM_CATEGORIES_INTERFACE — Stages category assignments associated with the item.
• MTL_INTERFACE_ERRORS — Receives validation and import errors, supporting ERROR_TRANSACTIONS.
• PO_HAZARD_CLASSES — Resolves the hazard class identifier from the supplied hazardous material value.
• DUAL — Used for scalar expressions and sequencing.

Usage Notes

ITG_SYNCITEMINBOUND_PVT is a private package and is not intended for direct external invocation. It is referenced by one other package within the APPS schema, which supplies the public wrapper through which the functionality is exposed. Practically, the package is invoked when item data originating outside EBS must be brought into the item master — for example, during supplier or legacy system onboarding, or during scheduled item synchronization runs driven by the calling package. Developers integrating with this area should target the calling public API rather than this private package, and should respect its autonomous-transaction semantics and the standard FND_API return-status convention when interpreting results.