My Oracle Support Banner

APEX Automations Work on the First Run, but Fail on the Second Run (Doc ID 2980785.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Oracle Application Express (APEX) - Version All and later
APEX Application Development - Version NA and later
Information in this document applies to any platform.


When using Automations (Scheduler) on APEX application, it works on the first run, but the second run fails with error:

ORA-01031: Insufficient privileges

The issue can be reproduced at will with the following steps:
1.- In APEX application, create an Automation (from Shared Components) with a simple query. For example:

2.- Run the automation so it is executed every soon. For example: every 5 minutes
3.- First run works correctly.
4.- Second run (5 minutes later) fails with error: ORA-01031: Insufficient privileges
5.- As there was an error, the automation will stop running after that.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.