Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc
$0.32
OCPU per hour
Oracle Fusion Cloud ERP
Score 8.0 out of 10
N/A
Oracle Cloud Enterprise Resource Planning (ERP) is a core suite of Oracle Cloud software-as-a-service (SaaS) applications. Oracle Expense Management and Oracle Risk Management are part of this solution. Other apps include Financials, Revenue Management, Accounting Hub, PPM, and Procurement. The single cloud platform offers built-in industry standards and modern best practices. ERP software is the backbone of many organizations and Oracle aims to offer a modern, connected…
Oracle APEX and Oracle Visual Builder are both low-code development platforms within the Oracle ecosystem, but they serve different purposes. Oracle APEX is more suited for the people who are familiar with SQL, PLSQL. It provides rapid application development features based on …
It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.
Oracle Fusion Cloud is best suited if a customer moves from Oracle eBusiness Suite (on-prem) to a SaaS offering. The transition is comparatively manageable to implement. However, the customer must understand that we cannot have too many customizations in the SaaS model, so many heavily customized on-prem applications would need to be incorporated in the Cloud by using Cloud tools like Oracle Integration Cloud, Oracle Cloud Infrastructure Autonomous Database, Oracle APEX provisioned on OCI, etc.
By utilizing technology, we were able to maintain our efficiency ratio which gives us a huge advantage over our competitors.
It offers us sets of dependable apps to increase productivity, enhance control
and lower operating costs.
Oracle has been an amazing, reliable, and powerful analytical tool that has streamlined budgeting financials planning, and data infrastructure across the entire enterprise.
For complex APEX applications you need to be a pro expert in PL/SQL
Debugging in APEX can be complicated if there is a logical error. Syntax errors will end up shown as ORA errors
Lack of designer interface. Even though you are designing a form you need to do it by means of APEX interface using a series of steps, no UI for design
Oracle specific not applicable for other databases
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.
This is the product we have chosen to standardize the ERP system throughout our European subsidiaries. We had been operating blindly with each location using their own ERP system. We relied on them to accurately report to us in the US. But now that we are beginning to roll out ERP Cloud, we have much better visibility into day-to-day operations.
Because it's very easy to develop, fast, secure, has a lot of features. It's like a prototyping tool such as figma, but it can be used as a real product. Dynamic action, plugin, rest api, minimize a lot of coding, a lot of templates, PWA, really bring Oracle APEX functionality to be able to solve most common internal users pain points.
I like the program, but it is only as good as the initial implementation and the user support required after go-live. I don't think pre-implementation training needs to be too much of a focus, but once you're live, there needs to be an intense focus on working with users and providing high-quality resources to help.
Yes availability was initially an issue but like I said it has evolved and stabilized a lot better these days. We get hardly 1 or two unplanned outages in a year. That too during off peak hours and would get resolved before we even realize it. If Oracle could resolve even the sporadic unplanned outages then it would be awesome and highly reliable for customers.
The performance of the application is good. Incase of any issues, one has to work with Oracle support. We enabled auditing on certain tables and experienced performance issues. We immediately raised with Oracle support and they helped in improving the performance.One has to proactively work with oracle support to identify the issues.
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.
Support is always providing step by step details to resolve any issue we encounter. If the issue is currently not a functionality or feature of the application they are supportive in offering guidance on submitting an enhancement request. Currently there is an enhancement that will be rolled out by Oracle that was designed for our organization.
The inperson trainings from Oracle University are effective. The trainers have vast experience and teached thousands of students. In person training will make people sit in a class and do the exercises. One can also learn from other students, who come with different background, industry etc. In person training will be an immersive experience and helps learn more in a short period of time.
We bought online training subscription from Oracle University. The subscription allowed our team to learn the nuts and bolts of the application.The subscription model helps access to all the modules as opposed to buying training for one module. We also leveraged guided learning subscription from Oracle. Guided learning is a state of the art learning application from Oracle. It resides within the application and guides the users on each and every step. This is learning by doing and is very effective. Once you buy guided learning, oracle keeps updating it with the release of new functionality in the quarterly upgrades.
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.
Try to use the system as true to generic form as possible and cut over quickly. Parallel implementation is not recommended. If the numbers are accurate and materially similar to prior period - cut over. A small accounting adjustment is much better than millions in project overruns or dual system maintenance.
Oracle APEX and Oracle Visual Builder are both low-code development platforms within the Oracle ecosystem, but they serve different purposes. Oracle APEX is more suited for the people who are familiar with SQL, PLSQL. It provides rapid application development features based on data residing in Oracle database. It's a low code platform and best suited for web based applications/extensions based on Oracle DB that may use REST APIs and other web services. It also provides mobile application support. Oracle Visual Builder is best suited for web applications based on Oracle Cloud services. It utilizes javascript based drag-drop UI builder. It's very deeply integrated with Oracle Fusion Cloud platform.
Oracle is more reliable than other immature products in the market. Oracle has multifold resources available in the market for each and every technology. Oracle support has made available many solutions to the existing problems and their fixes. The database is of high performance and quality as compared to the other products in the market. Oracle solutions for finance and supply chain are compared to none.
Orcle ERP Cloud transformed and stabilized in this past 2 years since it was implemented. We have past the auditor reviews and 24 month end closes and 8 quarter closes and 2 FY closes. Above all we do have SEC reporting with all this data. Having said that our ERP subscription is a worthy investment and highly reliable source of information for our organization's needs
It has increased our development output over Forms greatly. For instance, when starting at my current company, I was able to replace our aging ASP Intranet site within 4 months when our IT manager had budgeted over a year for the task.
We've been able to standardize under one technology, incorporating previously unsupportable disparate systems under one roof.
It's free with an Oracle Database so the only investment was our time, something we now have more of thanks to Application Express.
