Duplicate templates when subscribing to Oracle UT

User_X0VG0

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?

Gianni Ceresa

Hi,

Welcome to the Oracle Analytics community and forum.

You seem to have an APEX issue but you are now in the Oracle Analytics forum. APEX is not an Oracle Analytics product.

You should visit https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex and post your problem there, it's a category dedicated to APEX in the Developer Community forum.