5.17.3 Prevent Error

For the most current information, see My Oracle Support article 727208.1, AuditTrail Update Tables fails on View AP_SYSTEM_PARAMETERS_ALL_AC1.

To follow Step 1 in the article, do the following:

  1. Log in to Oracle LSH as sysadmin.

  2. Navigate to System Administrator, then Security, then Audit Trail, and then Groups.

  3. Confirm anything necessary to get the application to run and a form appears.

  4. Press F11.

  5. In the Audit Group line enter SQLAP.AP_SYSTEM_PARAMETERS_ALL and press Ctrl+F11. The Audit Group SQLAP.AP_SYSTEM_PARAMETERS_ALL appears.

  6. Proceed with Step 2 in the MOS article.

Step 2 in the article is:

  1. Set the Group state to "Disable - Purge Table" for AP_SYSTEM_PARAMETERS_ALL. This option Disable - Purge Table Drops the auditing triggers and views and deletes all data from the shadow table.
  2. Be sure to Save before exiting.