My Oracle Support Banner

Model Report Fails with ORA-6512: at APPS.CZ_DEVELOPER_UTILS_PVT (Doc ID 1980992.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Configurator Developer - Version to [Release 11.5.10]
Information in this document applies to any platform.


On : version, Model Report

After clicking on the Model Report button in Oracle Configurator Developer, an exception is being generated. This is occurring for 6 models. It is not certain when the model report worked in the past, as it is only used infrequently. It is likely that some rule might be referring to logically deleted or completely deleted node(s) but going though each rule is not possible, as there are 1000s of rules.

The following SQL (from Bug 16079998) returned two dozen rows:

SELECT rule_id, name, disabled_flag, rule_folder_id FROM cz_rules WHERE
rule_id IN ( SELECT distinct(rule_id) FROM cz_rules rul WHERE
rul.devl_project_id = 1908420
AND rul.rule_type = 200 AND
rul.deleted_flag = 0 AND EXISTS (SELECT NULL FROM cz_expression_nodes expnd
WHERE expnd.rule_id = rul.rule_id AND expnd.deleted_flag = 0
cz_ps_nodes WHERE ps_node_id = expnd.ps_node_id AND deleted_flag= 0))
) order by name

 java.sql.SQLException: ORA-1403: no data found
ORA-6512: at "APPS.CZ_DEVELOPER_UTILS_PVT", line 517
ORA-6512: at "APPS.CZ_DEVELOPER_UTILS_PVT", line 561
ORA-6512: at line 1
 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4C8Oall.processError(

The issue can be reproduced at will with the following steps:
The steps for generating the model report in the Oracle Configurator Developer are below:

1) Oracle Configurator Responsibility,
2) Oracle Configurator Developer,
3) Configurator Developer,
4) You are in the Repository, so search for the model,
5) Once you find the model, edit the model by clicking on the pencil icon,
6) Click on the Model Report button in the upper right hand corner,
7) Select the Include buttons for all options,
8) An exception is generated


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.