top of page

How to get default company in IFS

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 13, 2024
  • 1 min read
-- way 1
SELECT User_Profile_SYS.Get_Default('COMPANY', Fnd_Session_Api.Get_Fnd_User) FROM DUAL;

-- way 2
SELECT Site_API.Get_Company(CONTRACT)   company
FROM   user_allowed_site_tab
WHERE  userid         = Fnd_Session_Api.Get_Fnd_User
AND    user_site_type = 'DEFAULT SITE';

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page