Monday 29 August 2016

FND_PROFILE to use the current value for the session in oracle Apps EBS



FND_PROFILE to use the current value for the session
FND_PROFILE.VALUE :
This is a function which returns a character string. It can be used to retrieve the current value of the specified user profile option.

Example:

fnd_profile.value(‘PROFILEOPTION’)

fnd_profile.value(’MFG_ORGANIZATION_ID’)

fnd_profile.value(’LOGIN_ID’)

fnd_profile.value(’USER_ID’)

fnd_profile.value(’USERNAME’)

fnd_profile.value(’CONCURRENT_REQUEST_ID’)

fnd_profile.value(’GL_SET_OF_BKS_ID’)

fnd_profile.value(’ORG_ID’)

fnd_profile.value(’SO_ORGANIZATION_ID’)

fnd_profile.value(’APPL_SHRT_NAME’)

fnd_profile.value(’RESP_NAME’)

fnd_profile.value(’RESP_ID’)

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...