Search Results get_items_to_synch

Overview

BOM_STRUCT_SYNC_PUB is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports synchronization of bill of material (BOM) structure data. Its header identifies it as BOMSYNCS.pls, created on 02-Jan-2008 by PGANDHIK, and it is classified as a PUB (public) API, meaning it is intended for external invocation by other Oracle EBS modules and customer extensions rather than being restricted to internal use. The package's central role is to assemble and expose BOM structural information in XML format, enabling external systems — such as manufacturing execution systems, integration middleware, or supply chain applications — to consume parent-child component relationships for a given item within a specified inventory organization. By emitting an XMLTYPE payload, the package provides a denormalized, portable representation of the BOM explosion, which is well suited for data exchange and downstream processing.

Key Procedures and Functions

The package exposes three documented procedures, all taking an organization identifier and an item identifier as primary inputs and returning an XMLTYPE document together with an error code and error message:

• GET_STRUCTURE_PAYLOAD — Returns the BOM structure payload for the specified organization and item as an XMLTYPE. This procedure is the primary entry point for retrieving a complete structural representation of the item's bill of material.
• GET_ITEMS_TO_SYNCH — Returns the set of items that require synchronization, again expressed as an XMLTYPE payload. This is the procedure associated with the search term "get_items_to_synch" and is used to determine which item structures need to be pushed or refreshed to a downstream target.
• EXPLODE_STRUCTURE — Explodes the BOM structure for the given organization and item, returning an item count in place of an XMLTYPE payload. This procedure provides a count of the constituent items produced by the explosion, which is useful for validation, capacity estimation, or reconciliation before a full payload is requested.

No parameter lists beyond those documented in the package specification should be assumed; the documented signatures consistently expose organization ID, item ID, an optional XMLTYPE output, and standardized error code and error message outputs.

Tables Accessed

The package operates against several documented data sources referenced through APPS synonyms:

• BOM_EXPLOSIONS — The core source of the exploded bill of material hierarchy, supplying parent-child component relationships used to build and count the structure.
• MTL_SYSTEM_ITEMS_B — Supplies item master attributes for the organization and item being processed, ensuring the correct item context is applied.
• XMLTYPE — The Oracle XML datatype used to construct and return the payloads generated by GET_STRUCTURE_PAYLOAD and GET_ITEMS_TO_SYNCH.
• XMLAGG — The SQL/XML aggregate function used to assemble multiple rows into a single XML document, consistent with the package's payload-generation behavior.

Usage Notes

BOM_STRUCT_SYNC_PUB is not referenced by any other documented package, indicating it is designed as a top-level integration API. It is typically invoked from custom PL/SQL code, concurrent programs, or integration middleware that need to extract BOM structure data in XML form for synchronization to external systems. Callers should supply a valid organization ID and item ID, and should inspect the returned error code and error message outputs to detect failures. Because the procedures return XMLTYPE payloads via NOCOPY OUT parameters, callers must allocate the corresponding output variables before invocation. The package is available in both Oracle EBS 12.1.1 and 12.2.2 and remains a stable public interface for BOM structure synchronization.