Skip to Main Content
Forums

Cloud Platform

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!

404 Not Found error in ORDS using Tomcat server

M TajuddinSep 12 2020

Hi,

I am getting a weird error with my apex application (Application Express 19.2.0.00.18) running on the Oracle Cloud using Tomcat server. ORDS_PUBLIC_USER, ORDS_METADATA, APEX_PUBLIC_USER, APEX_REST_PUBLIC_USER  accounts are unlocked and open. I have restarted the tomcat server a few times but static images and other files (js, css) are not displaying. The image url is - https://mysystem.com/ords/prk_prod/r/220/files/static/v8/logo_icaap.png and it throws the following error, see the screenshot.

  • The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured

Any help or suggestion is highly appreciated. Thanks in advance.

Comments

Billy Verreynne

Oracle APEX with Oracle ORDS are good alternatives, and are no-cost options too.
ORDS (Java web app) can be run in Apache Tomcat - an Open Source minimal/no-cost option.

Wayne_Duke

@billy-verreynne thanks for this, I have been looking at a number of products that can I could use, but what I seem to remember being at an Oracle event/webinar where there where it was mentioned that as we are paying a forms and report license, we could use some form of Oracle BI publisher without additional cost

Michael Ferrante-Oracle
Answer

To be very clear, Oracle Reports is NOT planned to be desupported at this time. It has merely been deprecated, which is not at all the same as desupported. This simply means that no new features are planned for it going forward unless changes are required to make it compatible with whatever new stack contains it.
The recommended migration is Analytics Publisher (previously BI Publisher). If you already have proper licensing to use Oracle Reports and are using a Supported version, your license includes entitlements to use it (Analytics Publisher), at no additional cost. Refer to the FMW Licensing Guide for a more official reference. Also, contact your Account Representative or Oracle Sales for the latest information.
https://docs.oracle.com/en/middleware/fusion-middleware/fmwlc/
Regarding the use of APEX as a "reporting" tool, I would recommend caution. APEX is not a reporting technology. Although it does have some basic reporting functionality, it may not meet the needs of more complex reporting requirements that can be easily and more appropriately handled by actual "reporting" technologies like Analytics Publisher and others.

Marked as Answer by Wayne_Duke · Apr 14 2021
1 person found this helpful
Wayne_Duke

Hi @michael-ferrante-oracle thanks for the clarification and the information on Analytics Publisher, that was what I remembered you saying, but when we tried asking our accounts team they didn't seem aware of it so the link will be very useful.
With regards to the current state of Oracle reports, I understand we are at the terminal release and reviewing the statement of direction of reports its says "Oracle is not planning any functional enhancements for Oracle Reports in its terminal release, or any subsequent releases, if any." The "if any" intimates that following versions of Oracle forms may not have reports included or am I misunderstanding the statement?

regards
Wayne

@wayne-duke1
I had written a three paragraph lengthy answer to your question then decided it might not be a good idea to share my entire opinion here. Feel free to contact me privately and maybe I can help explain.
In short, a formal commitment has not yet been made regarding the inclusion of Reports in the next FMW release.

1 - 5

Post Details

Added on Sep 12 2020
#general-questions
0 comments
106 views