My Oracle Support Banner

Newly Created Child Domain Adding User_menu_access Records From Parent & Sub Domains (Doc ID 2993821.1)

Last updated on DECEMBER 18, 2023

Applies to:

Oracle Transportation Management - Version 6.5.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.