Hi Everyone,
During the APEX version upgrade process, I encountered a serious issue when migrating from APEX 23.2 to APEX 24.2. The problem appeared after performing the "Switch Theme" operation in APEX 24.2 to update the Universal Theme 42 from version 23.2 to 24.2.
Various template attributes set for components on the pages were reset to their default values. For example, settings in Regions and Data Items such as "Start New Row", "Column Span", and several others were reverted. Such settings are page-specific, not template-specific.
For applications with hundreds of pages, manually restoring these settings requires significant development effort.
Is there a simpler solution for this? I doubt I am the only one facing this issue.
I was considering comparing the APEX_APPLICATION_PAGE_REGIONS and APEX_APPLICATION_PAGE_ITEMS views between the APEX_230200 and APEX_240200 schemas. Would it be possible to create a script that restores the original layout of affected components in the APEX_240200 schema?
Is there any built-in solution in APEX for this, or outside of it?
Can someone help with this so I don’t have to start from scratch?
This issue poses a serious obstacle to version upgrades, as manual patches must be repeated with each new APEX version.
Best regards,
Kalman Viktor