INTRODUCTION: The Mini Calendar Plug-In and the Sticky Notes Plug-In are two handy and adaptable Oracle APEX plug-ins that will be introduced in this article. These plug-ins provide intuitive and…
Read MoreINTRODUCTION: The well-liked web development framework Oracle Application Express (APEX), you may create database-driven web apps fast and effectively. One of the features of APEX is the ability to upload…
Read MoreINTRODUCTION : The Invoke API process in Oracle Apex allows developers to make API calls from within an Oracle Apex application to retrieve data or perform actions on external systems. This…
Read MoreINTRODUCTION : This feature lets users change an employee’s salary or job, or order a new laptop for them, after getting the approval of an appropriate individual. It highlights the key features of the Oracle APEX Approvals components.A strong workflow engine add on for Oracle APEX applications is called Flows for APEX. The Apex its able to create the process stages, and the Flows for APEX application to track the progress of your active processes. The approvals component allows Oracle APEX to create tasks for user approval. One place to manage approval tasks in the apex application. WHY WE NEED TO DO / CAUSES : A user should able to analyze the workflow of an approval request which was sent by the senior official. So that, the user can able to identify and solve the issue on required basis. There are several reasons why an Oracle Apex approval procedure could not perform as planned. Some frequent causes are as follows: 1) Missing input parameters 2) Incorrect Procedure 3) Incorrect Branch Logic 4) Incorrect Validations 5) Database Connection Issue 6) Concurrency Issue. HOW DO WE SOLVE : Create a new procedure in the database that will handle the approval process. This procedure should take any necessary…
Read More