I am getting
ORA-00001: unique constraint (APEX_040200.WWV_FLOW_PAGE_PLUG_IDX2) violated
when trying to add theme 24 to application 777 on oursite.com
I read Joel Kallman's response to this Discussion
and it got the thought to go see if I had any templates in my app that have theme 24.
Well looking in Shared Components did not show any BUT then I queried APEX_APPLICATION_TEMPLATES
where THEME_NUMBER = 24
and APPLICATION_ID = 777
my results showed the same region template as Joel mentioned in his reply to the above post
I had the "DIV Region with ID" region template in the APEX view.
I'm not sure how you ended up in this situation, but you had one template associated with theme ID 24 with a name of 'DIV Region with ID'. This was in the absence of theme 24 being installed in your application.
I'll review the data integrity rules how this was even permitted in the first place. But for your specific application, I deleted the one errant row and you can now install Theme 24 into that application.
How do I delete this from the base tables?