Category Archives: Personalizations

How Do You Change the Privacy Statement From The Default Value Of in Oracle Applications Release 12

Here are the steps to configure Privacy Statement link using Functional Administrator 1. Select Functional Administrator responsibility 2. Click the Personalization tab 3. In Document Path, enter /oracle/apps/fnd/framework/webui/OAFooter 4. Click the Personalize Page (pencil icon) 5. Choose context as shown in the below screenshot 6. Click on Apply button 7. Select Personalize (pencil icon) in… Read More »

Oracle SQL Query to list all Form Personalizations

/********************************************************** *PURPOSE: To list all forms personalizations * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT ffv.form_id , ffv.form_name , ffv.user_form_name , ffv.description "Form Description", ffcr.sequence , ffcr.description "Personalization Rule Name" FROM fnd_form_vl ffv, fnd_form_custom_rules ffcr WHERE ffv.form_name = ffcr.form_name ORDER BY ffv.form_name, ffcr.sequence; SELECT * FROM fnd_form_custom_rules;/********************************************************** *PURPOSE: To list all forms personalizations * *AUTHOR: Shailender… Read More »

Profile options for OAF Personalization

Most of the times I forget the exact names of profile options related to OAF, so just for reference I am listing out here. • Personalize Self-Service Defn – Yes to allow ‘Personalize’ link to appear at the top of the page • FND: Personalization Region Link Enabled – Yes to display all the regional… Read More »