Search Results catg_set_id

Overview

INVPVALI (Inventory Item Validation) is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the validation of inventory item and item revision interface data prior to import into Oracle Inventory. Its principal responsibility is to reconcile rows staged in the Open Interface tables against existing production item definitions, flagging or rejecting records that cannot be correctly processed. The package is classified generically as OTHER rather than a public API, indicating it is primarily an internal utility invoked by the Inventory item import infrastructure rather than a documented integration point for external callers.

Because the interface records are large in volume and subject to referential rules spanning organizations, item sets, and categories, INVPVALI consolidates the validation logic so that failures are recorded as errors rather than causing the interface process to abort. A notable detail in the source is the confirmation comment that organization, category set, and category identifiers are validated in the assign function associated with the category set, and that INVPVALI validates only the item identifier in this context—an important scoping note for anyone searching on catg_set_id who assumes the value is verified inside this package.

Key Procedures and Functions

• VALIDATE_ITEM_REVS — Validates item revision interface rows staged in MTL_ITEM_REVISIONS_INTERFACE. It processes rows selected by set process identifier and organization, marking as errors those interface rows that have no corresponding item in either the production item tables or the item interface table, and it checks the item-revision combination against the uniqueness enforced by ORGANIZATION_ID, REVISION, and INVENTORY_ITEM_ID. Error text is returned to the caller through an output parameter. Documented bug history reflects performance tuning, replacing a full table scan with the MTL_ITEM_REVS_INTERFACE index.
• MTL_PR_VALIDATE_ITEM — The second documented program unit in the package, providing item-level validation logic used in conjunction with the revision validation. It is referenced in the same import context and confirms that the package addresses both revision-level and item-level interface validation.

Tables Accessed

All access occurs through APPS synonyms. The package reads and updates MTL_ITEM_REVISIONS_INTERFACE, the staging table holding revision import rows, and cross-references MTL_ITEM_REVISIONS_B and MTL_ITEM_REVISIONS_B_S for existing revision definitions. Item existence is verified against MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B, with MTL_SYSTEM_ITEMS_INTERFACE consulted so that items being created in the same interface run are not falsely rejected. MTL_PARAMETERS supplies inventory organization context, EGO_IMPORT_OPTION_SETS supports import option and set-group configuration for the interface process, and DUAL is used for simple singular evaluations.

Usage Notes

INVPVALI is invoked indirectly through the Oracle Inventory item import flow—typically the Item Import concurrent program or the interface validation step that precedes import—rather than being called directly from Oracle Forms. It is referenced by four other packages within the EBS code base, which is consistent with a shared validation utility. Custom code should avoid direct invocation, since the package performs staged-row validation using set process identifiers and process flags whose lifecycle is managed by Oracle's import program; callers requiring catalog group or category set validation should note that catg_set_id is validated elsewhere, in the assign function, not within this package.