Tables for Forms Personalization

Below is the list of tables that are populated when any Forms Personalization is done

FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST

You can use the FNDLOAD utility to move the peronalizations from one instance to another.

Example Synatx shown below to download or upload Form Personalizations.

Download Personalizations

1) FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_OEXOEORD.ldt FND_FORM_CUSTOM_RULES form_name=”OEXOEORD”

2) FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_OEXOETEL.ldt FND_FORM_CUSTOM_RULES form_name=”OEXOETEL”

Upload Personalizations

1) FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_OEXOEORD.ldt

2) FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_OEXOETEL.ldt

The below script list all the forms in Oracle Applications that have been customized using Forms Personlization:

/* Formatted on 2014/07/17 19:02 (Formatter Plus v4.8.8) */
SELECT   ffv.form_id, ffv.form_name, fat.application_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, fnd_application_tl fat
   WHERE ffv.form_name = ffcr.form_name
     AND    fat.application_id = ffv.application_id
ORDER BY  ffv.form_name, ffcr.SEQUENCE;
Challa.