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!

Error when deleting Global Page

Jacob MadsenJun 8 2018 — edited Jul 3 2018

I recently tried creating a Global Page 0. The page does not contain any items or regions. But when I try to delete it, I get an Internal Error, and the following is recorded in APEX_DEBUG_MESSAGES. What's wrong here? APEX version is 18.1. Thanks in advance.

CGI: PATH_INFO = /wwv_flow.accept

"POST http://testkirkeportal.brandsoft.dk/pls/apex

REMOTE_ADDR=10.248.135.126

REMOTE_USER=APEX_PUBLIC_USER

REFERER=http://testkirkeportal.brandsoft.dk/pls/apex/f?p=4000:21:13470102635513::NO:21::

"

"SID=22

USER=APEX_PUBLIC_USER

INSTANCE=1

"

"Error: ORA-02091: transaction rolled back

ORA-02292: integrity constraint (APEX_180100.WWV_FLOW_USER_INT_PAGE_FK) violated - child record found"

"- additional_info: ORA-02091: transaction rolled back

ORA-02292: integrity constraint (APEX_180100.WWV_FLOW_USER_INT_PAGE_FK) violated - child record found"

- display_location: ON_ERROR_PAGE

- is_internal_error: false

- ora_sqlcode: -2091

"- ora_sqlerrm: ORA-02091: transaction rolled back

ORA-02292: integrity constraint (APEX_180100.WWV_FLOW_USER_INT_PAGE_FK) violated - child record found"

"- error_backtrace: ORA-06512: at "APEX_180100.WWV_FLOW_SESSION_STATE", line 1862

ORA-06512: at "APEX_180100.WWV_FLOW_DYNAMIC_EXEC", line 2031

ORA-06512: at "APEX_180100.WWV_FLOW_DYNAMIC_EXEC", line 2363

ORA-06512: at "APEX_180100.WWV_FLOW_PROCESS_NATIVE", line 92

ORA-06512: at "APEX_180100.WWV_FLOW_PROCESS_NATIVE", line 1152

ORA-06512: at "APEX_180100.WWV_FLOW_PLUGIN", line 2451

ORA-06512: at "APEX_180100.WWV_FLOW_PROCESS", line 201

"

"- error_statement: begin for c1 in (select id from wwv_flow_steps where flow_id = :fb_flow_id and id > 0 order by id) loop

   :fb_flow_page_id := c1.id;

   exit;

end loop;

end;"

- component: APEX_APPLICATION_PAGE_PROCESS reset current page (162029321720000696)

This post has been answered by fac586 on Jun 8 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2018
Added on Jun 8 2018
13 comments
1,000 views