We upgraded our Oracle Apex Application from version 19.2 to 24.2.
When i try to restore the subscription to the Oracle UT i see that the count for my templates is doubled. This proceduces errors when i then try to unsubscribe the updated theme. (This is a workaround for a known bug in APEX 24.2:
Theme Refresh Issue During APEX Upgrade from 23.2 to 24.2 - Oracle Forums
)
Below screenshots from my steps:
The error behind the Error unsubscribing theme is the following:
Error Stack: ORA-00001: unique constraint (APEX_240200.WWV_FLOW_TEMPLATE_IDX2) violated
Am i doing something wrong or is this a bug?