My Oracle Support Banner

Form Region Fails in APEX 19.1 with ORA-00903: invalid table name When Called From a Report - Form (Doc ID 2548097.1)

Last updated on AUGUST 22, 2019

Applies to:

Oracle Application Express (APEX) - Version 19.1 to 19.1
Information in this document applies to any platform.

Symptoms

Had problems in one of the workspaces creating a basic application report-form fails at the form with the error in 19.1.

When running the Interactive Report, and clicking on the edit link for the row, the following error occurs:


ORA-00903: invalid table name
Contact your application administrator. Details about this incident are available via debug id "871123378".

Technical Info (only visible for developers)
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: 8814241805142961900
component.name: Initialize form Team Data
association_type: REGION
region_id: 8814236908480961890
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 "TEAMID","TEAM_NAME","PROJECTID"
from ((
select /*+ qb_name(apex$inner) */d."TEAMID",d."TEAM_NAME",d."PROJECTID" from (


) d

 )) i

) i where 1=1


 and "TEAMID"=:apex$f1



The workaround, instead of selecting from the list of table I selected SQL Query option and provide the query:

select Empno, ename from emp;

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.