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", "CODNUMCODFAL," CERRAR_LINK "," CODNUMCODFAL, "CERRAR_LINK", "CODNUMCODF", "CERRAR_LINK", "CODNUMCODF", "CERRAR_LINK", "CODNUMCODF", "CERRARLINK", "CODNUMCODFAL", "CERRARLINK," CPU_CODALF "," UNI_CODALF "," FLGPRV "," CMGCODNUM "," 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?
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", "CODNUMCODFAL," CERRAR_LINK "," CODNUMCODFAL, "CERRAR_LINK", "CODNUMCODF", "CERRAR_LINK", "CODNUMCODF", "CERRAR_LINK", "CODNUMCODF", "CERRARLINK", "CODNUMCODFAL", "CERRARLINK," CPU_CODALF "," UNI_CODALF "," FLGPRV "," CMGCODNUM "," 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?