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!

APEX 26.1 User Interface Attributes Error ORA-01422

Julio OrregoJun 3 2026

I've upgraded a development server from apex 24.2 to apex 26.1 , and I have 2 applications insed of it. Appid 156 and appid 105 , but for appid 105 in Shared Components > User Interface > User Interface Attributes Im always getting the same error:

ORA-01422: exact fetch returns more than requested number of rows

I don't understand what's going on, because the appid 156 works fine. If I install a new app from the gallery, works fine, but for that specific App it's impossible to use the User Interface Attributes.

I've tried to change the compatibility mode to 26.1 from Application Definition, Import the app as a new app, refresh the universal template theme, update the application from Utilities > Upgrade application , and nothing seems to work.

Both apps were in APEX 24.2

Has this happened to anyone else?

Thanks in advance for any help,

Julio O.

Comments
Post Details
Added on Jun 3 2026
0 comments
41 views