iSetup Extracts Of Inventory Default Category Sets Is Failing (Doc ID 797156.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Item Master - Version: 12.0.0 to 12.1.3 - Release: 12 to 12.1
Oracle iSetup - Version: 12.0.0 to 12.1.3   [Release: 12 to 12.1]
Information in this document applies to any platform.

Symptoms

On release 12:

When creating a selection set for Discrete Mfg. and Distribution and selecting the Default Category Sets choice under Inventory, iSetup R12 Extractor (AZR12EXTRACTOR) will fail with the below error in the request log.

Error
oracle.apps.fnd.framework.OARowValException: An error occurred in API 'DefaultCategorySetsAM'
...
oracle.apps.fnd.framework.OAException: Application: INV, Message Name: INV_SETUP_NO_DATA_FOUND. Tokens: ATTR_VALUE = CategorySetId = '-1';

Steps
1. Go to iSetup R12 Extractor
2. Create a selection set for Discrete Mfg. and Distribution
3. Select the Default Category Sets choice under Inventory
4. Run the extractor

Business impact
Due to this issue, users cannot migrate setup data to new environments.

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