Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Which Table in HCM Cloud has User Entity backgroud SQL

User_FE73T
Member Posts: 1 Red Ribbon
Which Table in HCM Cloud has background SQL for User Entities .
Answers
-
Hello,
Commonly used table for User entity details are :
ff_dbi_groups_vl dbg
,ff_dbi_usages dbu
,ff_database_items fdi
,ff_user_entities ue
,ff_routes rt
The joins between the table are as :
dbg.dbi_group_id = dbu.dbi_group_id
and dbu.dbi_id = fdi.database_item_id
and fdi.user_entity_id = ue.user_entity_id
and ue.route_id = rt.route_id
-
select ue.base_user_entity_name, route.text from FF_USER_ENTITIES_B ue, FF_ROUTES_B route
where ue.base_user_entity_name = 'PAY_EXTRACT_RUN_RESULT_VALUES_UE'
and route.route_id = ue.route_id