Function to get Profile option value oracle apps

Hi Friends, we are going to discuss about Function to get Profile option value oracle apps. We will share the method and the standard function to get the profile options values in oracle apps. Profile option helps to store the Oracle Application values. If we want to get the run time application values then we we need to use the oracle standard function. In this post , We will share the standard function and the method to get the profile option values in oracle apps. Using this function , we can get the profile option values in Oracle custom forms , in Oracle Reports , in Standard Forms personalization in oracle apps. Please find below the complete detail about function to get Profile option value oracle apps.

Function to get Profile option value oracle apps

Standard Function to get the Profile Option Value in Oracle Apps

Here below is the function to get the profile option values in oracle apps 

fnd_profile.value

Steps to use the Function to get Profile option value oracle apps

Here below , is the details steps to use the function to the profile option values in oracle apps.

I am sharing below the list of profiles which we can get using these below syntax.

For Example, If we have to get the Operating unit id then we can use this below syntax to get the Operating unit Id(ORG ID).

fnd_profile.value('ORG_ID')

For Example, If we have to get the Inventory Org ID then we can use this below syntax to get the Inventory Org Id(MFG_ORGANIZATION_ID)

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('SO_ORGANIZATION_ID')

fnd_profile.value('APPL_SHRT_NAME')

fnd_profile.value('RESP_NAME')

fnd_profile.value('RESP_ID')

fnd_profile.value('PER_BUSINESS_GROUP_ID')

fnd_profile.value('GL_SET_OF_BKS_ID')

Function to get Profile option value oracle apps