Oracle APEX vs. Oracle Fusion Cloud Enterprise Performance Management

Based on our organization's experience, Oracle APEX is a versatile and powerful tool, but its suitability depends on specific business needs, technical requirements, and the nature of the application being developed. Scenarios where Oracle APEX fits well: Business Process Automation/Workflows Reporting and Dashboards for Data Analytics AI based systems such as Select AI Chatbots for data insights based on LLMs Native-like Mobile Applications using PWA feature of APEX Scenarios where Oracle APEX may be less appropriate: Very Complex and highly interactive applications Use cases based on a non-oracle Database

It is well suited in a geographically distributed environment where you have various key participants in multiple time zones providing input and necessary explanations on performance and measured success It is less appropriate where you have a single office environment with a single finance department working together. It is also less suited when the GL is NOT an Oracle product and the interface between the GL and the reporting software needs to be implemented with utmost care and handling.

Incentivized

• Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
• Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
• Comes with cross browser and mobile compatibility out of the box.
• Easy to incorporate other web technologies.
• Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.

Incentivized

• Account Reconciliation CLoud Services provides tight integration with Oracle R12 and 11i . Provides drillback capability. It is flexible and provides rich functionality to users.
• We have implemented ARCS on cloud and migrated planning and budgeting from On premise to PBCS and EPBCS. Functionality is onpar with onpremise. Provides regular updates monthly
• We don't need to upgrades every year and saved a lot on Hardware.

Incentivized

• Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
• Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.

Incentivized

• The limitation of constrained out of the box dimensions that requires ripping the initial implementation to add the new dimensions is a major drawback.
• Smartview interface is cumbersome for many.
• The only financial adapter is available for integration for other modules we have to go with file-based uploads which is cumbersome and not real-time.
• It is very costly in terms of licensing unlike other Oracle products.

Incentivized

I felt very comfortable using Oracle Application Express from the start. I designed my data model and quickly developed the basic CRUD pages for master tables. Then I designed the main functionality and was able to test and deploy it in a couple of days work. I will probably share the app with other members of the team and continue adding some features in the short term.

Incentivized

We have a pretty good userbase who are at the high level who gained value from this tool. Discontinuing this tool is prone to impact their day to day operations. Also the data in this tool cannot alter the source, which maintains the integrity of this tool. Smartview is a cool addition that gained lot of traction as well.

Incentivized

its easy to use as a developer and applications designed using apex are easy and intuitive to use as an end user. Even non-coders can build good applications, the more code you can write the more you can enhance the application but you can get up and running quickly with almost no technical know how.

Incentivized

It produces consolidated multi currency reports faster and more accurately whilst adding additional pivotal functionality. The Smartview reporting is a key for us and a flagstone of the application

Incentivized

EPM has been so far available all the time

Incentivized

The product performance is so far very good

Incentivized

Very active and knowledgeable community support includes quick and helpful responses from the Oracle employees on the product development team. I've never had to raise an official support request - everything is dealt with via forums and user groups - or via direct emails. The supposrt commuinty is one of the great things about Apex.

Incentivized

Support from our implementation partner is a 10/10, but support from Oracle is awful. Case in point: recently over a 2-day period, there were a series of intermittent outages. Oracle actually asked US for the outage time-stamps. I would have thought that, since we were paying them, they should probably be able to tell us!

Incentivized

Using it on the cloud is really simple, the entire process of configuring and provisioning an Oracle Database takes only a few minutes (less than 10) and then Oracle APEX is already deployed on the database, so you just have to start using it. I would strongly recommend using APEX on Oracle Cloud Free Tier.

Incentivized

I suggest doubling the time to implement from the initial quote you get from the Sales team. That's always been the case for me for multiple EPMs now. The out-of-the-box functionality of Oracle Planning and Budgeting Cloud is pretty robust so I appreciate that and it really helped us get the ball rolling quickly.

Incentivized

If you are expert in SQL and PLSQL and use Oracle Database, then the best choice is Oracle Application Express. The functionality is already complete and very easy to use, so it's useless to find another tool if you are using Oracle. You don't use Oracle APEX only if: (1) you are using other database than Oracle, and (2) your application load is unpredictable.

Incentivized

Oracle Planning and Budgeting Cloud fared very well against Adaptive, Anaplan, and Host Analytics. We ultimately decided on Oracle due to its reputation and strength of existing customers. We are happy with our decision.

Incentivized

The product is scalable

Incentivized

• In the mid-size organization, we had a BI tool that had a significant license cost involved. With Oracle back-end we were able to switch to APEX and move all reporting at literally zero cost.
• For Oracle PL/SQL users the learning curve is very quick and easy, there are ready templates that you can start with and eventually create complex reports.
• You can track authorization and authentication on data editing and usage. High performance as it is native oracle sql codes.
• Centralized data capturing, makes your datawarehouse writable for lookup tables or reference tables.

Incentivized

• Significantly reduced the amount of money we spent for the maintenance of in-house hardware.
• We now need less employees to manage the configurations of Oracle EPM Cloud.
• There have been many time savings as a whole to apply to more productive causes.

Incentivized