NEW_ITEM_REQUEST_REQD is NULL in Table MTL_ITEM_CATALOG_GROUPS_B When Item Catalog Category is Created using API EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups (Doc ID 2294100.1)

Last updated on AUGUST 04, 2017

Applies to:

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

Symptoms

On :  12.2.6 version, Catalog items

Not able to associate NIR to ICC  
We are getting error when trying to associate NIR to an ICC. Whenever the NIR link is clicked the page goes in error and gives message

ERROR
-----------------------
You have encountered an unexpected error.Please contact your system administrator for assistance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Setup workbench > Try to associate NIR to ICC > See Nullpointer exception.

2. This ICC was created using API EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups

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