This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,506 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

Which Table in HCM Cloud has User Entity backgroud SQL

User_FE73T
User_FE73T Member Posts: 1 Red Ribbon

Which Table in HCM Cloud has background SQL for User Entities .

Tagged:

Answers

  • Pranav_HCM
    Pranav_HCM Member Posts: 8 Green Ribbon

    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

  • Ivan Parra
    Ivan Parra Member Posts: 1 Red Ribbon

    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

    Durgadevi-Oracle