Skip to Main Content
Forums

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!

Unique constraint violated while verifying theme

Scott WesleyMar 19 2018 — edited Aug 23 2018

I've gone to verify the theme to one of our larger applications, and I've received the same error @"Alli Pierre Yotti" and @"sect55" received in this archived post:

ORA-00001: unique constraint (APEX_050100.WWV_FLOW_PAGE_PLUG_IDX2) violated

pastedImage_2.png

This particular application has some original templates, which come up as "Not subscribed"

pastedImage_3.png

I've successfully verified other applications that also have their own templates, so I'm not convinced this is the cause, particularly since the error relates to a unique index on WWV_FLOW_PAGE_PLUG_TEMPLATES(FLOW_ID, PAGE_PLUG_TEMPLATE_NAME, THEME_ID).

I'm not sure what I can do to mitigate this?

This is on APEX 5.1.3

Scott
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2018
Added on Mar 19 2018
#apex, #apex-discussions
11 comments
1,256 views