Newly Created Child Domain Adding User_menu_access Records From Parent & Sub Domains
(Doc ID 2993821.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.5.2 and laterInformation in this document applies to any platform.
Symptoms
When a new sub domain is created, it adds the user_access & user_menu_access records from its Parent domain as well as other pre existing sub domains.
Customer ran the below sql to verify the same
select uma.user_menu_layout_gid, ua.user_access_gid, uma.domain_name, ua.gl_level, ua.user_role_gid, ua.gl_user_gid,
ua.is_lockdown, ua.is_override, ua.access_type, ua.insert_user, ua.insert_date, ua.update_user, ua.update_date
from user_access ua, user_menu_access uma where ua.user_access_gid = uma.user_access_gid and ua.domain_name in ('<Domain_name>')
order by 3
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |