Main Menu
| Home |
| Technical Articles |
| Training Articles |
| Receive Email for New Articles |
| Contributors |
| Hands-On-Training |
| Apps Book |
Related Items
Technical Articles Oracle Apps Scripts Oracle FNDLOAD Script Examples Also see here fully verifiable feedbacks/testimonials
| Oracle FNDLOAD Script Examples | | Print | |
| Written by Anil Passi | |
| Sunday, 27 August 2006 | |
|
PLEASE USE THIS LINK FOR FNDLOAD ON APPS2FUSION.COM In this article I wish to give real working examples of Oracle's FNDLOAD utility. I have used FNDLOAD successfully in past for several different entities/data types within Oracle 11i for almost all my previous clients, ever since this utility became available. ## You can also move the User definitions from FND_USER ---------------------------------------------------------------------------------------------------------------------------- Comments
(104)
 written by Anil Passi , December 09, 2006
Hi Vishal
The dates or rather the entire RowWho information will be passed in fromm Source System, i.e. whatever is in the ldt file. Open the lct file by doing vi $FND_TOP/patch/115/import/afffload.lct search for string fnd_flex_loader_apis.up_desc_flex In the parameter last_update_date you can pass sysdate, replacing the value read from ldt file Please note this is customization and is not supportable The reason value sets were not included is because they always get downloaded or uploaded along with Flexfield Segments or Conc Program Parameters. But anyway, please find the script for FNDLOAD of value set $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_SSHR_01_ETH_VALUE_SET.ldt VALUE_SET FLEX_VALUE_SET_NAME=XX_HRMS_ETH_ORIGIN Thanks, Anil Passi written by Anil Passi , December 09, 2006
Hi Vishal
The dates or rather the entire RowWho information will be passed in fromm Source System, i.e. whatever is in the ldt file. Open the lct file by doing vi $FND_TOP/patch/115/import/afffload.lct search for string fnd_flex_loader_apis.up_desc_flex In the parameter last_update_date you can pass sysdate, replacing the value read from ldt file Please note this is customization and is not supportable The reason value sets were not included is because they always get downloaded or uploaded along with Flexfield Segments or Conc Program Parameters. But anyway, please find the script for FNDLOAD of value set $FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_SSHR_01_ETH_VALUE_SET.ldt VALUE_SET FLEX_VALUE_SET_NAME=XX_HRMS_ETH_ORIGIN Thanks, Anil Passi
Hi Anil,
I used FBNDLOAD to donload/upload the ldt for Request Set & its Links. I am sucsessful to download the Request Set & its Links from one instance, but the upload to another instance gives error as follows: --------------------- Uploading from the data file XX_THA_GLDOIUPR_REP_DEF.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u02/appluat/uatappl/fnd/11.5.0/patch/115/import/afcprs et.lct(115.26), XX_THA_GLDOIUPR_REP_DEF.ldt) to stage tables Dump LCT file /u02/appluat/uatappl/fnd/11.5.0/patch/115/import/afcprset.lct(115. 26) into FND_SEED_STAGE_CONFIG Dump LDT file XX_THA_GLDOIUPR_REP_DEF.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (REQ_SET SQLGL XX_THA_GLDOIUPR_REP , STAGE_PROG 10 ) into FND_S EED_STAGE_ENTITY Upload from stage tables Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = SQLGL, REQUES T_SET_NAME = XX_THA_GLDOIUPR_REP, STAGE_NAME = 1, SEQUENCE = 10, ORA-01403: no data found --------------------- Could you please advice urgently. Thanks & Regards, Vikram Unde written by Anil Passi , January 12, 2007
Hi Vikram,
The most likely cause of ORA-01403 during FNDLOAD is that Custom Application defined in your dev environment does not exist on other environment. Hi Minal, I am sorry for the late response to your urgent query, I had a busy day at work today. For your concurrent program, the parameters must be downloaded by default. Please email me the lct file you are using. Has anyone modified the afcpprog.lct in your environment? Check if its version differs from other environment. Or email me your lct Thanks, Anil Passi written by Anil Passi , January 18, 2007
.
. . Hi Ruma, Link http://oracle.anilpassi.com/fi...grams.html should answer your question, though partially. Which application did you attach this Request Set to? It is possible that the Request Group against all those responsibilities includes the Application which is attached to your Request Set. Thanks, Anil Passi written by siddh , January 19, 2007
Hi,
We have customized dashboard functionality in telesales. We have to move it into other instances. can you let me know how to do the download for profile check variables, profile checks, drilldown for profile checks using FNDLOAD. The lct file used is cscprfbk.lct and cscprfck.lct written by Anil Passi , January 20, 2007
Hi Ruma,
I need to know the APPLICATION to which this request set is attached? Not the responsibility. Query the Request Set from Request set definition screen and see which application is that attached to. I think the APPLICATION associated with your request set is included in most of your request groups. If so is not the case, then you need to raise Tar. Although, I very much doubt this being a bug. Thanks, Anil written by Anil Passi , January 20, 2007
Hi Ruma,
I need to know the APPLICATION to which this request set is attached? Not the responsibility. Query the Request Set from Request set definition screen and see which application is that attached to. I think the APPLICATION associated with your request set is included in most of your request groups. If so is not the case, then you need to raise Tar. Although, I very much doubt this being a bug. Thanks, Anil written by siddh , January 22, 2007
Hi Anil,
Can you send one example to load telesales dashboard objects like profile variables and drilldown using FNDLOAD? Thanks. -Siddh written by Anil Passi , January 23, 2007
Hi Siddh
I think you need to open the lct file , and see the key parameters in DOWNLOAD section Also see the UPLOAD section of lct, as that will have the API calls,with parameters mapped to ldt values. This will give you the idea of the attributes that can be migrated. Thanks, Anil Passi written by Venugopal , January 26, 2007
Hi Anil,
I want to migrate Lookup types with their values from one instance to another. The FNDLOAD with download and upload runs fine for me. But there is no data in the ldt file. There are around 1500 lookup values for a particular lookup type but when I upload it says no data to upload. Checked the ldt file it shows only the lookup type definition. Request you kindly help at the earliest Thanks and Regards Venugopal written by Venugopal , January 28, 2007
Anil,
Thanks for your quick response. I have changed the lookup_code field size to varchar2(250) but still facing the same issue. I am sending the config file to you (anilpassi@gmail.com). Request you to go through and suggest changes. Regards Venugopal written by Anil Passi , January 29, 2007
Hi Venu
Use the lct file from this link. See if this works http://www.anilpassi.com/apps/demo/wf/ic_aflvmlu.lct Thanks, Anil Passi written by Venugopal , January 29, 2007
Hi Anil,
Tried with the .lct file you provided but it is not working. What could be the issue? Please help. Regards Venugopl written by Nilesh , January 29, 2007
Hi Anil,
I have created one Oracle Alert in one environment and trying to migrate it to another environment. The original alert action details text has some formatting which is getting lost during upload. Can you suggest me how to maintain this text formatting? written by Anil Passi , January 31, 2007
.
. . Hi Nilesh, Interesting, I never moved alerts using fndload. But anyway, are you transferring the files in ascii mode? thanks anil written by Anil Passi , February 01, 2007
.
. . Hi Alexander, You need to do two things. 1. check if your ldt file has required information, to ensure download worked successfully. You must be able to locate each and every segment in the ldt file. 2. If your ldt file is OK, then check to see the log file that was created during upload. Are there any error messages in the log file? Thanks, Anil Passi written by rajitha , February 01, 2007
Hi Anil,
My requirement is to download the part of the menu not whole menu. Is there any option we can set while downloading menu to down load based on sequence no or function name or by prompt name. From metalink I found following example CUSTOM_MODE=FORCE will upload any new items in the file that do not currently exist in the database UPLOAD_MODE=REPLACE will replace any current values with the values in the file Unix command is FNDLOAD apps/apps_pwd@oracle_sid 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $MSC_TOP/patch/115/import/US msctop.ldt - WARNINGS=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE Thanks! Rajitha written by Chandrasekar , February 02, 2007
Please update this article by including examples of using Isetup for transferrring setup data. Pl give how to access this responsibility and are there any profiles to be taken care of
written by Anil Passi , February 02, 2007
Hi Rajitha
I have never tried doing this on a specific Function for Menus. You can either restrict the fndload to a sub menu OR if you know precisely what menu entries you want, then simply edit the ldt file and remove the unwanted entries. **Pls test this on other instance, I think it should work, because I can see that lct file is calling fnd_menu_entries_pkg.LOAD_ROW for the Menus available in ldt file Thanks, Anil Passi written by Anil Passi , February 02, 2007
Hi Chandra
I am yet to use iSetup myself, as I think it does not cover every possible setup. Also, it appears to be based on linking different environments which involves admni activity, which I find to be a turn-off of getting this agreed with management any wonder why not many people use iSetup? written by Anil Passi , February 05, 2007
Excellent stuff Alexander.
written by Anil Passi , February 13, 2007
Hi BSR
Each data type like value set , flex value etc have a internal id generated by the sequence. If you do export and import, the value of the sequence used to generate unique key may differ in the two environments. This can cause overlap and conflicts Hence, use FNDLOAD, because FNDLOAD uses respective APIs thanks, anil written by Anil Passi , March 12, 2007
Hi Frank,
Please check the width of the columns mentioned in lct file. Possibly one of the column have less number of VARCHAR2(lenngth) than the corresponding length in the fnd_lookup_values
Hi Anil,
Journal import, when run for the first time, takes a lot of time to complete since it tries to create code combiantions for the first time. Is there an Oracle API/Script which can be used to pre-create code combinations (Like we have Generate Accounts program in FA) and which also takes care of cross-validation rules. Thanks. written by Florin , March 30, 2007
hello Anil,
i guess you have to run the fndload commands using the applmgr user on the machine holding the database for oracle apps. is there a way to run this fndload command using another user ? thanks written by Anil Passi , March 31, 2007
I think this should work, so long as fndload has execute permission for your login, and also your login has apps environment variables set, then it should work
thanks, anil written by Ashok , April 13, 2007
Hi Anil,
This page is very good and helps a lot. But i have one question, is there any way to rollback the ldt file which is uploaded. The reason is suppose if i have uploaded the ldt file (Concurrent Program with values) with wrong data, how can i rollback the ldt file. Thanks Ashok written by Ashok , April 13, 2007
Hi Anil,
This page is very good and helps a lot. But i have one question, is there any way to rollback the ldt file which is uploaded. The reason is suppose if i have uploaded the ldt file (Concurrent Program with values) with wrong data, how can i rollback the ldt file. Thanks Ashok written by Babu , April 19, 2007
hi anil,
I am using FNDLOAD to migrate a custom report from the test instance to the production instance. i am able to configure everything in the production system except the parameters of the report.i have used the sample scripts that are published in your site, can help me out please in configuring my report parameters from the test system to the prodution system. thanks in advance. Thanks & Regards, Babu. written by Anil Passi , April 20, 2007
Hi Babu
The scipt will download and upload the parameters too. Simply configure your parameters on DEV/TST, then download, and then upload on PRD Thanks Anil written by Satya , April 26, 2007
Hello experts,
I have a spreadsheet which has around 300-400 responsibilities and wanted to load into oracle tables. Does, anybody has any ideas what will the process involved these responsibilities from spreadsheet to oracle tables. Any ideas will be highly appriciated. -Satya written by Vishnu , May 09, 2007
API on Status change in Property Manager
written by Nagesh , May 23, 2007
Hi Anil,
My Request group which i would like to migrate has lot of other Programs added in that which are not available in Prod.Hence when i try migrating the whole request group, its throwing an error saying it could not find those programs. However i would like to migrate only one program from that request group onto production using FNDLOAD for reguest group. Could you please let me know if i could migrate only one(or couple) of concurrent progs from a request group using FNDLOAD. I tried filtering by a parameter UNIT_NAME in it, however it giving blank values for others and causing probs. Thanks, Nagesh written by Michu , May 29, 2007
Hi Anil,
Can you send some information about Oracle projects, am new to this module, I have to do costing conversions,project conversions Thanks written by Dhiman , June 03, 2007
Hi Anil,
Can we upload forms also using FNDLOAD utility? If yes, do we need to uploas Form and Form Function separately? Please advice. Thanks & Regards, Dhiman. written by Anil Passi , June 04, 2007
Hi Dhiman
If you download the menu, that will download both form and form function for you. To upload just the forms or form functions, kindly use the UPLOAD PARTIAL mode. Parameters for the entities are:- FORM ------- FORM_APP_SHORT_NAME FORM_NAME FUNCTION ----------- FUNC_APP_SHORT_NAME FUNCTION_NAME Thanks, Anil Passi written by Raj Naik , June 19, 2007
Hi Anil,
Raj again, i missed one point. What about XML Reports, i mean Data Definition & Templates? Thanks Raj Naik written by Raj Naik , June 19, 2007
Hi Anil,
Raj again, i missed one point. What about XML Reports, i mean Data Definition & Templates? Thanks Raj Naik written by Ashish Gairola , June 20, 2007
Anil,
I need one favor.Can we migrate Assign profile options and Asssign security rules using FNDLOADER written by Anil Passi , June 20, 2007
Hi
Migrating profiles by default will transfer all the values for that profile option set at all possible levels. With regards to Security profiles, please elaborate. Are you referring to the Rules to restrict Value set values? Thanks, AniL Passi
Hi anil,
Good to know about FNDLOAD and its functionalities. Mr. Anil can we use FNDLOAD to port reports from one environment to another. My requirement is to port reports from 11 to 11i. Thanks, Nagender  written by passianil , July 03, 2007
Hi Nag
You simply need to copy the rdf file into respective $MODULE_TOP/reports/US or some other relevant language directory thanks anil  written by nagender , July 03, 2007
Hi Anil,
Thanks for the quick reply.Bur sry, I did not get you, my requirement is to movie all the existing reports/custom reports in 11 environment to 11i(11.5.10.2) environment. How can we do this, Can it be done using FNDLOAD. Sorry, If I was not clear in my previous post. And also Mr.Anil, how can we preserve the customizations we made for forms or reports when we upgrade or migrate to a higher version. Thanks, Nagender
Hi Nag,
If you are moving concurrent program definition for the reports then of course you can use FNDLOAD. However if you are upgrading to 11.5.10, then upgrade process will retain your custom reports registered with custom application Thanks,
Hi Anil,
Iam in need of some information from you. I need to migrate the AOL data into an xl sheet, like all the concurrent program related data along with the parameters it uses and the value sets associated with it will be stored in one tab.In short what ever the data is generated by lct file in the ldt file i need it as an excel sheet.I have tried to convery the data in the ldt file into xl format but iam not successful.Now i am trying to use the lct file and work on the code available in lct file to get the work done. Can you please suggest me what would be the best way to capture all the AOL related data into an xl sheet or if there are any existing scripts available other that the .lct scripts to perform the job. Thanks, Pruthvi M.
Hi Pruthvi
Your second approach, of using SQL in lct file is the best approach. In every lct file, there is a DOWNLOAD section that contains SQL's used to extract data. You should use the same SQL as that in DOWNLOAD section of lct Thanks, Anil
Hi Anil,
thank ypu for script, it helps very much. I used it for upload fnd_new_messages, upload was succesful,i check table value, but when I start application, there is no change in prompt_text at all. It is still the old value. Thanks, Sandra
Hi Sandra
Please request your DBA to generate message files. That should fix the issue Thanks, Anil
Thank you Anil very much!
I generate message file throw adadmin, and it works for all applications except for fnd (for message name with start FND_SSO%). I have one more question: I also change description for language in table fnd_languages_tl- what should I do to see changes in application? Regards, Sandra
Hi Sandra,
Can you see the description reflected in fnd_languages_vl ? You can try this from SQL*Plus, ensuring that NLS for SQL Session is same as that for the responsibility being used to test the changes. Thanks, Anil Passi
Below are the commands to download & upload .ldt files useful for Alerts migration. As you know, one should use APPS or APPS_READ passwords in order to generate the .ldt files.
--DOWNLOAD from one instance-- FNDLOAD 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct ALR_ALERTS APPLICATION_SHORT_NAME= ALERT_NAME= --UPLOAD to another instance-- FNDLOAD 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct Best Regards, Kiks
hello Anil,
I am noving custom responsibilities that has custom Menus and functions. Do I need to FNDLOAD custom Functions and Menus before FNDLOAD custom Responsibility?
Hi Tuan
FNDLOAD for responsiblity will download for you things like security group, user group Hence you need to upload the MENU first using afsload.lct. When you FNDLOAD menu's, form funtions and form definitions attached to the menu's will also get FNDLOAD'ed Thanks Anil
Hi Anil,
When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen?
Hi Krishnab
If you are submitting the JournalImport programatically, then you must create a record in GL_INTERFACE_CONTROL. This is so, because the GL Import process, when called programatically, must be passed the interface_run_id as shown below v_conc_id := fnd_request.submit_request(application => 'SQLGL' ,program => 'GLLEZL' ,description => NULL ,start_time => SYSDATE ,sub_request => FALSE ,argument1 => v_interface_run_id ,argument2 => p_sob_id ,argument3 => 'N' ,argument4 => NULL ,argument5 => NULL ,argument6 => 'N' ,argument7 => 'W'); In case you are submitting GL Import from screen, then the screen will do the insert into gl_interface_control. Another purpose of this table is in case you wish to use a custom or some other table for GL Import, instead of gl_interface. One such example is that project accounting uses PA_GL_INTERFACE. Hence in this case, GL_INTERFACE_CONTROL.INTERFACE_TABLE_NAME will have a value of PA_GL_INTERFACE If you leave GL_INTERFACE_CONTROL.INTERFACE_TABLE_NAME as null, then gl_interface will become the source for importing the journals Thanks, Anil Passi
Hi Anil,
In Oracle12i they introduced LEDGER_ID instead of SET_OF_BOOKS_ID,means is it same as SET_OF_BOOKS_ID or any other use?
Hi Anil,
In Oracle12i they introduced LEDGER_ID instead of SET_OF_BOOKS_ID,means is it same as SET_OF_BOOKS_ID or any other use?
Hi Anil,
We can extract the data from in 2 ways. 1.Useing UTL File 2.Useing Spool From above 2 which one is the usefull and preferable?
Hi,
I want to migrate Element,Fast Formula and setup to production Env from development env. Can I migrate Element and Fast Formula using FNDLOAD, If you can provide sample script for the above(FF,Element,Setup Payroll)I will be greatful to you. Thanks Anita
Hi Anita,
For moving the fast formulas from one environment to another, please use Fast Formula Assistant. You can also search on Metalink for Fast Formula Assistant Metalink Note is 435765.1 For elements, there are two lct files that I can see on my environment. --For transferring element types $PAY_TOP/patch/115/import/pypett.lct --For transferring Element Input Values $PAY_TOP/patch/115/import/pypivt.lct Note: Please test these lct files before usage, as I am yet to use these loader files myself Thanks, Anil Passi
Has anyone encounterd this problem. I'm currently at a new project and I'm trying to use fndload to download my concurrent program definitions. I specify the
ENTITY = PROGRAM and the two parameters APPLICATION_SHORT_NAME and CONCURRENT_PROGRAM_NAME but I keep getting the message below in my log file: An entity name must be specified for the download operation
Hi Marco
To download, you do not need to specify the ENTITY FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXGMS" CONCURRENT_PROGRAM_NAME="XX_CUSTOM_ORACLE_INTERFACE_PROG" Thanks, Anil Passi
Hi Anil,
Is is posible to download the ldt files of concurrent programs without the values of independent valuesets? Thanks & Regards, Dilee
Hi Anil
can we use FNDLOAD to transfer Transaction Type set up IN AME/OAM. also,could you guide us to create new lcts. Regards Ankur
Hi Anil,
How can we move XML publisher reports, Templates and Data definitions? thanks Siva  written by Vishal Goyal , October 19, 2007
Hi Anil,
Is there a way to transfer setups like JE Sources/Categories/Security Rules from Instance A to Instance B. We have huge many setups in GL and want to xfer them, rather then using data loader to load them again manually. I have DFFs as well on sources/categories. Thanks. Vishal.
Hi Siva
XML Publisher stores the metadata and physical files for templates and data definitions in BLOB columns in its schema. XML Publisher allows you to use FNDLOAD in conjunction with XDOLoader to allow you to move the metadata and physical files for your templates and data definitions from one instance to another. FNDLOAD can --------- Upload and download the data definition information and the template metadata XDOLoader can ------------- Upload and download the physical files like (RTF, PDF, XSL-FO, XML, and XSD) For complete details, see page 251 onwards from the link below http://download-uk.oracle.com/docs/cd/B40089_02/current/acrobat/120xdoig.pdf Hi Vishal, See the latest documentation of Oracle iSetup. The version I have can transfer the following for General Ledger Sets of Books Chart of Accounts Statistical Units of Measure Account Code Combinations Accounting Calendar Currencies Thanks, Anil Passi  written by vinayaksawal , October 23, 2007
Hi Anil,
First of all we appreciate your dedication towards the APPS community. i am strong follower of your portal I have one question My question may be bit wierd for you. I need to move all the FND objects from one instance to another in one shot is it possible? and also to that i need whichever are present on the destination sever should not get overlapped.? Can you please suggest your expertise ? Cheers, Vinay
Hi Vinay
Take a copy of each lct file and rename those as xx. In the upload section, you will find the API calls or update statements. You can modify that section to include an IF statement before each API Call. This IF Statement will check the existence of the object in destination instance prior to APIs being invoked. Next use these xx...lct files to upload. I can't see any existing parameter in FNDLOAD controller files, to meet your requirements out of the box. Do proper testing too. Thanks, Anil Passi  written by Deepthi J , October 25, 2007
If it is using Fast Formula Assitant please let me know the process.
Hi Deepthi
I am pasting this straight from Metalink Note 435765.1, as below Applies to: Oracle Payroll - Version: 11.5.10 Information in this document applies to any platform. Goal How do you set up FastFormula Assistant (new functionality in HRMS Family Pack K ) ? Solution Here are the steps: 1) Add the following menus Cross-Business Group Home Page FastFormula Assistant Home Page to a suitable point in the SHRMS Navigator menu tree. Responsibility : System Administrator Navigation : Application > Menu NOTE : We DO NOT provide a prompt for these submenus. These menus are needed only to give the appropriate permissions for all the functions below each menu. 2) Add the following functions FF Assistant Cross-Business Group Search Page FF Assistant Search Page to the SHRMS BASIC menu giving an appropriate prompt for each function (i.e. Global FastFormula Assistant and FastFormula Assistant). Responsibility : System Administrator Navigation : Application > Menu 3) Ensure the 'FastFormula Transaction Manager' concurrent manager is running on your environment. Log in as System Administrator Concurrent > Manager > Define Query back FastFormula Transaction Manager Is Enabled Checkbox ticked ? If not can you :- a) Check Enable checkbox b) Save changes c) Activate Manager :- 1) Navigation : Concurrent > Manager > Administer 2) Query back Fast% (there should be 1 or more processes). 3) Click on Activate if FastFormula Transaction Manager not already running Thanks, Anil Passi written by Deepthi J , October 25, 2007
Hi Anil,
Followed the steps and setted up the fast formula assistant,but i am not able to upload the fast formula.I am able to download the Fast formula but not able to upload the formula.If you know the process and if can explain me the same that would be of great help. Thanks Deepthi
Hi Anil
I want to pass application short name as parameters for this afscursp.lct some of the entities like fnd_user etc... did't have application table. so how can i pass application short name as parameter for this afscursp.lct file. Plese give me advise. Thank you. RamaChandra.N Please give me suggestions.
Hi Rama
Please visit http://oracle.anilpassi.com/fndload-a-dive-into-basics.html for the answer to your question. The presentation explains that concept. Thanks Anil Passi
Hi Anil,
I have a sample code of downloading the valuesets,concurrent programs and Request Groups using FNDLOAD. In the request area...in old sample code they had used UNIT_TYPE and UNIT_NAME....what these are related to. Kindly Clarify... Ramya
I have a requirement
I have created a concurrent program, which has parameters like cost centre number(using DFF valuesets). I want to move the concurrent program from TEST to production, but i do not want the dff values from Test to overwrite the values in Production. Is there some way we can down load only the vlaue set name in ldt file for Concurrent progtrams not the values.
Hi Punit
Have a look at presentation in http://oracle.anilpassi.com/fn...ics-2.html That will help you find the answer yourself. Thanks, Anil Passi
Hi Anil
I am Trying to upload Responsibilities individually by using FNDLOAD. But, it giving error like Uploading from the data file xxbmc_bcm_responsibility.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44), xxbmc_bcm_responsibility.ldt) to stage tables Dump LCT file /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44) into FND_SEED_STAGE_CONFIG Dump LDT file xxbmc_bcm_responsibility.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (FND_APPLICATION BMCSREV , FND_RESPONSIBILITY BMCSREV BMC_COLLECTIONS_MANAGER ) into FND_SEED_STAGE_ENTITY Upload from stage tables Error loading seed data for FND_RESPONSIBILITY: APPLICATION_SHORT_NAME = BMCSREV, RESP_KEY = BMC_COLLECTIONS_MANAGER, ORA-20001: APP-FND-01572: Invalid foreign key data was found for this record. Value CL_BMC_COLLECTIONS_MANAGER for column MENU_NAME does not exist in table FND_MENUS_VL. Please give me solution. Thank you. Regards Ramchandra.N
Hi anil
I am trying uploading menus individually. but it giving error like Please give me solution for these error. Uploading from the data file xxbmc_401_menu.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59), xxbmc_401_menu.ldt) to stage tables Dump LCT file /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59) into FND_SEED_STAGE_CONFIG Dump LDT file xxbmc_401_menu.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (MENU *NULL* , MENU 401K MAINTENANCE ) into FND_SEED_STAGE_ENTITY Upload from stage tables Error loading seed data for FORM: APPLICATION_SHORT_NAME = BMCS, FORM_NAME = BMCS401K, ORA-01400: cannot insert NULL into ("APPLSYS"."FND_FORM"."APPLICATION_ID") ORA-06512: at "APPS.FND_FORM_PKG", line 23 ORA-06512: at "APPS.FND_FORM_PKG", line 277 ORA-01403: no data found Error loading seed data for FORM: APPLICATION_SHORT_NAME = BMCS, FORM_NAME = BMCSLOAN, ORA-01400: cannot insert NULL into ("APPLSYS"."FND_FORM"."APPLICATION_ID") ORA-06512: at "APPS.FND_FORM_PKG", line 23 ORA-06512: at "APPS.FND_FORM_PKG", line 277 ORA-01403: no data found and another one is Uploading from the data file xxbmc_ar_menu.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59), xxbmc_ar_menu.ldt) to stage tables Dump LCT file /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59) into FND_SEED_STAGE_CONFIG Dump LDT file xxbmc_ar_menu.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (MENU *NULL* , MENU AR_CONTROL_GUI ) into FND_SEED_STAGE_ENTITY Upload from stage tables
Hi Ramchandra,
Please run this SQL in the destination environment. Does this return a record? Perhaps you haven't yet setup this custom application on the destination environment. select application_id from fnd_application where application_short_name = 'BMCS'; Thanks, Anil Passi
Hi Anil,
We are trying to do the upgrade from 11.0.3 to 11.5.10.2 (Financials). How simply can we upgrade or migrate the "Custom responsibilities/ menus (include and exclude) to the 11i environment ? Is there a script available or is it part of the upgrade process. Your help is very much appreciated.
Hi Anil
I am Trying to upload Responsibilities individually by using FNDLOAD. But, it giving error like Uploading from the data file xxbmc_bcm_responsibility.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44), xxbmc_bcm_responsibility.ldt) to stage tables Dump LCT file /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44) into FND_SEED_STAGE_CONFIG Dump LDT file xxbmc_bcm_responsibility.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (FND_APPLICATION BMCSREV , FND_RESPONSIBILITY BMCSREV BMC_COLLECTIONS_MANAGER ) into FND_SEED_STAGE_ENTITY Upload from stage tables Error loading seed data for FND_RESPONSIBILITY: APPLICATION_SHORT_NAME = BMCSREV, RESP_KEY = BMC_COLLECTIONS_MANAGER, ORA-20001: APP-FND-01572: Invalid foreign key data was found for this record. Value CL_BMC_COLLECTIONS_MANAGER for column MENU_NAME does not exist in table FND_MENUS_VL. Please give me solution. Thank you. Regards Ramchandra.N
Hello Anil,
I find your site very useful. Really worth going thru all the blogs and articles. My question to you is: We have implemented 11.5.10.2. In one of our Development instances ( clone of Production instance) we have created several Menu's and Responsibilities. While creating the Menu's we have given 10, 20 , 30 , 40 ... and so on ... as the Sequence Number in the Define Menu's form. When we have FNDLOAD the same Menu's in the production instance the Sequence Number changed from 10, 20, 30 , 40 ..... to 1,2,3,4. Why this has happened. Thanks, Sanjib Kundu Jamshedpur, INDIA
Hi Anil,
Following are my questions.Hope I get answers: 1. When a concurrent program is downloaded, is EXECUTABLE not required to be downloaded too? or it is created automatically or manually has to be created?? 2. Can FNDLOAD delete program once created (but not yet run)?? Thnks for this inforamtive site Nitin 
Hi,
We have the same I want to override the existing Menu's in the 1st instance with the new menu from the 2nd instance. But on a normal FNDLOAD upload it appends to the existing menu items. Is there any option by which i can upload without deleting the submenu's on the table level and do it from the FNDLOAD itself ?
While Transferring Cocurrent programme through FNDLOAD,will it transfer the value set with that.If not how that can be achived.
Thanks & Regards Vinay
Hi anil I am uploading menus by useing fndload.
While uploading i am getting log files. 1)Uploading from the data file /u001/app/applmgr/ftp/xxbmc_menu_24_BMCSREV_OE _USER.ldt Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59), /u001/app/applmgr/ftp/xxbmc_menu_24_BMCSREV_OE _USER.ldt) to stage tables Dump LCT file /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59) into FND_SEED_STAGE_CONFIG Dump LDT file /u001/app/applmgr/ftp/xxbmc_menu_24_BMCSREV_OE _USER.ldt into FND_SEED_STAGE_ENTITY Dumped the batch (MENU *NULL* , MENU BMCSREV_OE _USER ) into FND_SEED_STAGE_ENTITY Upload from stage tableswhere logon is username/password[@connect] mode is UPLOAD, UPLOAD_PARTIAL or DOWNLOAD configfile is the configuration file datafile is the data file entity is an entity name, or - to specify all values in an upload param is a NAME=VALUE string used for parameter substitution batch_id is batch id Please give me solution for this. thank you. Regards Ramachandra.N
hi anil,
i want information about tuning in RICE cpmponents.plse Please give me solution for this. Thanks and Regards Prabhakar
Can u please provide anything related to Lookup type which is missing in this how to download or upload lookups.
Hi Anil,
please provide detailed information regarding backing up of request sets and trading partner setups Thanks Ramanath Kamath
Hello Anil,
How to use in the case of Multilingual Concurrent programs. Means from english to diffirent languges. Thanks & Regards, Amresh
Hi all ,
How do i download EIT's. Thanks , Rahul
Hi Rahul
HRMS EIT is a DFF. Please use the DFF Syntax on FNDLOAD Thanks, Anil Passi
Hi Anil,
This page is very good and helps a lot. But i have one question I have created one workflow notification in one environment and trying to move it to another environment. Can you suggest me how to move this notification? Regards -------- madhu
Hi Madhu
Please use WFLOAD command to upload your workflow wft file to other environments. Please search metalink for wfload syntax Thanks, Anil Passi
I only want to migrate one concurrent program from one instance to another.
I used fndload to download one concurrent program and the .lct file seems to contain every definition for the custom application shortname. I am hesitant to upload it FNDLOAD apps/apps002 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct 29599_p rog.ldt PROGRAM APPLICATION_SHORT_NAME="TFND" CONCURRENT_PROGRAM_NAME= "Tupperware DBA Rebuild Indexes"
Hi Jim
You are passing the full name of concurrent program. It should instead be the short name of the concurrent program. Hence it will be something like CONCURRENT_PROGRAM_NAME= "TUPPERWARE_DBA_REBUILD" As per your FNDLOAD command, currently all your concurrent programs belonging to application TFND will be downloaded. Passing the short name of concurrent program will resolve this issue. Thanks, Anil Passi
Anil,
Can you please provide me any FNDLOAD scripts that I can use to download and upload the Chart of Accounts' value set values. Thanks/
Anil,
Do you have an example for "afffload.lct" file? I am having a problem with the syntax for Qualifer segment values held in COMPILED_VALUE_ATTRIBUTES. When I download the value set, the output for this attribute is as follows... COMPILED_VALUE_ATTRIBUTES = "Y Y" If I change this to COMPILED_VALUE_ATTRIBUTES = "N N" for a particular value, and FNDLOAD in UPLOAD mode, it doesn't make any changes. Any ideas as to what the syntax should be to change the values of "COMPILED_VALUE_ATTRIBUTES"? Thanks
Hi,
I generated message file throw adadmin for ICX module and I've got next messages: "No Oracle Message files selected for generation". Message files for other modules can be generated successfuly and I have a problem only for this one. What could be a cause? And is there a solution? Tnx in advance! Natasa
Hi Folks,
I am using FNDLOAD utility to migrate the req sets from one instance to another. But the req sets are not being updated, after the first time. I mean if i make any changes to req set in dev, then download the req set using FNDLOAD and migrate the same to UAT and upload it. The new changes are not reflected. Am i missing any steps here!! please help. I am also trying by using FORCE for uploading. for dowload this is the command i used: FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_DEF.ldt REQ_SET REQUEST_SET_NAME="FNDRSSUB1992" FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_LK.ldt REQ_SET_LINKS REQUEST_SET_NAME="FNDRSSUB1992" For upload this is what i used. FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_DEF.ldt FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_LK.ldt Thanks.
Hi Anil,
I have uploaded the FNDLOAD to upload the DFF. It has created the DFF but not DFV view. How can we generate it or migrate it ? Thanks You must be logged in to a comment. Please register if you do not have an account yet.
|
Subscribe to this comment's feed
I tried the command again. I was missing single quotes around APPLICATION_SHORT_NAME and hence was giving me an error. Now it worked fine.
One question. When I uploaded the DFF,
Created By:
Creation Date
Updated By:
Update Date:
same as Updated By:
Update Date:
from the instance from which i downloaded the information.
Is there a way to show the sysdate as creation date ?
1nd Question, I could not find a script above for migrating value sets with the data for them as well. Can you add a script for this.
Thanks for the wonderful scripts.
Vishal.