Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

How do you set the value of mtl_item_catalog_groups_b.item_creation_allowed_flag?

edited Feb 18, 2014 12:00PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

On the Item Master screen, when I query a given item and try to modify any data field and save it, I get this error message:

APP-FND-01048: Use of this combination restricted by WHERE clause ' (  ITEM_CATALOG_GROUP_ID IN  (SELECT ICG.ITEM_CATALOG_GROUP_ID          

FROM MTL_ITEM_CATALOG_GROUPS_B ICG                              

WHERE ICG.ITEM_CREATION_ALLOWED_FLAG = 'Y'                              

AND ((INACTIVE_DATE IS NULL) OR ((TRUNC(INACTIVE_DATE) > TRUNC(SYSDATE))          

OR (:MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID=ITEM_CATALOG_GROUP_ID)))) )  '.

I've found the record in the mtl_item_cataglog_groups_b table for this item, and the item_creation_allowed_flag is set to 'N', so it's clear why this statement is failing.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center