The Subledger Security reports provide information on the current and previous state of Subledger Security objects and organizations’ security structure.
The Subledger Security: Allocation Status Report displays all group allocations. The report is divided into the following sections:
secure tables allocated to Subledger Security groups
process groups allocated to Subledger Security groups
secure tables allocated to process groups
Each of the report sections provide historical data relating to when the allocations were enabled or disabled.
The report can be generated for
a specific security group, process group, or secure table.
Note: The Subledger Security: Allocation Status Report maps to the Maintain Allocations window.
The Subledger Security: Group Status Report displays information on all groups defined in the Subledger Security system. This report maps to the Maintain Groups window.
The report provides the following information:
lists all security groups and process groups
description
indicates enabled or disabled state
deletion dates
security history of the group
The Subledger Security: Grouped Secure Tables Report displays all security groups with currently secured tables. This report maps to the distinct table information in the Maintain Allocations window.
The Subledger Security: Object Status Report displays the current status of all Subledger Security objects required to implement security on a secured database table. The Subledger Security: Object Status Report enables the system administrator to identify and resolve security problems.
The Subledger Security: Object Status Report provides the following information:
corresponding Subledger Security table name for each secure database table
policy on the secure table
policy function used by the policy
database trigger on the secure table
index on secure table
synonym for secure table
grants required for secure table
The Subledger Security: Secure Tables Status Report lists all database tables that require security. The Subledger Security: Secure Tables Status Report maps to the Maintain Tables window.
The Subledger Security: Secure Tables Status Report lists all Oracle database table names with the database table owner, descriptions, and the Subledger Security table name. This report provides information on various security information states. Historical information is also displayed.
The Subledger Security: Security Group Consolidations Report provides information relating to security group consolidations and enables an organization to reconcile business unit structure changes.
The Subledger Security: Security Group Consolidations Report shows child security groups consolidated in the parent security group. Historical information is also provided, indicating when the consolidations took place.
The Subledger Security: User Allocation Status Report enables an organization to view the functional changes required and the impact of the changes when a security policy or business change is required.
This report displays information relating to a security group, indicating the responsibilities that are associated with the security group and application users who are using those responsibilities.
To generate the Subledger Security: Allocation Status Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Allocation Status Report from the list of values.
In the SLS Security Group Name field, enter a security group name or leave blank to report on all security groups.
In the Process Group Name field, enter a process group name or leave blank to report on all process groups.
In the Secure Table Name field, enter a secure table name or leave blank to report on all secure tables.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: Group Status Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Group Status Report from the list of values.
In the SLS Group Type field, select a group type from the list of values or leave blank to display all group types.
In the SLS Group Name field, enter a group name or leave blank to display all group names.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: Grouped Secure Tables Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Grouped Secure Tables Report from the list of values.
In the SLS Group Name field, enter a group name or leave blank to report on all group names.
In the Table Name field, enter a table name or leave blank to report on all table names.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: Object Status Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Object Status Report from the list of values.
In the Owner field, select the owner from the list or leave blank to report on all owners.
In the Secure Table Name field, enter a secure table name or leave blank to report on all secure tables.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: Secure Tables Status Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Secure Tables Status Report from the list of values.
In the Owner field, select the owner from the list or leave blank to report on all owners.
In the Secure Table Name field, enter a secure table name or leave blank to report on all secure tables.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: Security Group Consolidations Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administration - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: Security Group Consolidations Report from the list of values.
In the Source Group field, enter a source group name or leave blank to display all source groups.
In the Destination Group field, enter a destination group name or leave blank to display all destination groups.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests
To generate the Subledger Security: User Allocation Status Report, perform the following steps.
Navigate to the Submit Request window as follows:
OPSF(I) System Administrator - Subledger Security - Subledger Security Reports
Select the Single Request radio button.
In the Name field, select Subledger Security: User Allocation Status Report from the list of values
In the SLS Security Group Name field, enter the security group name or leave blank to report on all security groups.
In the User Id field, enter a user identifier for a particular user or leave blank to report on all users.
To apply the parameters, click OK.
To send the print request to the concurrent manager, click Submit Request.
To submit another request, click Yes or to continue, click No.
View the request in the concurrent manager as follows:
View - Requests