10 Replies Latest reply on Jun 12, 2019 11:29 AM by Franck N

    Form Region Fails in APEX 19.1 with ORA-00903: invalid table name When Called From a Report

    Zafar Iqbal

      Dear all,

       

      Oracle Apex 19.1 (https://apex.oracle.com/ )

       

      I have done following Steps

       

      1. Generated Application
      2. Created interactive report with form
      3. Made some changes in table
      4. Deleted the application
      5. Re-generated application
      6. re-created interactive report with form

       

      When I click on Edit button then I get following error.

       

      • is_internal_error: false
      • ora_sqlcode: -903
      • ora_sqlerrm: ORA-00903: invalid table name ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2176 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 788 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC", line 1628 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2049 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2218 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS_NATIVE", line 1241 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2473
      • component.type: APEX_APPLICATION_PAGE_PROCESS
      • component.id: 18001009220752326738
      • component.name: Initialize form Animal Info
      • association_type: REGION
      • region_id: 18000989121449326707
      • error_backtrace:
        ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2176 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC_LOCAL", line 788 ORA-06512: at "APEX_190100.WWV_FLOW_EXEC", line 1628 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2049 ORA-06512: at "APEX_190100.WWV_FLOW_FORM_REGION", line 2218 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS_NATIVE", line 1241 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2473 ORA-06512: at "APEX_190100.WWV_FLOW_PROCESS", line 203 
      • error_statement:
        select i.* from ( select "ANIMAL_ID","CATEGORY","PRIMARY_COLOR","MIX","ADULT_SIZE","NAME","SEX","STATUS","HOUSETRAINED","SP_NE","CHIP_NO","EST_DOB","EST_AGE","DATE_CREATED","DATE_MODIFIED","DOM_BREED_ID","ANIMAL_PIC" from (( select /*+ qb_name(apex$inner) */d."ANIMAL_ID",d."CATEGORY",d."PRIMARY_COLOR",d."MIX",d."ADULT_SIZE",d."NAME",d."SEX",d."STATUS",d."HOUSETRAINED",d."SP_NE",d."CHIP_NO",d."EST_DOB",d."EST_AGE",d."DATE_CREATED",d."DATE_MODIFIED",d."DOM_BREED_ID",d."ANIMAL_PIC" from (   ) d  )) i  ) i where 1=1   and "ANIMAL_ID"=:apex$f1

       

      Please guide what and where I am missing something.