My Oracle Support Banner

Oracle Configurator - Setting Up Real Item Substitution (Doc ID 2133616.1)

Last updated on JUNE 09, 2022

Applies to:

Oracle Configurator Developer - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Oracle Configurator - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Starting with Configurator build and 12.2.6, new Real Item Substitution (RIS) functionality has been added. This document covers the necessary setup to add this feature to a new or existing Bill of Materials (BOM). This new feature is intended to address a situation which is prone to high maintenance and resource usage that eventually leads to performance problems. This can occur when a customer has mutex Option Classes with thousands of options underneath where these options typically gets selected via Property Based Compatibility rules based on the associated user defined attributes and does not drive any selections. From a maintenance perspective, frequent changes to these option classes require frequent model refreshes and publications. From resource usage perspective, the same structure is duplicated in the CZ (Configurator) sub-schema on the database side, consuming more memory to cache this data for runtime sessions.

With this Enhancement Request, a single placeholder item needs to be created under such option classes, and with some additional minimal setup one can avoid requirement of refreshing the BOM (Bill of Materials) and republishing the model when there are changes to these option classes. Since this data is not part of current model structure during a runtime session, it does not get cached saving memory consumption which will help to improve system scalability.

This functionality is intended to assist with models that have the following features:

Following is an example of a Bill of Material setup for a model which may benefit from RIS.

In this example, the choice of the FABRIC, FASHION, and THREAD_COUNT could be set up so these options would trigger rules to select the correct RIS_Eligible_OC.


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.