Model Report Fails with ORA-6512: at APPS.CZ_DEVELOPER_UTILS_PVT
(Doc ID 1980992.1)
Last updated on FEBRUARY 03, 2019
Oracle Configurator Developer - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10] Information in this document applies to any platform.
On : 22.214.171.124.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!