Wednesday, May 23, 2012

How to download form personalization and upload it to another Instance

How to download form personalization and upload it to another Instance in Oracle E-Business Suite


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

Enjoy ;)

3 comments:

  1. Good day!

    I have used this functions to download and upload Personalizations, but I need to ONLY upload the new/changed Personalizations. The UPLOAD seems to delete all existing Personalizations and then only load what is in the file.

    Any help?
    Regards
    Erna Landman

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete