Previous Next JavaScript must be enabled to correctly display this content

## 19.5.5 Managing the Automation Execution Log

View and clear the Automation Execution Log records on the Automations, Execution Log page.

Oracle APEX purges log information by default every 14 days. Other retention periods can be configured in Administration Services.

- Viewing the Automation Execution Log
  View the Automation Execution Log for details about previous automation executions, such as start and end timestamps and details about processed rows (both successful and with errors).
- Purging the Automation Execution Log
  Purge the Automation Execution Log records by clicking Purge Log on Execution Log page.

See Also:

Configuring or Deleting the Automation Log in Oracle APEX Administration Guide

Parent topic: Managing Automations

### 19.5.5.1 Viewing the Automation Execution Log

View the Automation Execution Log for details about previous automation executions, such as start and end timestamps and details about processed rows (both successful and with errors).

The Automation Execution Log contains start and end timestamps as well as details about processed rows (successful and with errors). Drill down into Messages to see individual messages for processed rows.

To access the Execution Log:

1. Navigate to the Automations page:
   1. On the Workspace home page, click App Builder.
   2. Select the new application.
   3. On the Application home page, click Shared Components.
      The Shared Components page appears.
   4. Under Workflows and Automations, select Automations.
   The Automations page appears.
2. Click the Execution Log tab.

   The Execution Log appears displaying the following: Start Timestamp, Automation name, Status, Successful Rows, Error Rows, and Messages.

   Description of the illustration execution_log.png
3. Click the link under Messages to view individual messages for processed rows.

   The Log Messages appear.

   Description of the illustration execution_log_messages.png

   Each log message displays the following: Timestamp, the Message text, the Message Type (Information, Warning, or Error), and (optionally) the primary key value of the row for which the message was generated.

Tip:

You can view the target table in SQL Workshop, Object Browser to validate that the automation is actually changing the data. See Browsing a Table in Oracle APEX SQL Workshop Guide.

Parent topic: Managing the Automation Execution Log

### 19.5.5.2 Purging the Automation Execution Log

Purge the Automation Execution Log records by clicking Purge Log on Execution Log page.

To purge the Automations Execution Log:

1. Navigate to the Automations page:
   1. On the Workspace home page, click App Builder.
   2. Select the new application.
   3. On the Application home page, click Shared Components.
      The Shared Components page appears.
   4. Under Workflows and Automations, select Automations.
   The Automations page appears.
2. Click the Execution Log tab.

   The Execution Log page appears.

3. Click Purge Log.
4. In the Clear Automation Log dialog:
   1. From the Automation list, select the log to purge.
   2. Click Clear Log

Parent topic: Managing the Automation Execution Log