Apps Oracle FNDLOAD Script Examples. PLEASE USE THIS LINK FOR FNDLOAD ON APPS2. FUSION. COMIn this article I wish to give real working examples of Oracles FNDLOAD utility. In my. bat file I want to generate a unique name for filesdirectories based on datetime. Build20091029105900 The problem is that TIME wont do because. Besides that, I have included some useful notes on FNDLOAD utility. C-Media Usb Mic Driver here. I have used FNDLOAD successfully in past for several different entitiesdata types within Oracle 1. Some of the examples in this FNDLOAD article include FNDLOAD to transfer Request Groups. I am running Windows XP. I need to execute VBS scripts to run functions in other programs. I had no problem until some security program disabled execution of. Text Editor. Creating a Visual Basic Script is easy all you need is a simple text editor such as Windows Notepad. However, instead of saving the file with a name. Script To Change File Name' title='Script To Change File Name' />FNDLOAD for moving Concurrent Programs. FNDLOAD to download and upload Forms Personalizations or Personalisations depending on where you are located To FNDLOAD Web ADI, visit the link Web ADI FNDLOADUse FNDLOAD for transferring value set definitions. Please note that when transferring Key Flex Fields and Descriptive flex fields the respective value sets against each segment will be extracted and loaded automatically. Also, FNDLOAD can be used to migrate Key Flex. Fields, Descriptive Flexfields, Responsibilities and almost every other FND entity. Please note that the text written down here could get wrapped in the browser. Hence you may have to use to continue the single line command on Unix, in case you find the lines wrapping. Forums/getfile/987595' alt='Script To Change File Name' title='Script To Change File Name' />In my case I am ensuring that CLIENTAPPSPWD has the apps password before running the scripts To FNDLOAD Request groups. FNDLOAD appsCLIENTAPPSPWD O Y DOWNLOAD FNDTOPpatch1. XXMYREPORTGROUPNAME. REQUESTGROUP REQUESTGROUPNAMEXXMYREPORTGROUPNAME APPLICATIONSHORTNAMEXXGMSNote that lt will be your Application Shortname where request group is registered XXMYREPORTGROUPNAMEWill be the name of your request group To upload this Request Group in other environment after having transferred the ldt file. FNDLOAD appsCLIENTAPPSPWD O Y UPLOAD FNDTOPpatch1. To FNDLOAD Concurrent Programs. FNDLOAD appsCLIENTAPPSPWD O Y DOWNLOAD FNDTOPpatch1. XXCUSTOMORACLEINTERFACEPROG. PROGRAM APPLICATIONSHORTNAMEXXGMS CONCURRENTPROGRAMNAMEXXCUSTOMORACLEINTERFACEPROGNote that XXGMS will be your custom GMS Application Shortname where concurrent program is registered XXCUSTOMORACLEINTERFACEPROGWill be the name of your request group XXCUSTOMORACLEINTERFACEPROG. To upload. FNDLOAD appsCLIENTAPPSPWD O Y UPLOAD FNDTOPpatch1. XXCUSTOMORACLEINTERFACEPROG. To FNDLOAD Oracle Descriptive FlexfieldsFNDTOPbinFNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXPOREQHEADERSDFF. DESCFLEX APPLICATIONSHORTNAMEPO DESCRIPTIVEFLEXFIELDNAMEPOREQUISITIONHEADERSNote that PO is the Application Shortname against which descriptive flexfield against PO Headers is registered POREQUISITIONHEADERSis the name of Descriptive Flexfield against PO Requisition Headers Use the SQL below to find the name of DFF, rather than logging into the screen ooops via jinitiator SELECT applicationid, DESCRIPTIVEFLEXFIELDNAME, applicationtablename FROM fnddescriptiveflexsvl WHERE APPLICATIONTABLENAME like upper tabname ORDER BY APPLICATIONTABLENAME To upload into another environmentFNDTOPbinFNDLOAD appsCLIENTAPPSPWD 0 Y UPLOAD FNDTOPpatch1. XXPOREQHEADERSDFF. OK another example for DFF against FNDLOOKUPSFNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXFNDCOMMONLOOKUPSDFF. DESCFLEX APPLICATIONSHORTNAMEFND DESCRIPTIVEFLEXFIELDNAMEFNDCOMMONLOOKUPS OK another example for DFF against Project Accounting Expenditure Types. FNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXPAEXPENDITURETYPESDESCFLEXDFF. DESCFLEX APPLICATIONSHORTNAMEPA DESCRIPTIVEFLEXFIELDNAMEPAEXPENDITURETYPESDESCFLEX To FNDLOAD Oracle MenusFNDTOPbinFNDLOAD appsCLIENTAPPSPWD O Y DOWNLOAD FNDTOPpatch1. ICXPORSSPHOME. MENU MENUNAMEICXPORSSPHOMENote that Oracle Menus are not attached to applications. Hence no need to include application short name ICXPORSSPHOME is the menu name. This can be validated via below SQL select usermenuname from fndmenusvl where menuname ICXPORSSPHOME Also note that we do not pass in the Usermenuname in this example OK, now to upload this fileFNDTOPbinFNDLOAD appsCLIENTAPPSPWD O Y UPLOAD FNDTOPpatch1. ICXPORSSPHOME. Well, now for FND Messages to download a single message. FNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXICXPORLIFECYCLEPAYTIP. FNDNEWMESSAGES APPLICATIONSHORTNAMEICX MESSAGENAMEXXICXPORLIFECYCLEPAYTIP Or you may as well download all the messages within an application. FNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXALLGMSMESSAGES0. FNDNEWMESSAGES APPLICATIONSHORTNAMEXXGMS now to upload using FNDLOADFNDLOAD appsCLIENTAPPSPWD 0 Y UPLOAD FNDTOPpatch1. XXICXPORLIFECYCLEPAYTIP. Now its the turn of Lookup values. Again, its not a rocket science. FNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD aflvmlu. XXTRXBATCHSTATUS. FNDLOOKUPTYPE APPLICATIONSHORTNAME XXGMS LOOKUPTYPEXXTRXBATCHSTATUS Note that XXTRXBATCHSTATUS is the name of FND Lookup Type in this example This will download all the lookup codes within the defined lookup To upload. FNDLOAD appsCLIENTAPPSPWD 0 Y UPLOAD aflvmlu. XXTRXBATCHSTATUS. You can also move the User definitions from FNDUSER FNDLOAD appsCLIENTAPPSPWD 0 Y DOWNLOAD FNDTOPpatch1. XXFNDUSERPASSI. FNDUSER USERNAMEANILPASSIDo not worry about your password being extracted, it will be encrypted as below in ldt fileBEGIN FNDUSER ANILPASSI  OWNER PASSIA  LASTUPDATEDATE 2. ENCRYPTEDUSERPASSWORD ZGE4. A8. A9. BE5. CF4. C6. 25. B9. 9CAEDF1. C3. 4FEA2. 44. DC7. A  SESSIONNUMBER 0To upload the FNDUSER using FNDLOAD command use FNDLOAD appsCLIENTAPPSPWD 0 Y UPLOAD FNDTOPpatch1. XXFNDUSERPASSI. Notes for using FNDLOAD against FNDUSER 1. After uploading using FNDLOAD, user will be promoted to change their password again during their next signon attempt. Directia 5 Romantic'>Directia 5 Romantic. All the responsibilities will be extracted by FNDLOAD alongwith User Definition in FNDUSER 3. In the Target Environment, make sure that you have done FNDLOAD for new responsibilities prior to running FNDLOAD on users. Now lets have a look at the profile option using oracles FNDLOADFNDLOAD appsCLIENTAPPSPWD O Y DOWNLOAD FNDTOPpatch1. PORENABLEREQHEADERCUST. PROFILE PROFILENAMEPORENABLEREQHEADERCUST APPLICATIONSHORTNAMEICX Note that PORENABLEREQHEADERCUST is the short name of profile option We arent passing the user profile option name in this case. Validate using. select applicationid, PROFILEOPTIONNAME profileoptionid USERPROFILEOPTIONNAME from FNDPROFILEOPTIONSVL where PROFILEOPTIONNAME like upper profileoptionname order by PROFILEOPTIONNAME Now to upload.