Search Results process_item_category_records

Overview

INV_ITEM_CATEGORY_OI is an Oracle E-Business Suite open interface package owned by APPS that supports the bulk loading and maintenance of item-category assignments within Oracle Inventory. Its name follows the "OI" (Open Interface) convention, indicating that its primary purpose is to validate, transform, and import records staged in interface tables into the base Inventory tables, and to purge those staged records once processing completes. In practice, this package is the programmatic engine behind the Item Category Assignment open interface, allowing customers to assign items to categories across one or more category sets in a batch fashion rather than through the Inventory forms.

Key Procedures and Functions

• PROCESS_ITEM_CATEGORY_RECORDS — The primary driver of the open interface. It processes the staged item-category records identified by a record set identifier, orchestrating validation, upload, and deletion phases according to the control flags supplied by the caller. It accepts a record set identifier and a series of optional flags governing validation, upload, deletion, and commit behavior, along with standard concurrent-program context parameters (program application, program, request, user, and login identifiers). It also returns the conventional concurrent program ERRBUF and RETCODE outputs, enabling it to be registered and executed directly as a concurrent program. This procedure is the object most commonly associated with the search term "process_item_category_records."
• DELETE_OI_RECORDS — A supporting routine that removes processed records from the open interface staging area. It takes a record set identifier and a commit indicator, and returns a return-status value signalling success or failure. Its function is to keep the interface tables clean after a load cycle or to support re-processing by clearing previously staged rows.

Tables Accessed

The package reads and writes across the interface, validation, and base Inventory tables. Staging and interface data reside in MTL_ITEM_CATEGORIES_INTERFACE, with bulk-load control information in MTL_ITEM_BULKLOAD_RECS and related interface staging in MTL_SYSTEM_ITEMS_INTERFACE (including its _S variant). Validation relies on setup and master data including MTL_CATEGORY_SETS_B, MTL_DEFAULT_CATEGORY_SETS, MTL_ITEM_CATALOG_GROUPS_B, MTL_PARAMETERS, and MTL_SYSTEM_ITEMS_B. Validated records are written into the base assignment table MTL_ITEM_CATEGORIES. DUAL is referenced for standard PL/SQL lookups. Together these tables provide the item, category set, and inventory organization context required to validate and persist category assignments.

Usage Notes

INV_ITEM_CATEGORY_OI is typically invoked by the Item Category Assignment open interface concurrent program, which supplies the record set identifier and processing flags, and it may also be called from custom PL/SQL wrappers that stage rows directly in the interface tables. Because the parameter list mirrors concurrent program conventions, results are reported through the standard request log and completion status. The package's global variables (record set, user, login, program, and request identifiers) are initialized at the start of processing to provide consistent auditing context. Two other packages reference it, indicating it participates in a broader item-loading dependency chain. When calling from custom code, the interface rows should be fully populated before execution, and the delete flag managed carefully to avoid premature removal of staging data.