Item Import Error INV_CAT_SET_NO_DEFAULT_CAT When Using The Item Open Interface

(Doc ID 2145577.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

While using the Items Open Interface (IOI) with the following used for the insert statement into MTL_SYSTEM_ITEMS_INTERFACE: item, description, organization, template, primary uom, transaction type='CREATE',process_flag=1,set_process_id=1000

The following error is received:

ERROR

3. Inventory Responsibility:
4. Navigation: Items > Import > Import Items
5. Use the following parameters:
Argument 1 (ORG_ID) = 101
Argument 2 (ALL_ORG) = 1
Argument 3 (VAL_ITEM_FLAG) = 1
Argument 4 (PRO_ITEM_FLAG) = 1
Argument 5 (DEL_REC_FLAG) = 2
Argument 6 (PROCESS_SET) =
Argument 7 (MODE) = 1
Argument 8 (Gather Stats) = 1

 

**The SAME error can occur when using the EGO_ITEM_PUB.Process_Items API

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