Viscosity
logo-black
  • Data
    • Database Services
      • Performance Assessment
      • Proactive Healthcheck
      • Database Migration & Consolidation
      • Performance Tuning
    • Microsoft Services
      • Microsoft Azure Services
      • Microsoft SQL Server Services
      • Microsoft Gold Azure Partner
    • Oracle Services
      • Oracle Database 19c
      • RAC
      • GoldenGate
      • Data Guard
      • Oracle & SQL Database
    • Viscosity Remote Services
  • Apps
    • App Dev Services
    • Oracle APEX
    • Viscosity AMP
    • Viscosity-ai
    • Shane-ai
  • Cloud
    • Cloud Services
    • Hybrid Cloud
    • Viscosity Edge Cloud
    • Virtualization & Cloud Expertise
    • Microsoft Azure Services
  • Infrastructure
    • Infrastructure Services
    • Exadata
      • Exadata Resale & Services
    • Oracle Database Appliance
      • Oracle Database Appliance Resale & Services
      • ODA Health Checks
    • Zero Data Loss Recovery Appliance
    • VMware to KVM Migration
  • Events
    • Upcoming Events
    • Virtual Training
    • 2025 Past Events
    • 2024 Past Events
    • 2023 Past Events
    • 2022 Past Events
  • About
    • About Us
    • News
    • Blogs
    • Publications
    • Contact
Hit enter to search or ESC to close
ENGAGE WITH US

Application Development , APEX , FOEX , plugins

FOEX Acquisition

By Emanuel Cifuentes
August 29, 2022

If you didn't know already, APEX is a fantastic platform for both end users and developers. We should know. We have been using APEX for years developing all kinds of solutions for every type of industry out there: healthcare, financial, energy, customer service... we've done it all! Most of the time, the functionality that APEX provides out-of-the-box is more than enough to meet the needs. Sometimes the available building blocks don't fit, and we need to build our own. That is what APEX plug-ins are for. It gives us the ability to extend the functionality, always on top of the APEX foundation, with custom-built JavaScript and PL/SQL. This allows you to connect to public APIs, modify the user interface, adapt existing libraries, and much more. 
 
When it comes to manipulating the front-end (user interface, calculations, and processes happening inside the browser), you may need good JavaScript skills. If you do possess such skill, you have unlimited possibilities when it comes to building custom components. If you don't, there is no need to panic. There are loads of plug-ins, built by excellent people in the APEX community, free to download and use. Have a look at the collection in apex.world (https://apex.world/ords/f?p=100:700).  
 
Now, if you're looking for a more complete and reliable solution, there are also commercial plug-ins built by great companies such as FOEX. They give excellent support and have a fantastic team of brilliant minds regularly coming out with new stuff to solve problems you haven't even thought of. 
 
Viscosity has been a FOEX Gold Partner (https://viscosityna.com/partners) for a while, and we have seen firsthand how skilled they are and how committed they can be to providing value to their customers. They are so good that Oracle recently acquired them (https://www.oracle.com/corporate/acquisitions/foex/). This means more FOEX for years to come.  

 

The best thing about FOEX is that they are kind enough to share their knowledge by creating a collection of Open Source plug-ins for APEX. These plug-ins have been released under the MIT license, so not only are they free of charge, but you also get the source code (https://github.com/foex-open-source). You can find them individually on GitHub and the apex.world website. You can also head out to their website and download a sample application containing all the plug-in definitions and examples of using them.   

https://www.foex.at/fos/ 

 

Download 
You can download the full suite of plug-ins by simply downloading our demo apg 
copying the plug-ins using the APEX builder from the demo app to the apps you 
Alternatively you can find all our open source plug-ins on GitHub for individual do, 
you can raise plug-in issues, create pull requests for changes/enhancements

Notice the minimum requirements (APEX 19.2 at the time of writing) and modern browsers such as Firefox, Chrome, and MS Edge. 

 

Fos 
Free, Open Source, Professional 
APEX Plug-ins for Ever 
FOS Plug-ins - Download 
A set of 
Minimum Requirements: APEX 19.2 
Browser Support: Modern Browsers e.g. Firefox, Chrome, and Edge Chromium 
All plug-ins are available on GitHub to individually download, but we recommenc 
the button below to download this application and install it. It is the reference gu 
plug-ins and you can simply copy & subscribe the plug-ins to other applications 
workspace.

 

To get started, head out to the download site (https://fos.world/ords/f?p=FOSDL:HOME) and get your sample app. This app has everything you need bundled, meaning it includes all the plug-in definitions. If you need to use the plug-in on different apps, you can copy the plug-ins or subscribe to them using the standard APEX functionality. Import the app and run it. 

 

Drag and Drop 
FOS_Demo_app_v21.2.O.sql 
File Type: 
C) 
c, 
O 
Import 
Application, Page or Component Export 
Plug-in 
Theme Export 
IJser Interface Defaults 
Team Development Feedback 
REST Source Catalog 
O

 

Install Application 
Supporting Objects 
This app'cation installer will guide you through the process of creating your database objects and seed data. 
Application: 
Parsing Schema: 
102718 - FOS Plug-ins V21.ZO 
WKSP_EMOFUENTESC

 

When you run the app, you get the following home page. There are some links to the support site and other helpful supporting websites. To look at the plug-ins in action, click the "Getting Started" link. 

Fos 
Free, Open Source, Professional 
APEX Plug-ins for Ever 
A set of supported Open Source APEX plug-ins to boost your productivity an 
Getting Started 
Plug-ins

 

Some plug-ins are relatively simple. They have small things that make your life easier one bit at a time. Have you ever had to clear a date field? You have to focus on it and hit delete several times. There must be a better way, you think. There absolutely is; check it out:  

animated gif of the date clear plug-in

What about drag and drop? There's a plugin for that. 

animated gif of the drag and drop tool-tip

Tooltips? You got it. 

2022-08-12_15-56-20 (1)

 

Ok. I know what you're thinking. That's cool but not very useful. First of all, excuse me, but it's quite useful. If you have to manually implement this every time you want it, you will spend quite some time on these simple things, and it distracts you from the important stuff. The collection has more complex plug-ins, such as an Interactive Grid process. It's a common use case to process the rows the user has selected and/or filtered out. You can easily achieve that with one of the FOEX plug-ins.  

Animated gif of the selected records processing in the interactive grid

 

Animated gif of the filtered records processing in the interactive grid

 

Pretty cool, huh? If you liked this, you're going to love the commercial plug-ins. Head to their website (https://www.foex.at/commercial-apex-plug-ins/) and look at their work. We are partners for a reason, and I promise you will not be disappointed.   

All posts
About Author
Emanuel Cifuentes

Emanuel started professional software development at age 16, right out of high school. He was able to work on all kinds of software for banking, which gave him a good understanding of privacy and security. He then moved on to a startup environment to develop web and mobile applications. The startup had a lot to do with geolocation, tracking, and was really focused on usability. A few years ago, he started consulting for Viscosity North America in subjects related to Oracle, specifically the Oracle Database and Oracle APEX. He has been involved in many projects in the food, oil and gas, and healthcare industries, to name a few.

You might also like
Creating an APEX App Using Data From an API – Step 4
Creating an APEX App Using Data From an API – Step 4
August 29, 2022
Creating an APEX App Using Data From an API – Step 3
Creating an APEX App Using Data From an API – Step 3
August 29, 2022
Creating an APEX App Using Data from an API – Step 2
Creating an APEX App Using Data from an API – Step 2
August 29, 2022
SUBMIT YOUR COMMENT
logo for footer

Viscosity's core expertise includes:

Data Transformation, Emerging Technology, High Availability & Scalability Solutions, Cloud Migrations, Performance Tuning, Data Integrations, Machine Learning, APEX Development, and Custom Application Development.


Solutions

Resources

Partnerships

Careers

Clients

 

Contact
Email: sales@viscosityna.com

Telephone:
(469) 444-1380

Address:
3016 Communications Pkwy Suite 200, Plano, TX 75093

Copyright 2025. All Rights Reserved by Viscosity North America.