0.05046 | 0.00007 | CGI: PATH_INFO = /f?p=120:7:24333383476357::NO:RP:P7_SALES_ORDER_ID:%5C1%5C&cs=3cihstbyJoA-JZvMaF6CKqSEq4dif178sYII_lWCoAOu92D-zFcVhiT4Vm8yNz7gIBKpvcd4wC3W5qD08IEpZZQ | 9 |
0.05053 | 0.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.05093 | 0.00002 | SID=11778 USER=ORDS_PUBLIC_USER INSTANCE=1 | 9 |
0.05095 | 0.00040 | Hiding error additional_info, as it contains ORA error message: ORA-00918: column ambiguously defined | 1 |
0.05135 | 0.00003 | Error: ORA-00918: column ambiguously defined | 1 |
0.05137 | 0.00027 | - additional_info: ORA-00918: column ambiguously defined | 4 |
0.05164 | 0.00002 | - display_location: ON_ERROR_PAGE | 4 |
0.05166 | 0.00002 | - association_type: REGION | 4 |
0.05168 | 0.00002 | - region_id: 36075833243910122 | 4 |
0.05170 | 0.00002 | - is_internal_error: false | 4 |
0.05171 | 0.00002 | - is_common_runtime_error: false | 4 |
0.05173 | 0.00003 | - ora_sqlcode: -918 | 4 |
0.05176 | 0.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.05179 | 0.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.05180 | 0.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 |