Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Zafar IqbalJun 12 2019 — edited Jun 12 2019

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.
This post has been answered by Franck N on Jun 12 2019
Jump to Answer

Comments

Post Details

Added on Jun 12 2019
#apex-discussions
10 comments
870 views