In one of my applications, when I click Refresh Theme (Application x > Shared Components > Themes > Create / Edit Theme) I receive an error...
1 error has occurred
- ORA-20001: Unable to subscribe to page template. ORA-00001: unique constraint (APEX_050000.WWV_PAGE_TMPL_DP_UK1) violated
Looking at APEX_050000.WWV_FLOW_PAGE_TMPL_DISP_POINTS, the constraint reference is...
CONSTRAINT "WWV_PAGE_TMPL_DP_UK1" UNIQUE ("PAGE_TEMPLATE_ID", "PLACEHOLDER")
I have multiple other applications, all configured the same way in which the refresh theme works just fine.
Any thoughts on the cause, or more importantly how to fix?