UI_AUDIT_LOG table

The UI_AUDIT_LOG table logs all user interface user interactions to the database. It stores the following information.
  • USER_NAME – User that sent the request.
  • IP_ADDRESS – IP address of the user.
  • SESSION_ID – The current session ID of the user. This ID is set when user logs in.
  • START_TIME – Time the recorded user interface event started.
  • END_TIME – Completion time of the recorded user interface event.
  • REQUEST – Request that is sent to browser. The request is the URL with parameters.
  • ACTION – The name of the action and the parameters that were used internally by the Operations and Administration Console.
  • ERROR_CODE – Indicates whether the operation succeeded or failed. Valid values for the error code are shown in the following list.
    0
    Success
    -1
    User interface error.
    -2
    Database error.
  • ERROR_MSG – Details about the error, if any.

For more information about the data that is logged, see User interface user interaction trace information.