Comments for Oracle FNDLOAD Script Examples at http://apps2fusion.com , comment 1 to 138 out of 20 comments http://apps2fusion.com Mon, 15 Mar 2010 11:46:51 +0100 FeedCreator 1.7.3 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-7132 Hi Anil, I am trying to create request set from one instance to another. I have downloaded the ldt and am trying to upload the ldt and getting this error. Uploading from the data file SITEL_GLSTRING_SET.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/prod/prodappl/fnd/11.5.0/patch/115/import/afcprset.lct(115.28), SITEL_GLSTRING_SET.ldt) to stage tables Dump LCT file /prod/prodappl/fnd/11.5.0/patch/115/import/afcprset.lct(115.28) into FND_SEED_STAGE_CONFIG Dump LDT file SITEL_GLSTRING_SET.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (REQ_SET SITGL FNDRSSUB2458 , STAGE_PROG 10 ) into FND_SEED_STAGE_ENTITY Upload from stage tables Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = SITGL, REQUEST_SET_NAME = FNDRSSUB2458, STAGE_NAME = STAGE10, SEQUENCE = 10, ORA-01403: no data found I checked for the application and it exists. Please suggest. Thanks in advance. Siddharth - Siddharth Shah Wed, 18 Nov 2009 12:32:52 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-6619 Hello Anil, Can we use fndload to migrate the concurrent programs from 11i ebs to R12 ebs. Thank you. - aryan Mon, 06 Jul 2009 09:53:11 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-6404 Hello, Can some one email me how to download and upload the KFF and Profile option definitions ! am not able to do that. Nishant - nishant Fri, 15 May 2009 03:04:09 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-6297 Hi, I want to download concurrent program along with executable and value sets (even custom ones). Can you please let me know the correct command? - Tina Tue, 28 Apr 2009 06:18:17 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-6294 You can download by specifying the Application Shortname , leaving the object name blank. You will have to do this for each lct file separately Thanks Anil Passi - Anil Passi Mon, 27 Apr 2009 15:37:32 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-6228 Hi, We want to transfer all the customized objects in fnd_top from one instnce to another because we are not copying fnd_top. Can you please help me out. Its very very urgent.. Thanks a lot - Annada Tue, 14 Apr 2009 11:09:37 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5930 Anil can you suggest me how to move fast formula from one bg to other in bulk - Parag gurjar Sat, 14 Feb 2009 01:25:16 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5310 Hi, I reply to the issue of Yann concerning the compiled_value_attributes. I understand you have infact two fields to populate in the compiled_value_attributes with the values Y and Y (that you have changed with N and N). To solve your problem, modify the ldt file replacing : 'Y Y' by : 'Y'||chr(10)|| 'Y' Then you can upload in the destination environment. Hope it can help you. Bye Cyril - Cyril Tue, 23 Sep 2008 05:09:01 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5094 Hi Shiraz, Another problem you will face is that input values will not be downloaded and uploaded via that lct file. Perhaps FNDLOAD is not ideal for what you are trying to achieve. You should also have a look at Oracle iSetup Thanks, Anil Passi - Anil Passi Sun, 10 Aug 2008 06:10:56 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5093 [b]Hi Anil,[/b] Thanks for you support. We have found the problem, its with the lct file as condition "BUSINESS_GROUP_ID is NULL " is hard-coded in it. We have a Business group defined. Please advice if we can change the condition in lct & Download from UAT instance & Upload to Production instance... Thanks again, [b]Shiraz[/b] - Shiraz Sun, 10 Aug 2008 05:29:19 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5091 Hi Anil, Many thanks for the quick response. select * from PAY_ELEMENT_TYPES_F where element_name like 'test1' O/p gives 1 record But FNDLOAD apps/**** O Y DOWNLOAD $PAY_TOP/patch/115/import/pypett.lct test1.ldt PAY_ELEMENT_TYPES E_ELEMENT_NAME="test1" Gives no data in ldt file, when substituted E_ELEMENT_NAME with ELEMENT_NAME is the above FNDLOAD command, it gives some data but not for "test1" Please advice ... - Shiraz Sun, 10 Aug 2008 04:40:37 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5090 Try the below [quote]FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $PAY_TOP/patch/115/import/pypett.lct XX_ELEMENT_TYPE_NAME.ldt PAY_ELEMENT_TYPES E_ELEMENT_NAME="ELEMENTNAMEHERE"[/quote] - Anil Passi Sun, 10 Aug 2008 03:57:51 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5089 [b]Hi Anil,[/b] Plese can you give the syntax for Downloading Element Types with Input Values using FNDLOAD. Please if you can help us ASAP, I shall be greatful to you. [b]Thanks, Shiraz[/b] - Shiraz Sun, 10 Aug 2008 03:35:37 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5082 Hi Anil, I'm getting the error: "An entity must be specified for the download operation." when running this command: $FND_TOP/bin/FNDLOAD apps/***** 0 Y download $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='HUICX' DATA_SOURCE_CODE='HUICXDELEGRPT' I tried with double quotes and no quotes as well. Can you see a problem? Thanks, Elaine - Elaine Fortin Fri, 08 Aug 2008 16:30:18 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5037 No I haven't But you can cd to $MODULE_TOP/patch/115/import/ and grep for collection tables within lct files. Thanks, Anil Passi - Anil Passi Sat, 02 Aug 2008 01:37:02 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-5035 Hello Anil, Have you done the FNDLOAD for collection elements and collection plans? Can we use FNDLOAD for this? Can you give an example? Your advise is greatly appreciate here. Thanks in Advande - TUAN Fri, 01 Aug 2008 16:44:24 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-4938 Hi Ram Have a look at this link [url]http://apps2fusion.com/apps/oa-framework/14-fwk/215-move-oa-framework-personalizations-from-one-environment-to-another[/url] Thanks, Anil Passi - Anil Passi- Wed, 16 Jul 2008 14:49:36 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-4937 To move OAF Personalizations, do this 1. Login to Functional Administrator responsibility 2. Navigate to Personalization tab, and within that Import Export Ensure that &#xRo;ot
i;r% profile is set to a valid directory on mid-tier Thanks Anil Passi - Anil Passi- Wed, 16 Jul 2008 14:38:23 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-4936 Hi, Can FNDLOAD be used to migrate OA Framework Personalizations also? Pl. let me know, if there is any others way of migrating these from one instance to another. Thanks Ram Balasubramanyan - Ram Balasubramanyan Wed, 16 Jul 2008 13:13:35 +0100 http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-4820 Cheers Prabhakar, for sharing this, as it is a common practice to download just one single DFF structure. - Anil Passi Mon, 30 Jun 2008 08:21:04 +0100