I am preparing to upgrade and modernize and an existing Oracle apex application originally developed in Oracle apex 4.2 and and database 11. Our goal is the upgrade to the latest version 21.2 and deploy to Oracle autonomous cloud. The original application is create as a single application with around 300 plus pages. The employer wants the application as different modules and module access based on user roles. Meaning and a user with Admin role can access all modules and a Business Analyst role can access only 1 or 2 modules. I understand I can control page access and menu access using authorization schemes .
What would be the best approach on creating modules ?. should I create different applications and move the pages and consider each application as modules ? or can I implement the module concept while keeping all pages in same application. Requesting experts recommendation on this . thank you so much
George