Implementation Guide for Oracle Self-Service E-Billing > Using the Reporting Engine >
Reporting on System Administrator Audit Data
Oracle Self-Service E-Billling 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 Self-Service E-Billling stores the audit data for these system administrator activities in the administrator activity table, ADMIN_ACTIVITY. Table 50 describes the ADMIN_ACTIVITY table:
Table 50. 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 51 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 51 shows the valid activity codes that can be stored in the ACTIVITY_CODE column in the ADMIN_ACTIVITY:
Table 51. 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. |
|