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 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On : 12.1.3.31.8 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
AND expnd.ps_node_id IS NOT NULL AND NOT EXISTS (SELECT NULL FROM
cz_ps_nodes WHERE ps_node_id = expnd.ps_node_id AND deleted_flag= 0))
) order by name


ERROR
-----------------------
 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(T4CTTIoer.java:439)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)




STEPS
-----------------------
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

Cause

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
Symptoms
Cause
Solution
References


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.