1. App Builder User's Guide
  2. Managing Shared Components
  3. Managing Automations
  4. Managing the Automation Execution Log

16.3.5 Managing the Automation Execution Log

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

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

See Also:

"Configuring or Deleting the Automation Log" in Oracle Application Express Administration Guide

Parent topic: Managing Automations

16.3.5.1 Viewing the Automation Execution Log

View the Automation Execution Log details about previous automation executions such as start and end timestamps as well as details about processed rows (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 Application Logic, 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 execution_log.png follows
    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 execution_log_messages.png follows
    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 Application Express SQL Workshop Guide.

Parent topic: Managing the Automation Execution Log

16.3.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 Automatons 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 Application Logic, select Automatons.
    The Automatons 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