Prash's Blog

Error Import Apex Script : ORA-00001: unique constraint (APEX_040100.WWV_FLOW_ICON_BAR_PK) violated June 13, 2012

Filed under: Uncategorized — prazjain @ 2:50 pm
Tags: ,

This is the error I got when I tried to import my Oracle Apex script from DEV environment to QA environment.

Error GET_BLOCK Error.
ORA-20001: Execution of the statement was unsuccessful. ORA-20001: Error creating navigation bar item id="246130155962013305" ORA-00001: unique constraint (APEX_040100.WWV_FLOW_ICON_BAR_PK) violated <pre>begin wwv_flow_api.create_icon_bar_item( p_id => 246130155962013305 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_icon_sequence=> 200, p_icon_image => '', p_icon_subtext=> 'Logout', p_icon_target=> '&LOGOUT_URL.', p_icon_image_alt=> 'Log

To resolve this error, open the script file in any editor like notepad, notepad++ etc.

Search for “wwv_flow_api.g_id_offset” and it might be set to 0, so change it to 1.

If this is still not resolved change it to 2. (Keep incrementing by 1 until it this error is resolved and you are able to import your apex script).