403 Forbidden messages when using modified theme

Joe1

Our tech service recently upgraded our on-prem dev environment to db v19c, APEX 22.1.0, and latest ORDS upgrade.

I notice now that previous apps that used custom saved themes, don't render properly, and when I look at Chrome's console, I see error messages stating as follows, and when page re-renders, a lot of the formatting is lost.

GET http://xxxx.xxx.local/pls/apex/r/psp_datahub/115/files/theme/42/v66/7895038512355450.css net::ERR_ABORTED 403 (Forbidden).

I created a new app to see if the app was bad. Using standard Vita them with no customizations, the console shows similar messages for a standard region icon such as this:

GET http://xxxx.xxx.local/pls/apex/r/psp_datahub/115/files/static/v4/icons/app-icon-512.png 403 (Forbidden).

When I use theme roller to change navigation color for example, then save, then when page reloads, much of the formatting is lost. This is same behavior as previous apps.

Our tech team has created multiple SR's with Oracle, and they keep getting passed around with no solution. Our tech team doesn't really know APEX application per se, they are just following installation guidelines. I'm not technical enough to know all they have done on the back-end.

See examples below.

When using standard Vita, 403 Forbidden on icon png file.

Now change a color and save as Vita(copy_2).

Now when page reloads, formatting all lost, and now an additional 403 on the .css file.

jariola

Not sure, but somehow it might be that you need Configuring Static File Support

https://docs.oracle.com/en/database/oracle/application-express/22.1/htmig/configuring-ords.html#GUID-A578DB67-EE01-4CAB-8043-95F26A6E46F0

Maybe you ask about that from Oracle Support before run script mentioned in documentation.

That might solve also your another problem

https://community.oracle.com/tech/developers/discussion/4500290/quick-apex-test-app-you-are-not-authorised-to-access-this-resource-on-the-server#latest

Also see ORDS documentation how repair/validate installation.

https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.2/ordig/installing-and-configuring-oracle-rest-data-services.html#GUID-9E8A2051-6DFC-48E2-A8D5-DA8A9EF5D324

You should ask also about that from Oracle Support before running anything

Joe1

@jariola you were correct. That was the issue. It took this long for them to get this run, but ultimately this was the solution. Thank you again!