My Oracle Support Banner

After Running Refresh Concurrent Program, Option Class has all Options Removed in Configurator Developer due to Option Class contains an option class that has no effective children (Doc ID 2518541.1)

Last updated on APRIL 04, 2022

Applies to:

Oracle Configurator - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, BOM Populate and Refresh

When attempting to refresh several models with the latest Bill of Material updates, it's observed that several option classes across multiple models have all options deleted in Oracle Configurator Developer. In the Refresh a Single Configuration concurrent program log file, the following error occurs.

12345678:CZ_IM_XFR.XFR_ITEM_TYPE.123456:ORA-00001: unique constraint (CZ.CZ_ITEM_TYPES_U1) violated
12345678:CZ_IM_MAIN.MAIN_ITEM_TYPE.123456:Key resolved inserts: 1, actual inserts: 0
12345678:CZ_IMP_PS_NODE.MAIN_INTL_TEXT:NOCHANGE .123456:No Change count: Key resolution - 12345, Actual-0
12345678:IMP_IM_XFR.XFR_PS_NODE.123456:<Model Name>(1234 5678901234) with database ID 1234567 imported successfully.
12345678:CZ_IMP_SINGLE.IMPORTSINGLEBILL.NOCHILD_OC.11276:Model 'WIDGETNOTREAL' contains an option class that has no effective children, option class 'OC-SOMEOPTIONCLASS'.

The issue can be reproduced at will with the following steps:
1. Oracle Configurator Administrator responsibility
2. Concurrent programs
3. Submit Refresh a Single Configuration for one of the impacted models
4. Observe the above messages displayed in the log flie
5. Oracle Configurator Developer responsibility
6. Navigate to the impacted model in the repository, observe in the structure the option class has no children.

The issue has the following business impact:
Due to this issue, users cannot publish these models to production, meaning multiple orders are currently on hold until the latest bill of material configuratoin can be published. This is delaying the ordering process leading to a revenue impact.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.