Mail
Automation in Oracle Apex
Step1: Open Oracle Apex Application
Step2: Go to Shared
Component
Step3: Click on Automation
Step4: Configure Automation
·
Click
on create
![]()
·
Give
name and other mandatory details
·
Give
type -Schedule
-On Demand
·
Mention
action initiated on -Query
-Always
·
Schedule
your execution-Every 15 min
-On
the Hour
-Daily
at mid night
-Custom
· Click on next
![]()
·
1. Name
- Defines the name of the
automation.
- Helps identify the
automation within the application.
Example:
Asset Return Reminder Automation
2. Currently
Executing
- Indicates whether the
automation is currently running.
- Values:
- Yes
– Automation is executing.
- No
– Automation is idle.
3. Type
The automation can be triggered in different
ways:
On Demand
- Runs only when
manually executed.
- Useful for testing
or user-triggered processes.
Scheduled
- Runs automatically
based on a schedule expression.
- In the screenshot,
the Scheduled
option is selected.
Schedule
Expression
Defines when the automation should execute.
Example from the screen:
FREQ=HOURLY;INTERVAL=1;BYMINUTE=0
Meaning:
- Run every hour.
- Execute at minute 0
of each hour.
- Example: 1:00 PM,
2:00 PM, 3:00 PM, etc.
5. Schedule
Status
Controls whether the automation is active.
- Active
– Automation runs according to the schedule.
- Disabled
– Automation will not run.
The screenshot shows Disabled, meaning the automation is currently turned
off.
6. Actions
Initiated On
Determines how the automation identifies
records to process.
Options include:
Query
- Processes rows
returned by a SQL query.
- Most commonly used
option.
Function Body Returning Boolean
- Runs based on a PL/SQL
function that returns TRUE or FALSE.
Always
- Executes every time
the automation is triggered regardless of conditions.
Source Section
The source specifies where the automation gets
its data.
In the screenshot:
- Data
Source: Local Database
This means the automation retrieves data from
tables or queries within the application's database.
· Click on next
Step 5: We will
get that screen Once Configure
Automation
We can configure
-Setting
-Source
-Action
-Action
Execution
-Additional code execution
-Server-side code exaction
Comments
Post a Comment