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