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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00001: unique constraint (APEX_190100.WWV_FLOW_STEPS_PK) violated when running wizards on existi

Mint-InnitJun 4 2019 — edited Jun 4 2019

Hi, does anyone know if there are any known issues in apex 19.1 (we've reproduced this on apex.oracle.com) with certain cases for running wizards on existing pages?

A colleague has reported the following scenario:

  1. create a report/form page pair with the usual wizard  (e.g. report = P1, form = P2)
  2. Then run the wizard again to create a second report/form pair, but this time with the new report on the original form page (P2) and the new form on a new page (P3).

He uses this for maintaining specific data sets, it's not a pattern I've had to use myself I'll admit. This was working up to Apex 18.2

In this scenario,  apex 19.1 throws

ORA-20001: Unable to create query and update page. ORA-20001: Error creating page name="test" id="5" ORA-00001: unique constraint (APEX_190100.WWV_FLOW_STEPS_PK) violated

Just wondering if there were any known bugs around running wizards twice on a page. Note that 'simple' actions such as using a wizard to add a report to an existing page still work fine. We've not seen anything on this forum, or on the known issues/release notes for 19.1, or in oracle support relating to this.

Cheers.

Comments

Post Details

Added on Jun 4 2019
0 comments
1,167 views