---
title: "Discussion on \"APEX Background Page Processing - The Definitive Guide\" | Hashnode"
description: "Discussion on \"APEX Background Page Processing - The Definitive Guide\". Read this post to find out everything you need to know to get started with APEX Background Page Processing"
url: "https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [APEX Background Page Processing - The Definitive Guide](https://blog.cloudnueva.com/apex-background-page-processing-the-definitive-gude?utm_source=hashnode&utm_medium=feed)

Read this post to find out everything you need to know to get started with APEX Background Page Processing

Sep 19, 2024 · 12 min read · blog.cloudnueva.com  
Updated Oct 3, 2024  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 4

Markdown supported · ⌘↵ to post

[JD](https://hashnode.com/@jdcr1)

[May 11](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/6a026d27fca21b0d4b7c430f)

As usual a great article John. What are your thoughts about using this mechanism in a SaaS application where you have several tenants, each one with many users, so a given process in the application could be run "at the same time" simultaneously by lots of different users. I'm worried about hitting the Maximum number of background page processes easily. The app runs on an ADB in the OCI APEX.

Thanks in advance

Regards

[Eddie Harris](https://hashnode.com/@harrise)

[Sep 26, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66f4db9d9d244573f9507095)

Thanks Jon

Another great quick overview and summary

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 27, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66f4db9d9d244573f9507095#reply-66f6161b4d07750ab22ab765)

You are welcome.

[CUNEYT TASLI](https://hashnode.com/@Juno)

[Sep 22, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66f034bef2475b4f7770e8a4)

Oh boy! Am I glad that you didn't retire? Thank you for this great post.

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 22, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66f034bef2475b4f7770e8a4#reply-66f04925ec195e1c3a987355)

Thank you, much appreciated.

[Joe Kerr](https://hashnode.com/@jkerr)

[Sep 22, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4)

Very well done, and helpful.  
I have an IG using FOS plugin to add Menu Items to "Actions Menu" that trigger a custom event that causes a Dynamic Action to fire executing PL/SQL code using Primary Keys of currently selected IG rows and other page item values. I want to move the PL/SQL code to a background process and cause it to fire as one of the actions of the Dynamic Action. Ideas on how to do that? In short, how to fire a background Process from a Dynamic action that uses Page Item values? It seems it has to be a button click event? Or a submit, but then I lose which items were selected? Thoughts? Thanks Joe

[Joe Kerr](https://hashnode.com/@jkerr)

[Sep 22, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4#reply-66f05502ccc0f78100865258)

[Jon Dixon](https://hashnode.com/@orclapex) Hi Jon, Thanks for the quick and helpful options. I am thinking a good APEX Idea could be making it possible to fire a process with a custom event similar to DAs? Joe

[Joe Kerr](https://hashnode.com/@jkerr)

[Sep 24, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4#reply-66f2e23cb20a3b7789d8dd10)

[Jon Dixon](https://hashnode.com/@orclapex) Hi Jon, FYI I went the dbms\_scheduler route, but setting argument values for a PLSQL\_BLOCK generates an error saying that type does not allow arguments. I handled it by pre-constructing the job\_action to build the parameter values into the job\_Action parameter value. Thanks again, Joe

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 24, 2024](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4#reply-66f2f66dc414964eedbfc046)

[Joe Kerr](https://hashnode.com/@jkerr) makes sense.