Comments for Oracle FNDLOAD Script Examples at http://www.apps2fusion.com , comment 1 to 142 out of 20 comments http://www.apps2fusion.com Tue, 07 Feb 2012 19:07:11 +0100 FeedCreator 1.7.3 http://www.apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-9598 We are using OM_POST_BOOK_EVENT for writing personalization on sales order form post booking. When we try to create LDT, this record is skipped. When we changed it to seeded (LOV) like when_new_form_instance or when_new_block_instance, it gets extracted in LDT file. Any idea what needs to be done? Is this an issue with FNDLOAD with custom events? - sachinpy Fri, 01 Jul 2011 05:31:40 +0100 http://www.apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-9169 Dear Anil, Thanks for the great explaination on FNDLOAD. As I understand using 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" we can upload Elements from one instance to another instance. Is ther a way to move Balance, dimensions,FF to move from one instance to another instance? Regards, Pranav Muley - Pranav Muley Fri, 25 Mar 2011 15:15:48 +0100 http://www.apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-8637 MigrationLogiK GUI is the tool which automatically generates all migration scripts including FND objects, Database Objects, XDOLoader and LIFFLoader. Database object can be immediately downloaded to your client machine. If you decide to use MigrationLogiK server listener, than EBS objects ( profile options, concurrent programs, value sets... ) can be downloaded by simple click of a button to your client machine. http://migrationlogik.com - Josef Wed, 01 Dec 2010 18:20:07 +0100 http://www.apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples#comment-8293 Hi There is a requirement like below mentioned:- Can anyone please suggest how we can procced on this. There will be an automatic program created in the loca Oracle applications instance. This program will take care of the following. 1. Download of concurrent programs : Based on the input concurrent program name, this program will create an ldt file. 2. Upload of concurrent programs : Accepting an ldt file name, this program will create a new concurrent program in the same instance - Vishal Wed, 01 Sep 2010 03:37:40 +0100 http://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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://www.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