Console customizations: resource, resource permission and menu reconciliation

Ensure that you complete the following sequence of tasks:

1. Changes to Sequence Numbering in Views

If a custom view has been placed between system resources or after system resources in the Resource Hierarchy tree, revisit these views and ensure that the sequencing of views in the Resource Hierarchy tree is correct. The views specified in the following table have been added in Release 9.1 to an existing entity.

Table 1. Views added in Release 9.1
View Type View ID View Name Sequencing Affected in the Entity in the Resource Hierarchy Tree
Detail YMRD999 Modification Reason Order

The following SQL scripts identify a list of custom views that may require a change in resource numbering because of the system views that have been added:

select parent_resource_id, resource_type,
resource_id, resource_desc, resource_seq
from yfs_resource
where resource_create_type != 'SYSTEM'
and resource_type in ('SEARCH_VIEW','LIST_VIEW','DETAIL_VIEW')
and parent_resource_id in
(select distinct parent_resource_id from yfs_resource
where resource_id in
('YMRD999'))
order by parent_resource_id, resource_type;

2. No views were deleted in Release 9.1.

3. No View Group ID changes were made in Release. 9.1