Implementation Guide for Oracle Billing Insight > Reporting on Audit Data >
Reporting on System Administrator Audit Data
Oracle Billing Insight audits the following system administrator actions performed in the Command Center application:
- Creating new jobs
- Updating jobs
- Removing jobs
- Scheduling jobs
- Running jobs
- Creating a new administrator
- Enrolling a new administrator
- Updating an administrator's information
- Adding, updating, and deleting payment settings
- Logging into and out of the Command Center
You can create customized reports on the audited administrator data. Oracle Billing Insight stores the audit data for these system administrator activities in the administrator activity table, ADMIN_ACTIVITY. Table 120 describes the ADMIN_ACTIVITY table.
Table 120. Definition of the ADMIN_ACTIVITY Table
|
|
ACTIVITY_ID |
Unique ID assigned to the each occurrence of a Command Center activity, generated automatically by sequence. |
ACTIVITY_CODE |
The name of the activity performed by the system administrator. See Table 121 for a list of valid activity codes. |
PRODUCT_CODE |
The product name for the Command Center application. The default value is ESTATEMENT. |
DDN_REFERENCE |
The DDN reference number. |
LOGIN_ID |
The ID of the system administrator who logged into the Command Center to perform the activity. |
ACTIVITY_START_TIME |
The time the activity started. |
ACTIVITY_END_TIME |
The time the activity finished. |
FLEX_FIELD1 |
For logging into and out of the Command Center: Whether the activity was successful (Yes or No). For creating, updating, removing, running, or scheduling a job: The name of the job. |
FLEX_FIELD2 |
The IP address where the administrator logged in and performed the Command Center activity. |
DATE_CREATED |
Date when the audit record was created. |
CREATED_BY |
The ID of the system administrator who performed the activity. |
UPDATE_DATE |
This field is not currently used. |
UPDATED_BY |
This field is not currently used. |
Table 121 shows the valid activity codes that can be stored in the ACTIVITY_CODE column in the ADMIN_ACTIVITY:
Table 121. Valid Activity Codes
|
|
LOGIN |
An administrator logs in. |
LOGOUT |
An administrator logs out. |
CREATE JOB |
An administrator creates a new job. |
UPDATE JOB |
An administrator updates job information. |
DELETE JOB |
An administrator deletes a job. |
CREATE USER |
The default administrator creates a new administrator user. |
ENROLL USER |
A newly created administrator user enrolls his or her own information. |
UPDATE USER |
An administrator updates his or her own information. |
CREATE PAYMENT SETTINGS |
An administrator creates payment settings. |
UPDATE PAYMENT SETTINGS |
An administrator updates payment settings. |
DELETE PAYMENT SETTINGS |
An administrator deletes payment settings. |
|