My Oracle Support Banner

Master Note on Item Imports, Item-Organization Setup and Categories Related Issues (Doc ID 1156616.1)

Last updated on JANUARY 23, 2020

Applies to:

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

Details

This document is a master note which consolidates all important documents available on Inventory items, categories and item import functionalities.

All the documents has been classified in following sections:

Components
Setup/Configuration Documents
Debugging Methods
FAQ/Consultative Questions
Known Issues & Suggested Patch
Standard Datafixes

The document is useful to track all documents related to debugging, setup, FAQ and existing issues from a single page.

The modification of this document will be an ongoing process and will be updated based on the feedback from various sources.

Actions

Check documents on item setup, organization item assignment and organization setup.

Components Setup or Configuration Documents Debugging Methods FAQ and Consultative Questions

Known Issues & Suggested Patch Standard Datafixes
Item Setup-Master/Org Item form (INVIDITM)  
Note.113046.1 - Quick Reference for Inventory Item Setup and Control
 
Note.150168.1 - Form runtime Diagnostic 11i

Note. 438652.1 - Form runtime Diagnostic R12



 
Note.111742.1 - Item Setup FAQ
 
Note.432698.1 - Performance Patches For Items Form(INVIDITM), Item Import(INCOIN), Bill and Routing Interface (BMCOIN), Engineering in 11.5.10
 
Note.388325.1 - Create Missing Records in MTL_SYSTEM_ITEMS_TL Table
   
Note.226596.1 - Defining Item Costs
 
Note.223702.1 - Inventory Item Setup Data Collection Tool
 
Note.109665.1 - Organization Setup Frequently Asked Questions - FAQ
 
Note.789050.1 - Cannot Create/Assign Item in Master Items or Import Items
 
Note.1276972.1 - Error: 'FRM-40654 - Cannot Update Item from Organization Item Form
 
   
Note.226437.1 - Define Items MPS/MRP Planning Attribute Group
 
Note.148651.1 - INV DEBUG: How to get Debug Information for Inventory Material Transactions
 
Note.395493.1 - How to Use the Public APIs for Inventory
 
Note.1276972.1 - EBS INV Error: 'FRM-40654 - Cannot Update Item from Organization Item Form
 
   
Inventory User Guide - Define Inventory Organization
   
Note.268244.1 - Oracle Inventory Organizations - FAQ
 
Note.1061302.1 - INVIDITM: Cannot Update Item Name in Master Items Form
 
         
Note.761264.1 - INVIDITM: Change Item Status Error: There Are Open Deliver Transactions For This Item
 
         
Note.552336.1- Errors FRM-40654, FRM-40735, ORA-20001, Could Not Reserve Record, When Trying To Update Item In Items Form, INVIDITM.
 
         
Note.855763.1 - APP-INV-05525 When Updating Serial Control Attributes for Items Where No Onhand Exists.
 
         
Note.413104.1 - How to Research an Item that cannot be Queried in the Master or Organization Items Form
 

 

Check documents on item import setup, debugging, FAQs and common issues.

Components Setup or Configuration Documents Debugging Methods FAQ and Consultative Questions

Known Issues & Suggested Patch Standard Datafixes
Item Open Interface - INCOIN process which includes revision import  
Note.115557.1 - How to Use Item Open Interface (IOI) to Import Item Category Assignments
 
Note.148651.1 - INV DEBUG: How to get Debug Information for Inventory Material Transactions
 
Note.109628.1 - FAQ for Item Import
 
Note.334433.1 - INCOIN - Poor Performance issue On Item Import On 11.5.10

Note.1109254.1 - INCOIN: Performance Issue When Running Item Import



To Be Prepared
   
Note.1066901.1 - How to create Organization Hierarchy and run Item Organization Assignment program
 
Note.268968.1 - Understanding Item Import and Debugging Problems with Item Import
   
Note.52746.1 - A Guideline to IOI Error Messages and Solutions
 
   
Note.61933.1 - Customer Items and Customer Item Cross-Reference Open Interface
   

 
Note.429924.1 - Troubleshooting Guide for INV_IOI_MASTER_CHILD Errors in Item Import
 
   
Note.191376.1 - How to Import Item Costs Using the Item Open Interface
     
Note.840139.1 - Import Items (INCOIN) Will Fail with Error 'ORA-01000: maximum open cursors exceeded'
 
         
Note.801354.1 - INCOIN Item Import Will Reject Items With INV_IOI_REV_NO_ITEM Error - The revision entered is for an item that does not exist
 
         
Note.803007.1 - Item Import Failed Due To Special Character Backslash in Item Number
 
         
Note.359552.1 - INCOIN: Error BOM_PARSE_ITEM_ERROR When Creating New Items
 

 

Check documents on item category setup, debugging, FAQs and common issues.

Components Setup or Configuration Documents Debugging Methods FAQ and Consultative Questions

Known Issues & Suggested Patch Standard Datafixes
Item Categories-All forms or tables assoc. with setup of categories  
Note.423551.1 - How to create a Category Set and Assign Items to Categories
 
Note.148651.1 - INV DEBUG: How to get Debug Information for Inventory Material Transactions
 
Note.275541.1 - Item category Frequently Ask Questions
 
Note.810883.1 - APP-INV-05357 While Trying To Change The Control Level Of Category Set From Organization to Master Level
To Be Prepared
   
Note.75014.1 - Item Catalogs Setup
     
Note.850604.1 - When Assigning Product Category Set to Item, Error "APP-INV-05190: This Category Set/Category Combination Is Not Valid"
       
Note.842308.1 - How To Change Item Category Through Item Import
 
Note.358315.1 - Unable To Change The Inventory Item Category For Any Items
 
       
Note.141967.1 - Item Number Displays as an X in Various Forms and Reports Throughout the Application
 

 

Other important links.

Name Links
Community  
Master Date Management
Knowledge Contents  
My Oracle Support

Contacts

To view full details, sign in with your My Oracle Support account.

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


In this Document
Details
Actions
 Check documents on item setup, organization item assignment and organization setup.
 Check documents on item import setup, debugging, FAQs and common issues.
 Check documents on item category setup, debugging, FAQs and common issues.
 Other important links.
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.