Upgrading an Apex 20.1 and have a classic report with a source of “PL/SQL Function Bodyg Return Sql Query”.
I get one error: "Compilation error - ORA-00900: invalid SQL statement"
And Quality Assurance message: “Compilation error - ORA-00900: invalid SQL statement”
The page appears to run fine, is there something I should change to resolve the above?
return RPT_Utils.Generate_Report(:P3_REPORT_FORMAT,
:P3_FY,
:P3_QTR_NO,
:P3_BUS_AREA,
:p3_Product_Line,
:p3_Project_Family,
:p3_One_Liner_Group,
:P3_report_columns,
:P1_EMP_NO,
:P3_THRESHOLD_LEVEL,
:P3_OL_STATUS,
:P3_USE_FAVORITES);