EPFO-PCP

Create new menus in fointerface application
Talk with Pune team, if needed.

• Create menus under fointerface application
• Connect to database as in attachment
• Add new submenus under main menus.

@Rasmiya R S , @Sreeshna T.

select * from FO_OFFICE_USERS where login_name = 'FRONT_DESKDAJKJAMMU'; --3999
select * from OFFICE where ID = 517

select * from FO_AUTH_USER_ROLE where user_id = 3999 order by ROLE_ID -- multiple roles

--Determines first level sub menus based on user roles
select * from FO_AUTH_ROLE_D where ROLE_ID in (select ROLE_ID from FO_AUTH_USER_ROLE where user_id = 3999) ORDER BY MENU_SEC_ID; --MENU_SEC_ID 243

select * from FO_AUTH_ROLE where ROLE_ID in (select ROLE_ID from FO_AUTH_USER_ROLE where user_id = 3999) order by ROLE_ID;

--list of root level menus
select * from FO_AUTH_MENU_PRI --CCPS

select * from FO_AUTH_MENU_SEC where MENU_SEC_ID IN
(select MENU_SEC_ID from FO_AUTH_ROLE_D
where ROLE_ID in (select ROLE_ID from FO_AUTH_USER_ROLE where user_id = 3999)
) ORDER BY MENU_PRIM_ID, MENU_SEC_ID

Done