How to create custom profile in oracle apps r12

Hi friends, we are going to discuss about the how to create custom profile in oracle apps r12 . We will discuss how we can create the custom profiles in oracle apps as per our requirement. Profiles in oracle apps helps to control the application behavior in many ways. If want to control something at application level then profile is the best option provided by oracle in r12. If we want to control the application behavior based on some users or on some responsibility , then we need to create the custom profile for that requirement. Profile options helps to drive the run time application values which helps to control and working of the application. If we want drive run time values from application then profile option is the best way. Oracle has already provided the several standard profile options which helps to control and working of the application in many ways. In the similar way , custom profile we need to create if we want to control our custom code working like Oracle reports , Oracle custom Forms or Professionalization based on the application run time values. Here below is the complete detail about How to create custom profile in oracle apps r12.

Purpose of Custom Profile in Oracle apps

I will try to explain you the basic purpose of the custom profile option through one example. For example , We have two Oracle responsibilities Payable Inquiry & Payables Manager. We want to make the AP Invoice Description field required through Oracle form Professionalization but these is one catch in this. We want that AP Invoice Description field will be required only for Payables Manages responsibility but not for 'Payable Inquiry' responsibility. In this case , We will create the custom profile and provide the option of 'Yes' or 'No' for this profile option.

Then we will set this custom profile option to 'No' for 'Payable Inquiry' but 'Yes' for 'Payables Manager' responsibility.

In AP Invoice oracle form Professionalization , we will refer this custom profile as an condition to make the Invoice description field required. Based on this custom Profile Option value , Invoice description field will be required for 'Payables Manager' responsibility but Not required for 'Payables Inquiry' Responsibility.

Step by Step to create the custom profile in oracle apps r12

Step 1:- Go to Application Developer Responsibility.

Profiles:-

How to create custom profile in oracle apps r12

Step 2:- Here below , We have created the Custom Profile.

Name: XX_DESC_REQUIRED_PROFILE

Application: Payables

User Profile Name: Invoice Desc: Required

Step 3:- Now we want to provide the LOV to our custom profile. To create the LOV for Yes and No , we need to create the Lookup and then write the sql query to refer that lookup to show the LOV in this custom profile.

How to create custom profile in oracle apps r12

Step 4:- Here below , we have create the Custom Lookup to show the lov in the custom profile.

Type: XX_DESC_REQUIRED_Y_N

Step 5:-

Now , here below we have write the sql query which is referring the custom lookup 'XX_DESC_REQUIRED_Y_N'

SQL Query : SQL="SELECT MEANING \"Run in Debug Mode\",LOOKUP_CODE

INTO :visible_option_value,

:profile_option_value

from FND_LOOKUP_VALUES_VL

where lookup_type='XX_DESC_REQUIRED_Y_N'

COLUMN="\"Run in Debug Mode\"(10)"

Step 6:- Now our custom profile has been created. We are now using this Custom profile to set the system profile value for this custom profile in Payables responsibilities and to refer in the form personalization.

How to create custom profile in oracle apps r12

Step 7:-

To set the value to custom profile , we need to go to the system administrator responsibility.

Profile ==> System.

How to create custom profile in oracle apps r12

Step 8:- Here below , We have two Oracle responsibilities Payable Inquiry & Payables Manager. We want to make the AP Invoice Description field required through Oracle form Professionalization but these is one catch in this. We want that AP Invoice Description field will be required only for Payables Manages responsibility but not for 'Payable Inquiry' responsibility. In this case , We will create the custom profile and provide the option of 'Yes' or 'No' for this profile option.