Issue
When creating a quick report based on query designer and that query does not have parameters, it is not possible to create the quick report.
The error message is :
11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"CALLSTACK","level":"DEBUG","type":"","text":"__anonymous_block at line 2 QUICK_REPORT_HANDLING_SVC.DO_CHECK_QUERY_DESIGNER_SQL_ACTION at line 939 QUICK_REPORT_HANDLING_SVC.CHECK_QUERY_DESIGNER_SQL_ACTION___ at line 4543 QUICK_REPORT_API.CHECK_QUERY_DESIGNER_SQL__ at line 2807 ERROR_SYS.APPL_GENERAL at line 339 ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 129 ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 123 "}
11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"195915004","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calling method: Server_Log_API.Log_Server_Error_"}
11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calling method: Server_Log_API.Log"}
11:29:11 ERROR - INVALID_QUERY_DESIGNER - (Server Application Error): Sql Query is invalid belongs to this Query Designer
Database error occurred. Contact administrator.
undefined
11:29:11 ERROR - Command error: (INVALID_QUERY_DESIGNER) - Sql Query is invalid belongs to this Query Designer, details: "[{\"code\":20105,\"message\":\"ORA-20105: QuickReport.INVALID_QUERY_DESIGNER: Sql Query is invalid belongs to this Query Designer\"}]" undefined
Resolution
Query designer was introduced in 23R1 and this issue has been identified as a bug and fixed in 23R1SU2.