Copy a page 130 to 135. Page 135 does not exist.
No tabs, no page alias, no breadcrumbs.
Error returned with page not created.
ORA-20001: Error during execution of wwv_flow_copy_page: WWV_FLOW_WORKSHEET_CONDITIONS >> ORA-20001: Error during execution of wwv_flow_copy_page: WWV_FLOW_WORKSHEET_CONDITIONS >> ORA-00001: unique constraint (APEX_030200.WWV_FLOW_WORKSHEET_COND_PK) violated
How do I troubleshoot this?
I believe it is a problem with our QA installation of Apex. It appears that constraint (foreign key?) is missing. wwv_flow_worksheet_cond_fk is missing and appears to have an effect on pages with Interactive Reports.
See this link: Interactive Reports Page Copy Error
I want to get the environment rebuilt (Fresh Apex install, import workspaces from DEV) but that means users, developers and DBAs need to be involved and a formal plan, communication, and change requests need to be made to ensure it is done with minimal disruption.
Edited by: slavanaway on Mar 20, 2012 6:52 AM