Thursday 3 May 2012

Oracle Apps Folder | How to Migrate Folders | fndfold.lct

The folder configuration file fndfold.lct downloads and uploads folder definitions.
Entity Used in FNDLOAD Command: FND_FOLDERS
●●  A system administrator can change an owner of a folder using the Administer Folders form under the System Administrator responsibility.
●●  A default folder can be assigned to users and responsibilities. The default folder assignments are also handled by the folder loader.
This would download all Folders:
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct DOWNLOAD_ALL_FOLDER.ldt FND_FOLDERS
To download folders using FND_FOLDER Name:
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct <name of file>.ldt FND_FOLDERS NAME="<name of folder>"
To download folders by internal object names
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct \
<name of file>.ldt FND_FOLDERS OBJECT="<internal object name>"
To upload folders:
FNDLOAD apps/${xx_appspassword} 0 Y UPLOAD $FND_TOP/patch/115/import/fndfold.lct <name of file>.ldt
Using FNDLOAD with fndfold.lct to transfer folders from one database to another, and only the US language folders are downloaded.
In  fndfold.lct file comment out the following line, then it would download all the languages:
f.LANGUAGE = userenv('LANG')
If you open a SQLPLUS session and do the following select, US will be returned:
SQL> select userenv('LANG') from dual;
Therefore only the US Lang will be selected in the download.
Posted by at
Labels:

6 comments:

  1. Unknown9 August 2013 at 13:24

    Very good article indeed. Just 50% of what I was looking for. The other 50% is, do we have any FNDLOAD for Folder Set? Kindly let me know.

    Thanks,
    Rakshith Chengappa

    ReplyDelete
  2. Unknown9 August 2013 at 13:43

    Got it... Object is nothing but Folder Set.... The only problem is, the downloaded ldt is not getting upload.... any idea why? Any advice is much appreciated.

    Thanks,
    Rakshith Chengappa

    ReplyDelete
    Replies
    1. UdayBhaskar20 October 2017 at 19:49

      While uploading add CUSTOM_MODE=FORCE at the end of the upload command and see. It may solve your problem

      Delete
  3. Malay Khawas10 August 2013 at 10:25

    Hi Rakshith,

    Check the log of FND Upload command...
    Also check the language in fndfold.lct...
    Also check in your downloaded LDT what you see..

    Thanks
    Malay

    ReplyDelete
  4. Anonymous27 August 2014 at 08:16

    Worked perfectly. Found this Language ideea very good, cause it uploads all languages on target with one run.
    Thanks, HH

    ReplyDelete
  5. UdayBhaskar20 October 2017 at 19:53

    Nice one. However, is there any script to delete folders from the backend in an instance. I don't want to delete from the application. I want to delete some folders ( around 300 folders).
    Thanks
    Uday

    ReplyDelete

Subscribe to: Post Comments (Atom)