Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Theme Refresh Issue During APEX Upgrade from 23.2 to 24.2

KalmanVFeb 3 2025

Hello,

I'am trying to upgrade APEX from 23.2 to 24.2.

System Description:

  • There is a Master Application that contains the Master Theme settings.
  • The Master Theme is subscribed to the Standard Universal Theme 42, with some additional customized components and Theme Roller settings.
  • Several Subscribed Applications reference the Master Theme.

Background:

The Master App’s Theme Refresh operation completed successfully, upgrading the theme version from 23.2 to 24.2.

Issue: Problems with Subscribed App Updates

Steps:

The "Verify" operation throws a Subscription Status error: “Current theme does not match master theme.”

  • (Presumably because the Master Theme has already been upgraded to 24.2.)
    At this point, the APEX_APPLICATION_THEMES view still contains the correct REFERENCE_ID pointing to the Master Theme

After this, the Theme Refresh operation does not work correctly.

  • The original "Subscribed to Application Theme: Master App - Universal Theme" setting changes to "Subscribed to Standard Theme: Universal Theme".
  • In the APEX_APPLICATION_THEMES view, the REFERENCE_ID has changed and no longer points to the Master Theme, but to the Standard Universal Theme, just like the Master Theme itself.

As a result, the Subscribed Apps lose their reference to the Master Theme. In some places, numeric values ​​appeared in the template references instead of their names.

The affected Subscribed Apps fail to run, displaying the following error message:

Page cannot be displayed

APEX_ERROR_CODE: APEX.UNHANDLED_ERROR
ORA_SQLERRM: ORA-01403: no data found
Location: APEX_240200.WWV_FLOW_THEME

Question:

What could be causing this issue? Why do the Subscribed Applications lose their reference to the Master Theme after executing the Theme Refresh?
What can be the solution?

Best regards,
Kalman Viktor

Comments
Post Details
Added on Feb 3 2025
6 comments
159 views