Apps - FNDLOAD for Oracle Web ADI

Default screen resolution

Wide screen resolution

Increase font size

Decrease font size

Default font size

Skip to content

Default color

Pink color

Green color

Green color

Main Menu

Technical Articles

Oracle Workflows

Training Articles

Receive Email for New Articles

Hands-On-Training

Related Items

Technical Articles

Oracle Workflows

FNDLOAD for Oracle Web ADI

We are glad to announce the launch of Forum for Customizations and Extensions. Click here to visit http://apps2fusion.com/forums This website has now moved to http://apps2fusion.com

Our OA Framework, BPEL Development & Apps DBA Trainings from USD 299 only [on weekends] . Click here for details.
Also see here fully verifiable feedbacks/testimonials

FNDLOAD for Oracle Web ADI

Written by Anil Passi
Tuesday, 07 November 2006
This article is dedicated for usage of FNDLOAD for Web ADI Question : Does this article cover FNDLOAD in general? Answer : This article is dedicated to the usage of FNDLOAD for Web ADI. If you wish to fndload entities other than Web ADI, then kindly visit link Fndload for common utilities. Question: Why does one need to use FNDLOAD FOR WEB ADI? Answer : In any implementation that uses Web ADI, the setup for formatting letters and docments can be overwhelming. More importantly, once configured on a development environment you would not like to repeat the tedious setup on test, crp or other environment. Using FNDLOAD you can migrate 99% of your setup. Question : What are the man steps when using FNDLOAD for Web ADI? Answer : First step Identify the pieces that must be moved across using fndload. These can be:- Integrators Layouts Mappings Contents This article covers the above listed components one by one. Second step Download the above web adi attributes into various ldt files. Basically we will create one ldt file for each of the above four web adi entities. Third step Upload those ldt files into the new environment. For this we will run the fndload in upload mode. Question: How do I execute Step 1, given that FNDLOAD requires the internal names of these entities, these internal names are not visible from the Web ADI screens? Answer: In this example,I will demonstrate using scripts how to recognize the web adi components Names for fndload. SQL will be provided to identify the internal names. Question : Please demo how to FNDLOAD Integrators in Web ADI Answer : To identify the integrator codes, run the below SQL. SELECT integrator_code, application_id FROM bne_integrators_vl vl WHERE user_name IN ('XX Request for further references', 'XX Sorry Interview did not work') ; This will return two internal codes, both in application PER (Application ID 800). Lets say the two internal codes are HR_101_INTG & HR_41_INTG. Now download these as below:- FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bneint.lct XX_HR_101_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="PER" INTEGRATOR_CODE="HR_101_INTG" FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bneint.lct XX_HR_41_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="PER" INTEGRATOR_CODE="HR_41_INTG" In order to upload these FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bneint.lct XX_HR_101_INTG.ldt FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bneint.lct XX_HR_41_INTG.ldt Question : Please demo how to FNDLOAD Layouts in Web ADI Answer : To identify the layout codes codes, run the below SQL. =====Find the Layouts from layout names===== SELECT LAYOUT_CODE FROM bne_layouts_vl vl WHERE user_name IN ('Offer Letter for Job', 'Denial of Job') ============== Above SQL can return values say XX_C_O_F_T & XX_CODE To download these layouts FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct XX_C_O_F_T.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="XX_C_O_F_T" FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct XX_CODE.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="XX_CODE" Now in order to upload these into new environment, use below commands FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnelay.lct XX_C_O_F_T.ldt FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnelay.lct XX_CODE.ldt Question : Please demo how to FNDLOAD mappings in Web ADI Answer : To identify the mapping codes, run the below SQL. =====Find the MAPPING CODES from integrator names== SELECT mapping_code, integrator_code FROM bne_mappings_vl WHERE integrator_code IN (SELECT integrator_code FROM bne_integrators_vl vl WHERE application_id = 800 AND user_name IN ('XX HR Reference letter', 'XX HR Sorry Cant offer')) ORDER BY last_update_date DESC; Lets say this SQL returns HR_101_MAP & HR_86_MAP --Now do the download FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnemap.lct XX_HR_101_MAP.ldt BNE_MAPPINGS MAPPING_ASN="PER" MAPPING_CODE="HR_101_MAP" FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnemap.lct XX_HR_86_MAP.ldt BNE_MAPPINGS MAPPING_ASN="PER" MAPPING_CODE="HR_86_MAP" To upload these files into a new environment, ftp the ldt files and run below commands on the new environment FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnemap.lct XX_HR_101_MAP.ldt FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnemap.lct XX_HR_86_MAP.ldt Question : Is FNDLOAD of Web ADI contents similar to above? Answer : Its slightly different, as to recognize the contents I had to use the date range to pick all the content codes configured in Web ADI during the past 90 days. ===================== SELECT CONTENT_CODE FROM bne_content_cols_vl WHERE last_update_date > SYSDATE - 90 group by CONTENT_CODE ; ===================== CONTENT_CODE -------------- HR_101_CNT HR_41_CNT For each content code returned by SQL above, we will now do FNDLOAD as below FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnecont.lct XX_HR_101_CNT.ldt BNE_CONTENTS CONTENT_ASN="PER" CONTENT_CODE="HR_101_CNT" FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/admin/import/bnecont.lct XX_HR_41_CNT.ldt BNE_CONTENTS CONTENT_ASN="PER" CONTENT_CODE="HR_41_CNT" Obviously to upload Web ADI contents, use the below commands FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnecont.lct XX_HR_101_CNT.ldt FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnecont.lct XX_HR_41_CNT.ldt Comments (12) Subscribe to this comment's feed ... written by Lee Kirwan , December 20, 2006 When I performed a download on the FNDLOAD with WEBADI all the information downloads successfully. When I upload the information to the new environment the integrator and the layout do not seem to be linked when I try to export data. Do you know the reason for this? The FNDLOAD does not seem to work 100%. Can some one please help? ... written by Lee Kirwan , December 20, 2006 When I performed a download on the FNDLOAD with WEBADI all the information downloads successfully. When I upload the information to the new environment the integrator and the layout do not seem to be linked when I try to export data. Do you know the reason for this? The FNDLOAD does not seem to work 100%. Can some one please help? ... written by sreenivasula reddy , January 16, 2007 The FNDLOAD for Oracle web ADI is exalent ... written by sreenivasula reddy , January 16, 2007 The FNDLOAD for Oracle web ADI is exalent ... written by Anil Passi , March 01, 2007 Hi praveen The reports are not loaded into the database, hence no FNDLOAD is needed for those. All you need to do is to use FNDLOAD for is to load things into database, like menu definitions, messages, responsibility definition etc. for a report with executable name POPRINT.rdf it will most likely be copied to $PO_TOP/reports/US Thanks anil ... written by Praveen , March 01, 2007 Hi Anil, Can you please help me on FND_LOAD. Suppose I want to put back a customised report in the appropriate custom folder in apps, how do I invoke FND_LOAD? can you give an example. Please help me on this. p.s.: i dont know if i have place my query in the appropriate thread. so please send me an email if you cant answer it here. ... written by Praveen , March 05, 2007 Hi Anil, Thanks for the reply. I think I am pretty clear about this now. Regards, Praveen ... written by Ashokkumar , June 21, 2007 Would like to have guideline for WebAdi, mainly on, - Involvement of Technical professional - Architecture/table/column knowledge required? - Pre-requisite ( if any ) - Difficulties, Issues faced - Path/method to utilize webadi for different instances to upload data Would like to know, the path to work out with Webadi for success for multiple instances. There can be two alternatives, either to enter data for a instance or to use webadi to upload data from .xls file. For using webadi, person should know the table/columns of modules/functionality? Can a functional consultant able to upload data from .xls file to Apps? Looking for your advice/guidance... ... written by subbareddy , September 24, 2007 hi anil, iam new person to apps.so can u explain how to use fndload program,lct file etc........ ... written by subbareddy , September 24, 2007 hi anil, iam new person to apps.so can u explain how to use fndload program,lct file etc........ waiting for ur reply. thank u. Restricting currencies in Web ADI Template written by Vishal Goyal , October 20, 2007 Hi Anil, I want to create a WEB ADI template and want to restrict the LOV on currency to certain specific currencies only - do not want all enabled currencies in the LOV. Is it possible using SQL type in Web ADI ? Or some other way to do this. Thnks. ... written by lashmi , December 07, 2007 this fnd loader used for wed adi concept is very good You must be logged in to a comment. Please register if you do not have an account yet.