Skip to Main Content

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!

ORA-00918: column ambiguously defined when creating Drill down report

GadoApr 27 2020 — edited Apr 27 2020

Hello,

I am using APEX 19.2 on ATP.

I create a Master Detail - Drill Down page. The Master page and the create page rns fine.

Only when I click on the Edit pencil I get this error "ORA-00918: column ambiguously defined"

I created a test app on the sample OEHR data and created the same page with no issues. This happens when I create this in my application on my schema.

The full error stack from debug

ElapsedExecutionMessageLevel
0.050460.00007
CGI: PATH_INFO = /f?p=120:7:24333383476357::NO:RP:P7_SALES_ORDER_ID:%5C1%5C&cs=3cihstbyJoA-JZvMaF6CKqSEq4dif178sYII_lWCoAOu92D-zFcVhiT4Vm8yNz7gIBKpvcd4wC3W5qD08IEpZZQ
9
0.050530.00040
GET https://******.oraclecloudapps.com/ords REMOTE_ADDR=***** REMOTE_USER=ORDS_PUBLIC_USER APEX_LISTENER_VERSION=19.4.3.r1061746 REFERER=https://*******.oraclecloudapps.com/ords/f?p=120:6:24333383476357::::: HTTP_COOKIE=
9
0.050930.00002
SID=11778 USER=ORDS_PUBLIC_USER INSTANCE=1
9
0.050950.00040
Hiding error additional_info, as it contains ORA error message: ORA-00918: column ambiguously defined
1
0.051350.00003
Error: ORA-00918: column ambiguously defined
1
0.051370.00027
- additional_info: ORA-00918: column ambiguously defined
4
0.051640.00002
- display_location: ON_ERROR_PAGE
4
0.051660.00002
- association_type: REGION
4
0.051680.00002
- region_id: 36075833243910122
4
0.051700.00002
- is_internal_error: false
4
0.051710.00002
- is_common_runtime_error: false
4
0.051730.00003
- ora_sqlcode: -918
4
0.051760.00003
- ora_sqlerrm: ORA-00918: column ambiguously defined ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 2151 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 1791 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 885 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 592 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 578 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2057 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2031 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 864 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 907 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 1269 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2478 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 1737 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 2118 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 2193 ORA-06512: at "APEX_190200.WWV_FLOW~
4
0.051790.00002
- error_backtrace: ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 578 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 2151 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 1791 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 885 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 592 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 578 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2057 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2031 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 864 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 907 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 206 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 1269 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2478 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 1737 ORA-06512: at "APEX_190200.WWV_FLOW_FORM_REGION", line 2118 ORA-06512: at "APEX_190200.WWV_FLO~
4
0.051800.00002
- error_statement: select i.*  from ( select "SALES_ORDER_ID","SHIFT_ID","BRANCH_ID","SALES_DATE","TOTAL","CUSTOMER_ID",(lead("SALES_ORDER_ID",1)over(order by SALES_ORDER_ID)) "NEXT_1",(lag("SALES_ORDER_ID",1)over(order by SALES_ORDER_ID)) "PREV_1",(row_number()over(order by SALES_ORDER_ID)) "ROWN",(count(*)over()) "TOTAL" from (( select /*+ qb_name(apex$inner) */d."SALES_ORDER_ID",d."SHIFT_ID",d."BRANCH_ID",d."SALES_DATE",d."TOTAL",d."CUSTOMER_ID" from ( select x.* from "SALES_ORDER" x   ) d   )) i   ) i where 1=1     and "SALES_ORDER_ID"=:apex$f1
4
0.05182-
- component: APEX_APPLICATION_PAGE_PROCESS Initialize form Form on SALES_ORDER (36086265635910129)
4

Thank you,

Gado

This post has been answered by Keyser on Apr 27 2020
Jump to Answer
Comments
Post Details
Added on Apr 27 2020
4 comments
843 views