Oracle Form Personalization Query

SELECT fcr.id,
  fff.user_function_name,
  fcr.form_name,
  fcr.sequence,
  fcr.description,
  fcr.enabled,
  fu.user_name,
  fcr.trigger_event,
  fcr.trigger_object,
  fcr.last_update_date,
  fcr.condition,
  fff.function_name,
  ffca.sequence,
  ffca.property_value,
  ffca.target_object,
  ffca.message_text,
  fffs.irep_assoc_function_name,
  fffs.irep_description,
  fffs.irep_method_name
FROM fnd_form_custom_rules fcr,
  fnd_form_functions_vl fff,
  fnd_user fu,
  fnd_form_custom_actions ffca,
  fnd_form_functions fffs,
  fnd_form_functions_tl ffft
WHERE fcr.function_name = fff.function_name
AND ffca.created_by     = fu.user_id
AND fcr.last_updated_by = fu.user_id
AND ffca.rule_id        = fcr.id
AND fffs.function_id    = ffft.function_id
AND fcr.form_name       ='POXPOEPO'
ORDER BY fcr.last_update_date DESC;

How to download form personalization and upload it to another instance

Step 1: Download your personalization.
From Linux, set the environment file, your .ldt file will be created on the current directory

FNDLOAD <apps_user>/<password> 0 Y DOWNLOAD

$FND_TOP/patch/115/import/affrmcus.lct <file_name>.ldt FND_FORM_CUSTOM_RULES

form_name=<form_name>

 Here three parameters are used :

<apps_user>    = apps user name normally apps
<password>     = apps password
<file_name>      = file name (in our case test.ldt)
<form name>    = form name can be get form Help > About Oracle Applications

Usage:
FNDLOAD apps/*** 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct test.ldt

FND_FORM_CUSTOM_RULES form_name=FNDSCAUS


Step 2: Upload your personalization to another instance.

 From Linux, set the environment file, go to the path where .ldt file is copied

 FNDLOAD <apps_user>/<password> 0 Y UPLOAD$FND_TOP/patch/115/import/affrmcus.lct

 <file_name>.ldt

Usage:
FNDLOAD apps/*** 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct test.ldt


Example :

TO DOWNLOAD:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct OEXOEORD.ldt FND_FORM_CUSTOM_RULES fnd_form_name="ONT_OEXOEORD" 


TO UPLOAD: 
FNDLOAD apps/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct OEXOEORD.ldt FND_FORM_CUSTOM_RULES form_name='OEXOEORD'

Oracle Form Personalization Query: How to Retrieve Personalization Data

select fcr.id,

       fff.user_function_name,

       fcr.form_name,

       fcr.sequence,

       fcr.description,

       fcr.enabled,

       fu.user_name,

       fcr.trigger_event,

       fcr.trigger_object,

       fcr.last_update_date,

       fcr.condition,

       fff.function_name,

       ffca.sequence,

       ffca.property_value,

       ffca.target_object,

       ffca.message_text,

       fffs.irep_assoc_function_name,

       fffs.irep_description,

       fffs.irep_method_name

from fnd_form_custom_rules fcr,

     fnd_form_functions_vl fff,

     fnd_user fu,

     fnd_form_custom_actions ffca,

     fnd_form_functions fffs,

     fnd_form_functions_tl ffft

where fcr.function_name = fff.function_name

and ffca.created_by = fu.user_id

and fcr.last_updated_by = fu.user_id

and ffca.rule_id = fcr.id

and fffs.function_id = ffft.function_id;

Oracle API to Delete Form Personalization: Quick and Safe Method

DECLARE
       i_rule_key varchar2(30);
       i_rule_type varchar2(30);
       i_function_name varchar2(30);
       i_form_name varchar2(30);
    cursor c1
    is
    select * from fnd_form_custom_rules
    where id = '2222';
     
BEGIN
      fnd_form_custom_rules_pkg.
          delete_set (x_rule_key        => i_rule_key,
                      x_rule_type       => i_rule_type,
                      x_function_name   => i_function_name,
                      x_form_name       => i_form_name);
   DBMS_OUTPUT. put_line (' Personalization has been Successfully Completed');
      EXCEPTION
         WHEN OTHERS
         THEN
            DBMS_OUTPUT.put_line ('Error: ' || SQLERRM);
END;

Oracle Forms Personalization Query Tips for Easy Customization

select fcr.id,
       fff.user_function_name,
       fcr.form_name,
       fcr.sequence,
       fcr.description,
       fcr.enabled,
       fu.user_name,
       fcr.trigger_event,
       fcr.trigger_object,
       fcr.last_update_date
from fnd_form_custom_rules fcr,
        fnd_user fu,
        fnd_form_functions_vl fff
where fcr.function_name = fff.function_name
and fcr.last_updated_by = fu.user_id
and user_name = '&user_name'
AND user_function_name = 'Quick Sales Orders';

Top 10 New Oracle Forms and OAF Personalization Tips

_https://drive.google.com/open?id=1JrfoJD0Gg6jeVGDYOh8jXtr-enlx9xX_

Oracle Forms Personalization: Customize Your EBS Experience Easily

https://drive.google.com/open?id=1gC3Xi-Vic6LDVmFuNLJ1c4nscrCWxvC5