Error INV_IOI_MINMAX_MAX When Running EGO_ITEM_PUB.Process_Items API In EBS R12 (Doc ID 1554508.1)

Last updated on MARCH 23, 2016

Applies to:

Oracle Engineering - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Cannot update items. EGO_ITEM_PUB returns error.
Executed PL/SQL script to update items using EGO_ITEM_PUB.Process_Items API in Oracle EBS R12.

Error
INV_IOI_MINMAX_MAX when running EGO_ITEM_PUB.Process_Items API in EBS R12

Steps
The issue can be reproduced at will with the following steps:
1. Run the PL/SQL script that selects rows from MTL_SYSTEM_ITEMS_B to update
2. Load the row information into PL/SQL tables
3. Call the API EGO_ITEM_PUB.Process_Items to load the items
4. The process returns the error message "INV_IOI_MINMAX_MIN"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms