Hello Experts,
After upgrade from 20.1 to 21.1 while tried to refresh Theme on my application. So for that I followed these steps:
Login to workspace
Navigate to the application
Open "Shared Components"
At the top of the page, it may give you an option to refresh theme - says "there is a new version of Universal Theme available"
Click Refresh Theme
Gives error: ORA-00001: unique constraint (APEX_210100.WWV_FLOW_PAGE_PLUG_IDX2) violated.
Searching on the net, I found some articles, which treated the same subject , like this post:
https://community.oracle.com/tech/developers/discussion/3951684/unable-to-refresh-theme-unique-constraint-apex-050000-wwv-flow-page-plug-idx2-violated
But doing this Update command:
update APEX_210100.wwv_flow_page_plug_templates
set reference_id =
(select id
from APEX_210100.wwv_flow_page_plug_templates
where flow_id = 200
and page_plug_template_name = 'Standard'
)
where flow_id = 210
and page_plug_template_name = 'Standard'
and reference_id is null
I got 0 row(s) updated.
So how can i fixe this issue ?
Thank you for help.