Skip to main content
Solved

Saved query - get UserId / PersonId dynamically

  • July 26, 2021
  • 1 reply
  • 371 views

Forum|alt.badge.img+5

HI all

 

(this is IFS2003 - I know, I know...)

 

I recall someone long ago creating a Saved query that could be shared amongst our users, that looked for (say) Approvals for that user. The dynamic code meant it could be passed around without need to change the Advanced query.

For instance, instead of USERID  = ‘BLOGGSF’,

I thought we could use USERID = (select Ifsapp.fnd_session_api.get_fnd_user()from dual)

but this generates the error “fnd_session_api is not a procedure or is undefined

How can I get this to work, or is there an alternative?

Would be good to do this for PersonId too.

 

 

Thanks

Best answer by Tim Oliver

Funny how you ask a question and then find the answer yourself!

 

For reference - 

 

Person Id from session details is:

&APPOWNER.PERSON_INFO_API.Get_Id_For_User(&APPOWNER.FND_Session_API.Get_Fnd_User)

 

User Id (or identity) is:

&APPOWNER.FND_Session_API.Get_Fnd_User

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • Answer
  • July 26, 2021

Funny how you ask a question and then find the answer yourself!

 

For reference - 

 

Person Id from session details is:

&APPOWNER.PERSON_INFO_API.Get_Id_For_User(&APPOWNER.FND_Session_API.Get_Fnd_User)

 

User Id (or identity) is:

&APPOWNER.FND_Session_API.Get_Fnd_User

 


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