We have encountered an issue with template component usages after upgrading to APEX 26.1.1.
Starting point is an APEX 24.1 instance. In our only workspace we have well over 50 applications whose theme is subscribed to the theme of one “master”-application (basically a library app). The theme in this “master”-application is subscribed to the APEX repository theme (# 42). The only change is the addition of a company-specificy Style. Also, One of these applications has 2 template components defined in the “templates” section of the Shared Components.
After the upgrade (but before theme upgrade) everything seems to work just fine. I then refreshed the theme in our “master”-application to 26.1. After this step there should be 79 templates in the theme, but there are actually 81! Somehow refreshing the theme in the “master”-application added the two Template Components from"detail"-application. A bit strange perhaps? (Note I did NOT publish the refreshed theme to the “detail”-applciations)
But now for the real issue; the pages in the “detail”-application that use these template components cannot be opened in the builder anymore and cannot be run either.
The builder will simply leave everything empty and an error is shown in the top right:
And runtime an ORA-01403 is shown.
Strangely enough I can create a page as a copy of this page and that one will open just fine in the builder. It will even run, but show no data as all the settings of the template components have been cleared….
Has anyone encountered this issue as well?