--- title: Invoking Workflows within Workflows – APEX 24.2 description: Discover powerful new features in APEX 24.2, including invoking workflows within workflows, enhancing business process flexibility and efficiency. image: https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2010.png --- [![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk) [![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk) - Services - Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - Managed Services - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services) - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services) - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services) - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services) - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services) - Licensing and SAM - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services) - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam) - Application Services - [Application Development](https://www.dsp.co.uk/software-development) - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation) - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex) - [Application Extensions](https://www.dsp.co.uk/software-customisation) - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution) - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services) - [Development Training](https://www.dsp.co.uk/oracle-apex-training) - Data Science - [AI Strategy](https://www.dsp.co.uk/ai-strategy) - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai) - [Agentic AI](https://www.dsp.co.uk/agentic-ai) - [Data Management for AI](https://www.dsp.co.uk/data-management) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning) - Cloud Migration and Management - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment) - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation) - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration) - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services) - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management) - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure) - Integration and APIs - [API Management](https://www.dsp.co.uk/api-development-services) - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services) - Disaster Recovery and Security - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions) - [Security Compliance](https://www.dsp.co.uk/data-security) - [Cloud Security](https://www.dsp.co.uk/cloud-security)   ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg) #### Getting to know us - [About us](https://www.dsp.co.uk/about) - [What we do](https://www.dsp.co.uk/what-we-do) - [Leadership](https://www.dsp.co.uk/dsp-product-leads) - [Careers](https://www.dsp.co.uk/careers) - Technologies - Oracle Cloud Infrastructure - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services) - [IaaS](https://www.dsp.co.uk/iaas) - [PaaS](https://www.dsp.co.uk/paas-security) - Oracle Database - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting) - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services) - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - Oracle Engineered Systems - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy) - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance) - Oracle Applications - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services) - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services) - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services) - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services) - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services) - Microsoft - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - Google - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner) - Multicloud and Database Hyperscaler - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner) - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning) - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws) - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud) - Open Source Database - [PostgreSQL](https://www.dsp.co.uk/postgresql-services) - [MySQL](https://www.dsp.co.uk/mysql-services) - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql) #### Managed Services - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services) - [MySQL](https://www.dsp.co.uk/mysql-support) #### Application Services - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - [Microsoft](https://www.dsp.co.uk/microsoft-partnership) - [ISV Services](https://www.dsp.co.uk/isv-support-and-services) #### Cloud Services - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database) - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud) #### Data Science - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services) - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services) - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations) #### Technology Solutions - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner) - [Data Security](https://www.dsp.co.uk/data-security) - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery) - Industries - [Finance](https://www.dsp.co.uk/finance) - [Healthcare](https://www.dsp.co.uk/healthcare-it-services) - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport) - [Higher Education](https://www.dsp.co.uk/higher-education) - [Public Sector](https://www.dsp.co.uk/public-sector) - [Manufacturing](https://www.dsp.co.uk/manufacturing) - [Retail](https://www.dsp.co.uk/retail) - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services) ### Recent case study: #### Oracle EBS Cloud Deployment Consolidating and Migrating assets into Oracle Cloud Infrastructure. [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)   #### Most Visited Pages - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing) - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/) - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration) - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services) - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### - - [SQL Server Support](https://www.dsp.co.uk/sql-server-support) - [Oracle Support](https://www.dsp.co.uk/oracle-support) - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy) - [New Application Development](https://www.dsp.co.uk/oracle-apex-services) - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop) - Resources - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download) - [ISG](https://www.dsp.co.uk/isg-oracle-report) - [Blogs](https://www.dsp.co.uk/blogs) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - [Events](https://www.dsp.co.uk/events) - [Webinars](https://www.dsp.co.uk/webinars) - [Insights](https://www.dsp.co.uk/insights) - [Technical Resources](https://www.dsp.co.uk/technical-resources) ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.   [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305) #### Resources - [Blogs](https://www.dsp.co.uk/blogs) - [Webinars](https://www.dsp.co.uk/webinars) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - About - [About DSP](https://www.dsp.co.uk/about) - [What We Do](https://www.dsp.co.uk/what-we-do) - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board) - [Careers](https://www.dsp.co.uk/careers) - [Project Harar](https://www.dsp.co.uk/project-harar) - [Customer Area](https://www.dsp.co.uk/contact-us) - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/) - [Customer Resources](https://www.dsp.co.uk/welcome) - [Contact us](https://www.dsp.co.uk/contact-us) # Invoking Workflows within Workflows – APEX 24.2 [ Colin Archer ](https://content.dsp.co.uk/author/colin-archer) 27-Feb-2025 09:18:28 Invoking Workflows within Workflows – APEX 24.2 9:57 ### Contents [14-May-2024 12:29:53 Using APEX Workflows ](https://content.dsp.co.uk/using-apex-workflows) [09-Aug-2024 09:14:32 APEX Approvals and Workflow Enhancements ](https://content.dsp.co.uk/apex-approvals-and-workflow-enhancements) [07-Dec-2023 16:36:16 APEX Workflows ](https://content.dsp.co.uk/apex-workflows) The workflow component was first introduced in [APEX](https://www.dsp.co.uk/oracle-apex-services) 23.2 and can be integrated into your applications to model and run your business processes. I first reviewed the component in a blog I wrote last year, which you can read [here](https://content.dsp.co.uk/apex/using-apex-workflows). ## New Features The latest release of APEX 24.2 in January sees some further enhancements, with the following new features highlighted. - Invoke Workflow Activity - Copy Workflow Definitions - Resume Workflows at any activity - Improved Human Task and Workflow pages The new feature that stands out to me (and the focus of this blog) is the ability to invoke a workflow from inside another workflow. However, before I delve into this new feature, let's have a quick look at the other improvements mentioned. ### Copy Workflow Definitions It is now possible to copy a workflow from another application. So, if you want to create a new workflow similar to an existing one, you can copy and then amend it as needed (so long as you are copying it from another application). The most significant benefit this improvement gives is the ability to create template workflows in your master/template applications. These can be set up to follow your agreed standards and include any common features or business processes. They can then be used as templates for each new workflow you add to your applications. When you copy a workflow into your application, any invoked workflows or shared components, such as tasks or email templates used by the workflow, are also copied. ### Resume Workflow Workflow administrators can now suspend a workflow, amend the values of variables and restart at a chosen activity. This enables considerable flexibility and control when dealing with workflow processing failures or human error, as an administrator can correct any issues and restart a workflow and the appropriate activity rather than having to restart it from the beginning. ### Improvements to Human Task and Workflow pages The layout of human tasks and workflow pages has been modernised and improved using template components, enabling simpler customisation. ## Invoking Workflows The introduction of the new Invoke Workflow activity significantly opens up the possibilities and flexibility of workflows. You now have the option to break down large and complex workflows into smaller/simpler workflows, which can pass data between them. For example, if the workflow has multiple sub-processes, these can be separated into individual workflows and configured to run sequentially, concurrently, or a combination of both. Another benefit of this improvement is reusability. Common processes can be created as separate workflows and invoked as required by your other workflows as often as needed. ### Version 1 To test out this new feature, I created a simple application and accompanying workflow for the approval of employee absence requests, with the initial solution using a single workflow. The requirements I set were as follows: - A simple Interactive report and modal form page to view and enter absence requests. - Absence entries consist of a date and the absence type, Vacation, Bank Holiday, or TOIL (Time off in Lieu). - Bank holidays do not require review and can be automatically approved. - Vacation and TOIL entries must be approved or rejected by the employee's manager. The first step was to create the human task for the approval of Vacation and TOIL requests. This was a basic task that takes the approver username in as an input and returns the task outcome of either APPROVED or REJECTED. Next, I used the workflow builder to create the business process as follows. [![Invoking Workflows within Workflows – APEX 24.2 ](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%201.png?width=1017&height=439&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%201.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%201.png) I created a simple workflow that contained one human process to review Vacation / TOIL requests and two switches, one to check the absence type and the other the result of the approval human task. Regardless of the route taken, an execute code activity will update the absence record from pending to approved or rejected. To simplify my testing, I hardcoded the approver to be a test APEX user account named SMITHJ instead of using the employee's manager. This was so I didn't need to log in as multiple different users to approve the workflows. The APEX application consisted of an employee absence summary interactive report with links to a modal form to submit a new request and initiate the workflow. [![Invoking Workflows within Workflows – APEX 24.2 ](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%202.png?width=1002&height=618&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%202.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%202.png) When the create button is pressed, the entry is validated and processed using an automated row processing (DML) process. A workflow process then creates the new absence approval workflow, passing in the ID of the absence detail record. Lastly, I used the page creation wizard to add the unified task list and workflow console pages and also added an interactive report to detail the absence history. ### Testing Version 1 To test the application, I created three absence requests (one of each type) and checked the status of each in the Workflow Console. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%203.png?width=556&height=375&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%203.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%203.png) As expected, two workflows were pending approval by SMITHJ, and the third has been auto-approved as it was a bank holiday. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%204.png?width=552&height=555&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%204.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%204.png) I logged into the application as SMITHJ and used the Unified Task List page to review the two pending requests, setting one to approved and the other to rejected. ![Invoking Workflows within Workflows – APEX 24.2 Image 5](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%205.png?width=838&height=324&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%205.png) Once all three workflows had been processed, I checked the absence history to confirm they were all approved/requested as expected. [![Invoking Workflows within Workflows – APEX 24.2 ](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%206.png?width=852&height=315&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%206.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%206.png) ### Version 2 To test the new Invoke Workflow activity, I amended the business process as follows: - For a TOIL absence request to be approved, the employee must have sufficient unused TOIL days accrued. - A request to increase the number of TOIL days an employee has must be approved by the TOIL Administrator. - If there are insufficient TOIL days to cover an absence request, the absence workflow will automatically invoke the TOIL workflow and wait for the response before continuing. - If the increase in TOIL days request is approved, the absence request workflow can continue otherwise, it must be automatically rejected. The first step in updating my business process was to create a second workflow and corresponding human task to review the request to increase an employee's accrued TOIL days. ![Invoking Workflows within Workflows – APEX 24.2 Image 7](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%207.png?width=978&height=323&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%207.png) As this workflow is to be called by the Absence Request workflow, I need to pass back the TOIL increase decision. To do this, I added an OUT directional parameter named TOIL_STATUS, which will be set to the value INCREASED if the increase in days is approved. This parameter value is sent back to the parent workflow, where it can be used by a switch activity to determine what to do next. ![Invoking Workflows within Workflows – APEX 24.2 Image 8](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%208.png?width=970&height=454&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%208.png) Next, I modified the Absence Request workflow to check for TOIL-type requests if the employee has accrued sufficient days and if not, invoke the TOIL Increase Approval workflow and then wait for it to complete. Once control passes back to the parent workflow, if the increase is approved the absence approval process can continue, otherwise it is set to rejected automatically. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%209.png?width=974&height=476&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%209.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%209.png) The new Invoke Workflow activity has the following properties within the Settings section: - **Definition: **The workflow being invoked. - **Initiator Item: **Optionally used to provide the initiator of the workflow being invoked. If not set, the initiator will be inherited from the parent workflow. - **Details Primary Key Item: **Optional used to provide the primary key for the additional details record used by the invoked workflow. - **Workflow ID Item: **Optional item to hold the ID of the invoked workflow. - **Wait for Completion:** If set to YES (ON), the parent workflow will wait for the invoked workflow to complete before continuing. If set to NO (OFF), the parent workflow will continue immediately without waiting for the invoked workflow to complete. - **Retry Point:** This is the point at which the invoked workflow will be retried if faulted. The Request TOIL Increase is an Invoke Workflow Activity set to "Wait for Completion" and passes back the value of the TOIL_STATUS parameter into a local variable named RETURNED_STATUS. This variable is used by a switch activity to determine if the approval process should continue or end with an automatic rejection.  [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2010.png?width=974&height=434&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2010.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2010.png) ### Testing Version 2 To test the updated version of the application, I created the following five absence requests to check the main routes through the process. - Bank Holiday - Vacation - TOIL (for an employee with sufficient days) - TOIL (for an employee with insufficient days) to be approved - TOIL (for an employee with insufficient days) to be rejected As expected, the bank holiday request auto approved and completed, while the other four absence requests require approval. The TOIL absence requests for Alexander & Christoper have detected insufficient TOIL accrued and successfully invoked the TOIL Increase workflows and are now in a waiting state. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2011.png?width=949&height=659&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2011.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2011.png) Looking at the invoked TOIL Increase workflows, I can see they are waiting for approval by the test user TOILADMIN. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2012.png?width=702&height=772&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2012.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2012.png) I logged into the application as TOILADMIN and used the Unified Task List page to review the two pending requests, setting one to approved and the other to rejected. The TOIL Increase request for Christopher was rejected, which correctly resulted in the parent absence request workflow being rejected as well. ![Invoking Workflows within Workflows – APEX 24.2 Image 13](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2013.png?width=702&height=569&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2013.png) The TOIL Increase request for Alexander was approved, which correctly returned the TOIL_STATUS with a value of INCREASED, which resulted in the parent absence request workflow continuing onto the approval activity for JSMITH. [![Invoking Workflows within Workflows – APEX 24.2](https://content.dsp.co.uk/hs-fs/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2014.png?width=702&height=732&name=Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2014.png)](https://content.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2014.png) ## Summary The new workflow features added to APEX 24.2 add a new level of flexibility for developers. In particular, the option to copy workflows and to invoke workflows from within workflows are two powerful features that significantly open up the options for what is possible, making APEX workflow a great option for mapping and actioning your business processes. For more information, check out our [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services), and if you liked this blog, check out our other [APEX blogs here](https://content.dsp.co.uk/apex). [Contact us](https://www.dsp.co.uk/contact-us) today and one of our expert developers will be in touch. [Oracle](https://content.dsp.co.uk/topic/oracle) [APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [APEX 24.2](https://content.dsp.co.uk/topic/apex-24-2) [14-May-2024 12:29:53 Using APEX Workflows ](https://content.dsp.co.uk/using-apex-workflows) [09-Aug-2024 09:14:32 APEX Approvals and Workflow Enhancements ](https://content.dsp.co.uk/apex-approvals-and-workflow-enhancements) [07-Dec-2023 16:36:16 APEX Workflows ](https://content.dsp.co.uk/apex-workflows) [Previous Leveraging Third-Party Support for Oracle Licensing ](https://content.dsp.co.uk/leveraging-third-party-support-for-oracle-licensing) [Next Exploring Key Features of Oracle WebLogic ](https://content.dsp.co.uk/exploring-key-features-of-oracle-weblogic) #### Contact Sales Enquiries [+44 (0) 203 880 1686](tel:+4420%2038801686) Technical Support +44 (0) 330 058 8367 [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk) #### Follow us #### Office Locations [**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D) [Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842) [**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) ** [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)** [Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) #### About Us DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies. ![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png) ![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png) ![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg) Registered Office: 30 City Road, London, EC1Y 2AB. Company Registration Number: 03898451 ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "dateModified" : "2024-10-01", "datePublished" : "2024-10-01", "headline" : "Invoking Workflows within Workflows – APEX 24.2", "image" : [ "https://www.dsp.co.uk/hubfs/Invoking%20Workflows%20within%20Workflows%20%E2%80%93%20APEX%2024.2%20Image%2010.png" ], "mainEntityOfPage" : { "@id" : "https://content.dsp.co.uk/invoking-workflows-within-workflows-apex-24.2", "@type" : "WebPage" } } ```