Not Able to Create SKUs, Error "Attributes CURRENT_PHASE_ID and INVENTORY_ITEM_STATUS specified is not a valid combination." (Doc ID 1486423.1)

Last updated on MAY 15, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a SKU item via EGOIJAVA module: EGO Spreadsheet Java Concurrent Program, the following error occurs.

ERROR

-----------------------
TRANSACTION ID : 3062
ORGANIZATION ID : 82
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.

TRANSACTION ID : 3060
ORGANIZATION ID : 82
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : INVENTORY_ITEM_STATUS
MESSAGE NAME : INV_IOI_INVALID_PHASE_STATUS
ERROR MESSAGE : Attributes CURRENT_PHASE_ID and INVENTORY_ITEM_STATUS specified is not a valid combination.

The issue can be reproduced at will with the following steps:

  1. Development Manager > Item Catalog > Item Simple Search
  2. Search for a Standard item
  3. Navigate to the button of the page and click on Create
  4. Select the variant attributes
  5. Insert the item Number and description and click Apply > Batch submitted
  6. Batch Ends with a Warning and log files shows errors

 

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