Forum Stats

  • 3,757,257 Users
  • 2,251,216 Discussions
  • 7,869,781 Comments

Discussions

what is replacing oracle reports

Wayne_Duke
Wayne_Duke Member Posts: 26 Blue Ribbon
edited Apr 13, 2021 11:24AM in Forms

With Oracle reports being de-supported, what is replacing it and is it covered by the existing license cost of forms and reports?

Tagged:

Best Answer

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,840 Employee
    edited Apr 13, 2021 2:17PM Accepted 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.

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,570 Red Diamond

    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
    Wayne_Duke Member Posts: 26 Blue Ribbon

    @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
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,840 Employee
    edited Apr 13, 2021 2:17PM Accepted 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.

  • Wayne_Duke
    Wayne_Duke Member Posts: 26 Blue Ribbon

    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

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,840 Employee

    @Wayne_Duke

    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.