Home › Discussions › Questions & Answers › User ID Lookup by Name using XXEN_UTIL

5 replies

  • Support Enginatics

    The function **`XXEN_UTIL.USER_ID(p_user_name in varchar2)`** returns the user ID based on the provided user name.

  • Avatar photoCustomer

    What value is returned for the SYSADMIN user?

  • Support Enginatics

    The query `select xxen_util.user_id(‘SYSADMIN’) from dual` returns `0`.

  • Avatar photoCustomer

    If I am building an API integration, is there a way to initialize the application context session?

  • Support Enginatics

    Yes, before calling submission APIs, you must initialize the application context session using `xxen_report.apps_initialize`, providing the user name, responsibility key, and responsibility application short code.

  • You must be logged in to reply to this post.