How to download form personalization and upload it to another Instance


Here is a very useful command FNDLOAD, that can be use to take a backup of your form personalization.
Your personalizations will be saved on .ldt file.
We will learn this through two simple steps,

*** You should take a note that upon uploading, all prior personalization for that function are first deleted, and then the contents of the loader file are inserted. So be careful.

Step 1:
 Download your personalization.
From Linux, set the environment file, your .ldt file will be created on 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 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 


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...