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!

APEX5, page save error: ORA-00001: unique constraint

PaavoMay 23 2015 — edited Jul 3 2015

Anyone seen this for page save?

ORA-00001: unique constraint (APEX_050000.WWV_FLOW_PAGE_PLUGS_PK) violated

ORA-06512: at "APEX_050000.WWV_FLOW_PAGE_PLUGS_DEV_IOT", line 3

ORA-04088: error during execution of trigger 'APEX_050000.WWV_FLOW_PAGE_PLUGS_DEV_I

I couldn't reproduce this error, but got it when

1.) created new region to old compatibility mode 4.2 application

pastedImage_8.png

pastedImage_9.png and not yet Re-subscribed: pastedImage_10.png

2.) changed type to Classic Report region and entered simple but valid sql

3.) tried to save the page, and got this error, which prevented saving

pastedImage_2.png

The error went? away after I tried in other workspaces in the same instance, consuming the same schema and made new application with fresh classic report region.

Then creation of new page to this old application with classic report region didn't complain.

Also creation of new classic report region to old applications old page didn't complain anymore.

Environment

pastedImage_5.png

pastedImage_6.png

pastedImage_4.png

The MONITOR didn't show this application error at all.

**Rgrds Paavo
**

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2015
Added on May 23 2015
6 comments
1,476 views