Forum Stats

  • 3,813,897 Users
  • 2,258,789 Discussions
  • 7,892,435 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