Error in an interactive report based on web source module

[miguel-montejano]

The plugin seems to be not working when the interactive reports are based on the web source module.

The error occurs in the IR_TO_XLSX package, line 1005. You are parsing the query to be exported, with an instruction "dbms_sql.parse (v_cur, v_sql, dbms_sql.native);"

When it is a web module, build a query similar to this:

select "NUMACTAGD", "DESID", "FIT_NOMID", "AMB_NOMID", "FLGTANDESID", "CLOSE", "PRINT", "CEREMONY", "CODNUM", "PRINT_COLECTIVA_LABEL", "IMPRIMIR_COLINDUAL", "IMPRIMIR_COLINDUAL" PRINT_INDIVIDUAL_ICON "," CEREMONIA_LINK "," CLOSE_LINK "from (select i. * From (select" NUMACTAGD "," DESID "," FIT_NOMID "," AMB_NOMID "," FLGTANDESID "," CERRAR "," PRINT CEREMONY ", , "CODNUM", "IMPRIMIR_COLECTIVA_LABEL", "IMPRIMIR_COLECTIVA_ICON", "IMPRIMIR_INDIVIDUAL_LABEL", "IMPRIMIR_INDIVIDUAL_ICON", "CEREMONIA_LINK", "CERRAR_LINK", "CERRAR_LINK", "CODNUM_CODFAL_," CERRAR_LINK "," CODNUM_CODFAL_, "CERRAR_LINK", "CODNUMCODF", ​​"CERRAR_LINK", "CODNUMCODF", ​​"CERRAR_LINK", "CODNUMCODF", ​​"CERRAR_LINK", "CODNUMCODFAL_", "CERRAR_LINK_," CPU_CODALF "," UNI_CODALF "," FLGPRV "," CMG_CODNUM "," DATCMG "," USUCMG "," DATINS "," USUINS "," FLGTAN "," DATTAN "," USUTAN "," PMEACT "," LIBACTMAN " , "OBSGEN", "NUMFOLIOS", "NUMREGALU", "NUMFOLINILIB", "NUMTOMOLIB", "DATINI", "DATFIN", "CAN DELETE", "INSERTED_ BY", "F_INSERCION", "MODIFIED_POR", "F_MODIFICACION" ACTDEFIND "," CEN_NOMID "," PLA_NOMID "," UNI_NOMUNI "," DEFINESITALUACTIMP "," ACTAGRADOSINCANDIDATOS "," CPU_NOMID "," TIENECEREMONIA "
from ((select / * + qb_name (apex $ inner) * / d. "NUMACTAGD", d. "DESID", d. "FIT_NOMID", d. "AMB_NOMID", d. "FLGTANDESID", d. "CLOSE" , d. "PRINT", d. "CEREMONY", d. "CODNUM", d. "IMPRIMIR_COLECTIVA_LABEL", d. "PRINT_COLECTIVA_ICON", d. "PRINT_INDIVIDUAL_LABEL", d. "IMPRIMIR_INDIVIDUAL_LABEL." . "CERRAR_LINK", d. "CODNUM_ALF", d. "FIT_CODALF", d. "PLA_CODALF", d. "CEN_CODNUM", d. "CEN_CODNUM_ALF", d. "CPU_CODALF", d. "UNI_CODALF", d. "UNI_CODALF", d. FLGPRV ", d." CMG_CODNUM ", d." DATCMG ", d." USUCMG ", d." DATINS ", d." USUINS ", d." FLGTAN ", d." DATTAN ", d." USUTAN " , d. "PMEACT", d. "LIBACTMAN", d. "OBSGEN", d. "NUMFOLIOS", d. "NUMREGALU", d. "NUMFOLINILIB", d. "NUMTOMOLIB", d. "DATINI", d . "DATFIN", d. "CAN DELETE", d. "INSERTED_POR", d. "F_INSERTION", d. "MODIFIED_POR", d. "F_MODIFICACION", d. "ACTDEFIND", d. "CEN_NOMID", d. " PLA_NOMID ", d." UNI_NOMUNI ", d." DEFINESITALUACTIMP ", d." ACTAGRADOSINCANDIDATOS ", d." CPU_NOMID ", d." TIENECEREMONIA "from (select x. * From" APEX $ WEB_SOURCE_DATA "x
) d
)) i
) i where 1 = 1
) i

And when parsing it, an error occurs indicating that the column name does not exist.

Do you know if the plugin works with IR based web source module?