Non-Existing Item Categories Can be Uploaded Through Item Loader After Staging the Items With Excel to CI template (IN_MST_ITM_XLS Component Interface) (Doc ID 2683672.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

Non-Existing Item Categories can be uploaded using Item Loader - this is incorrect. The process defines an item even when the item category code entered in the data input from the Excel To CI template (CI - IN_MST_ITM_XLS) is not defined in the system. There should be an error message saying the item category does not exist. But rather than receiving an error message, the template defines the new item category in Items> Define Controls> Item Categories, and it creates it with no Description (although this field is mandatory for Item Category).

Steps to reproduce the issue:

1. Open the Excel To CI, select, input data, stage and submit, inserting all fields necessary for an item creation, including an item category ABCD that does not exist in Items > Define controls > Item Categories. No error occurs.
2. Run Item Loader in_itmload. (SCM Integrations > Process Transactions > Items > Item Loader).
3. Search for the newly created item. It has a new Default Category ABCD which was staged using the Excel to CI template. This category is incorrect and it has no description, although this is mandatory field.

Changes

 N/A

Cause

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