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

Last updated on MARCH 08, 2017

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

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