4 Replies Latest reply: Oct 23, 2012 10:15 AM by Hilary-Oracle RSS

    Cannot install Sample Master Detail (Packaged Application)

    RickyBurke
      When trying to install the Sample Master Detail packaged application
      on the new APEX.Oracle.com (running Application Express 4.2.0.00.22),
      I'm getting an error.

      After selecting it from the Packaged Applications page, and clicking the "Install Application" button
      on the Application Builder/Packaged Applications/Sample Master Detail/Install screen,
      I get the following:

      --------
      Execution of the statement was unsuccessful. ORA-00001: unique constraint (APEX_040200.WWV_FLOW_MESSAGES_IDX1) violated

      declare
      h varchar2(32767) := null;

      begin

      h:=h||'Help';

      wwv_flow_api.create_message (
      p_id=>2456294651379654494 + wwv_flow_api.g_id_offset,
      p_flow_id=>wwv_flow.g_flow_id,
      p_name=>'HELP',
      p_message_language=>'en',
      p_message_text=>h);
      null;

      end;

      ORA-00001: unique constraint (APEX_040200.WWV_FLOW_MESSAGES_IDX1) violated
      --------

      I tried in a workspace that had some existing applications, and a colleague tried
      in a new workspace that had just been allocated by APEX.Oracle.com.

      I was able to successfully install the Sample Data Loading application after trying to install
      the Sample Master Detail packaged application.

      Anyone else having this issue?


      Thanks in advance!

      -Ricky Burke
      972-560-3759 Work