WebADI Excel Upload Of Item Category Changes Error: The specified category assignment is not found for this item [Video] (Doc ID 1524288.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Oracle Item Master - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 26-Aug-2014***

Symptoms

ACTUAL BEHAVIOR
Upload via Excel (EGOIJAVA) to update the purchasing category fails.

EXPECTED BEHAVIOR
Valid categories should upload via Excel (EGOIJAVA) without error.

WHAT IS WORKING
1) Most category changes work. The only category set that does not work is Discount Pricing attached to the purchasing Functional Area.
2) Can update WITHOUT error for the same category via Item form, or PIM form.

ERROR
INV_CAT_ASSGN_NOT_FOUND
The specified category assignment is not found for this item.

-also-

ORA-01002: fetch out of sequence

DEBUG LOG

You may see message like the following in the debug log including INV_CAT_ASSGN_NOT_FOUND and "ORA-01002: fetch out of sequence".

 
STEPS

(Video Link)

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