Skip to main content
Question

Cloud - Get Current User's PC While In Background Job

  • March 13, 2025
  • 1 reply
  • 24 views

Forum|alt.badge.img+5

Hi there Community members!

I’m looking to see if anyone has some insight on how I would be able to get the PC name of the currently logged in user who had submitted a background job in PL/SQL.

Previously, this would be as simple as looking at the Created By column in the Background Job, and then lookup their PC name in the MACHINE column of FND_SESSION_TAB. This table appears to have been abandoned and I don’t see any current rows in it (there are some from the previous version before upgrading to the Cloud version.) I’m looking for some insight or help on how I could capture the user’s PC name. The submission of the Background Job is a fore-ground process (user interacts with an Action to call a PL/SQL Command), so I could possibly collect it when the job is being submitted. I would prefer if this could be looked up somewhere in a table or by using a standard function call in the background job, but I understand if there are some limitations on that given the new internet browser client model.

Long story, short question: Is there a way to lookup which machine(s) a user is logged into in the Cloud version via the database?

Thanks,

Randy

PhillBronson
Hero (Customer)
Forum|alt.badge.img+10

Oracle has several ‘v$’ tables. Maybe you can use v$session for that information 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings