APPS TO FUSION

.......Our Journey from Apps To Fusion

Oracle Apps Scripts

Oracle FNDLOAD Script Examples

User Rating: 5 / 5

Star activeStar activeStar activeStar activeStar active
 
In this article I wish to give real working examples of Oracle's FNDLOAD utility.
Besides that, I have included some useful notes on 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.
Some of the examples in this FNDLOAD article include:-
FNDLOAD to transfer Request Groups
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 FNDLOAD

Use 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 FlexFields, 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
In my case I am ensuring that $CLIENT_APPS_PWD has the apps password before running the scripts


------------------------------------------------------------------------------------------


##To FNDLOAD Request groups
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_MY_REPORT_GROUP_NAME.ldt REQUEST_GROUP REQUEST_GROUP_NAME="XX_MY_REPORT_GROUP_NAME" APPLICATION_SHORT_NAME="XXGMS"
##Note that
##---------
## <> will be your Application Shortname where request group is registered
## XX_MY_REPORT_GROUP_NAME
Will be the name of your request group
## ##To upload this Request Group in other environment after having transferred the ldt file

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct


------------------------------------------------------------------------------------------


##To FNDLOAD Concurrent Programs
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"
##Note that
##---------
## XXGMS will be your custom GMS Application Shortname where concurrent program is registered
## XX_CUSTOM_ORACLE_INTERFACE_PROG
Will be the name of your request group
## XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt is the file where concurrent program definition will be extracted
## ##To upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt


------------------------------------------------------------------------------------------


##To FNDLOAD Oracle Descriptive Flexfields
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PO DESCRIPTIVE_FLEXFIELD_NAME='PO_REQUISITION_HEADERS'
##Note that
##---------
## PO is the Application Shortname against which descriptive flexfield against PO Headers is registered
## PO_REQUISITION_HEADERS
is 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
########----->application_id, DESCRIPTIVE_FLEXFIELD_NAME, application_table_name
########----->FROM
########-----> fnd_descriptive_flexs_vl
########----->WHERE
########-----> APPLICATION_TABLE_NAME like '%' || upper('&tab_name') || '%'
########----->ORDER BY APPLICATION_TABLE_NAME
########----->/
## To upload into another environment
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt

## OK another example for DFF against FND_LOOKUPS
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_FND_COMMON_LOOKUPS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=FND DESCRIPTIVE_FLEXFIELD_NAME='FND_COMMON_LOOKUPS'
## OK another example for DFF against Project Accounting Expenditure Types
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PA_EXPENDITURE_TYPES_DESC_FLEX_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PA DESCRIPTIVE_FLEXFIELD_NAME='PA_EXPENDITURE_TYPES_DESC_FLEX'



------------------------------------------------------------------------------------------


##To FNDLOAD Oracle Menus
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt MENU MENU_NAME="ICX_POR_SSP_HOME"
##Note that
##---------
## Oracle Menus are not attached to applications. Hence no need to include application short name
## ICX_POR_SSP_HOME is the menu name. This can be validated via below SQL
## select user_menu_name from fnd_menus_vl where menu_name = 'ICX_POR_SSP_HOME' ;
## Also note that we do not pass in the User_menu_name in this example
## OK, now to upload this file
$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct ICX_POR_SSP_HOME.ldt


----------------------------------------------------------------------------------------------------------------------------

## Well, now for FND Messages to download a single message
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct \
XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='ICX' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP

## Or you may as well download all the messages within an application
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct \
XX_ALL_GMS_MESSAGES_00.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='XXGMS'

## now to upload using FNDLOAD
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt


----------------------------------------------------------------------------------------------------------------------------


## Now it's the turn of Lookup values. Again, its not a rocket science
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD aflvmlu.lct XX_TRX_BATCH_STATUS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='XXGMS' LOOKUP_TYPE="XX_TRX_BATCH_STATUS"
## Note that
## XX_TRX_BATCH_STATUS is the name of FND Lookup Type in this example
## This will download all the lookup codes within the defined lookup
## To upload
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD aflvmlu.lct XX_TRX_BATCH_STATUS.ldt

----------------------------------------------------------------------------------------------------------------------------

## You can also move the User definitions from FND_USER
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct ./XX_FND_USER_PASSI.ldt FND_USER USER_NAME='ANILPASSI'
#Do not worry about your password being extracted, it will be encrypted as below in ldt file
#BEGIN FND_USER "ANILPASSI"
# OWNER = "PASSIA"
# LAST_UPDATE_DATE = "2005/10/19"
# ENCRYPTED_USER_PASSWORD = "ZGE45A8A9BE5CF4339596C625B99CAEDF136C34FEA244DC7A"
# SESSION_NUMBER = "0"
To upload the FND_USER using FNDLOAD command use
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct ./XX_FND_USER_PASSI.ldt
Notes for using FNDLOAD against FND_USER:-
1. After uploading using FNDLOAD, user will be promoted to change their password again during their next signon attempt.
2. All the responsibilities will be extracted by FNDLOAD alongwith User Definition in FND_USER
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 oracle's FNDLOAD
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct POR_ENABLE_REQ_HEADER_CUST.ldt PROFILE PROFILE_NAME="POR_ENABLE_REQ_HEADER_CUST" APPLICATION_SHORT_NAME="ICX"
## Note that
## POR_ENABLE_REQ_HEADER_CUST is the short name of profile option
## We aren't passing the user profile option name in this case. Validate using ...
########----->select application_id, PROFILE_OPTION_NAME || '==>' || profile_option_id || '==>' ||
########----->USER_PROFILE_OPTION_NAME
########----->from FND_PROFILE_OPTIONS_VL
########----->where PROFILE_OPTION_NAME like '%' || upper('&profile_option_name') || '%'
########----->order by PROFILE_OPTION_NAME
########----->/
## Now to upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct POR_ENABLE_REQ_HEADER_CUST.ldt


----------------------------------------------------------------------------------------------------------------------------


## Now for the request sets that contain the stages and links for underlying concurrent programs
## For this you will be firstly required to download the request set definition.
## Next you will be required to download the Sets Linkage definition
## Well, lets be clear here, the above sequence is more important while uploading
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET.ldt REQ_SET REQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET_LINK.ldt REQ_SET_LINKS REQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"
## Note that FNDRSSUB4610101 can be found by doing an examine on the
########----->select request_set_name from fnd_request_sets_vl
########----->where user_request_set_name = 'User visible name for the request set here'
## Now for uploading the request set, execute the below commands
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XX_GL_MY_INTERFACE_SET_LINK.ldt


----------------------------------------------------------------------------------------------------------------------------


## Now for the responsibility
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_PERSON_RESPY.ldt FND_RESPONSIBILITY RESP_KEY="XX_PERSON_RESPY"
## note that XX_PERSON_RESPY is the responsibility key
## Now to upload
FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_PERSON_RESPY.ldt


----------------------------------------------------------------------------------------------------------------------------
## OK, now for the forms personalizations
## For the forms personalizations, I have given three examples as below.
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt FND_FORM_CUSTOM_RULES function_name="HZ_ARXCUDCI_STD"
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"
## Note that the function name above is the function short name as seen in the Function Definition Screen
## Now to upload the forms personalizations that are defined against these forms functions....
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt


----------------------------------------------------------------------------------------------------------------------------


Notes :
1. Give special attention when downloading Menus or Responsibilities.
In case your client has several developers modifying Responsibilities and Menus, then be ultra carefull. Not being carefull will mean that untested Forms and Functions will become available in your clients Production environment besides your tested forms, functions and menus.

2. Be very careful when downloading flexfields that reference value sets with independent values for GL Segment Codes.
By doing so, you will download and extract all the test data in GL Codes that might not be applicable for production.

3. There are several variations possible for FNDLOAD, for example you can restrict the download and uploads to specific segments within Descriptive Flex Fields. Please amend the above examples as desired for applying appropriate filterations.

4. The list of examples by no mean cover all possible FNDLOAD entities.

5. FNDLOAD is very reliable and stable, if used properly. This happens to by one of my favourite Oracle utilities.

4. Last but not the least, please test your FNDLOAD properly, so as to ensure that you do not get any unexpected data. In past I have noticed undesired results when the Lookup gets modified manually directly on production, and then the FNDLOAD is run for similar changes. If possible, try to follow a good practice of modifying FNDLOADable data only by FNDLOAD on production environment.

5. As the name suggests, FNDLOAD is useful for FND Related objects. However in any implementation, you will be required to migrate the Setups in Financials and Oracle HRMS from one environment to another. For this you can use iSetup. "Oracle iSetup".
Some of the things that can be migrated using Oracle iSetup are
GL Set of Books, HR Organization Structures, HRMS Employees, Profile Options Setup, Suppliers, Customers, Tax Codes
& Tax Rates, Financials Setup, Accounting Calendars, Chart of Accounts, GL Currencies.

Comments   

0 #1 Vishal 2006-12-08 00:00
Hi Anil,
I tried the command again. I was missing single quotes around APPLICATION_SHO RT_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.

Vis hal.
Quote
0 #2 Anil Passi 2006-12-09 00:00
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/afff load.lct

sea rch for string fnd_flex_loader _apis.up_desc_f lex

In the parameter last_update_dat e you can pass sysdate, replacing the value read from ldt file
Please note this is customization and is not supportable
Th e 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/afff load.lct XX_SSHR_01_ETH_ VALUE_SET.ldt VALUE_SET FLEX_VALUE_SET_ NAME=XX_HRMS_ET H_ORIGIN

Tha nks,
Anil Passi
Quote
0 #3 Anil Passi 2006-12-09 00:00
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/afff load.lct

sea rch for string fnd_flex_loader _apis.up_desc_f lex

In the parameter last_update_dat e you can pass sysdate, replacing the value read from ldt file
Please note this is customization and is not supportable
Th e 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/afff load.lct XX_SSHR_01_ETH_ VALUE_SET.ldt VALUE_SET FLEX_VALUE_SET_ NAME=XX_HRMS_ET H_ORIGIN

Tha nks,
Anil Passi
Quote
0 #4 Vikram Unde 2006-12-26 00:00
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
A ltering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u02/appluat/u atappl/fnd/11.5 .0/patch/115/im port/afcprs
et .lct(115.26), XX_THA_GLDOIUPR _REP_DEF.ldt) to stage tables
Dump LCT file /u02/appluat/ua tappl/fnd/11.5. 0/patch/115/imp ort/afcprset.lc t(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_STAG E_ENTITY
Uploa d from stage tables
Error loading seed data for STAGE_PROG: APPLICATION_SHO RT_NAME = SQLGL, REQUES
T_SET_N AME = XX_THA_GLDOIUPR _REP, STAGE_NAME = 1, SEQUENCE = 10, ORA-01403: no
data found
-------- -------------
Could you please advice urgently.


Thanks & Regards,
Vikra m Unde
Quote
0 #5 Anil Passi 2007-01-12 00:00
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
Quote
0 #6 Anil Passi 2007-01-18 00:00
.
.
.
Hi Ruma,
Link http://oracle.anilpassi.com/find-request-group-for-concurrent-programs.html
should answer your question, though partially.

W hich application did you attach this Request Set to? It is possible that the Request Group against all those responsibilitie s includes the Application which is attached to your Request Set.

Thanks,
Anil Passi
Quote
0 #7 siddh 2007-01-19 00:00
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
Quote
0 #8 Anil Passi 2007-01-20 00:00
Hi Ruma,

I need to know the APPLICATION to which this request set is attached?

No t 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
Quote
0 #9 Anil Passi 2007-01-20 00:00
Hi Ruma,

I need to know the APPLICATION to which this request set is attached?

No t 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
Quote
0 #10 siddh 2007-01-22 00:00
Hi Anil,
Can you send one example to load telesales dashboard objects like profile variables and drilldown using FNDLOAD?

Tha nks.
-Siddh
Quote
0 #11 Anil Passi 2007-01-23 00:00
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.

Th anks,
Anil Passi
Quote
0 #12 Venugopal 2007-01-26 00:00
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
Thank s and Regards
Venugo pal
Quote
0 #13 Venugopal 2007-01-28 00:00
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 (). Request you to go through and suggest changes.
Regar ds
Venugopal
Quote
0 #14 Anil Passi 2007-01-29 00:00
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
Quote
0 #15 Venugopal 2007-01-29 00:00
Hi Anil,

Tried with the .lct file you provided but it is not working. What could be the issue? Please help.

Regard s
Venugopl
Quote
0 #16 Nilesh 2007-01-29 00:00
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?
Quote
0 #17 Anil Passi 2007-01-31 00:00
.
.
.
Hi Nilesh,

Inte resting, I never moved alerts using fndload.
But anyway, are you transferring the files in ascii mode?

thanks
ani l
Quote
0 #18 Anil Passi 2007-02-01 00:00
.
.
.
Hi Alexander,

Y ou 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
Quote
0 #19 rajitha 2007-02-01 00:00
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
UPLOA D_MODE=REPLACE will replace any current values with the values in the file

Unix command is

FNDLOAD apps/apps_pwd@o racle_sid 0 Y UPLOAD $FND_TOP/patch/ 115/import/afsl oad.lct
$MSC_TOP/patc h/115/import/US msctop.ldt - WARNINGS=YES
UPLOAD_MODE=R EPLACE CUSTOM_MODE=FOR CE


Thanks!

Rajitha
Quote
0 #20 Chandrasekar 2007-02-02 00:00
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
Quote
0 #21 Anil Passi 2007-02-02 00:00
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.

**P ls test this on other instance, I think it should work, because I can see that lct file is calling fnd_menu_entrie s_pkg.LOAD_ROW for the Menus available in ldt file

Thanks,
Anil Passi
Quote
0 #22 Anil Passi 2007-02-02 00:00
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

a ny wonder why not many people use iSetup?
Quote
0 #23 Anil Passi 2007-02-05 00:00
Excellent stuff Alexander.
Quote
0 #24 Anil Passi 2007-02-13 00:00
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
Quote
0 #25 Anil Passi 2007-03-12 00:00
Hi Frank,

Pleas e check the width of the columns mentioned in lct file. Possibly one of the column have less number of VARCHAR2(lenngt h) than the corresponding length in the fnd_lookup_valu es
Quote
0 #26 Vishal 2007-03-20 00:00
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-validatio n rules.

Thank s.
Quote
0 #27 Florin 2007-03-30 00:00
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
Quote
0 #28 Anil Passi 2007-03-31 00:00
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
Quote
0 #29 Ashok 2007-04-13 00:00
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
Quote
0 #30 Ashok 2007-04-13 00:00
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
Quote
0 #31 Babu 2007-04-19 00:00
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.


T hanks & Regards,
Babu.
Quote
0 #32 Anil Passi 2007-04-20 00:00
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
Quote
0 #33 Satya 2007-04-26 00:00
Hello experts,

I have a spreadsheet which has around 300-400 responsibilitie s and wanted to load into oracle tables.

Does , anybody has any ideas what will the process involved these responsibilitie s from spreadsheet to oracle tables.

Any ideas will be highly appriciated.

-Satya
Quote
0 #34 Vishnu 2007-05-09 00:00
API on Status change in Property Manager
Quote
0 #35 Nagesh 2007-05-23 00:00
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.
Howe ver 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.

Thank s,
Nagesh
Quote
0 #36 Michu 2007-05-29 00:00
Hi Anil,
Can you send some information about Oracle projects, am new to this module, I have to do costing conversions,pro ject conversions

Thanks
Quote
0 #37 Dhiman 2007-06-03 00:00
Hi Anil,

Can we upload forms also using FNDLOAD utility?

If yes, do we need to uploas Form and Form Function separately?

Please advice.

Than ks & Regards,
Dhima n.
Quote
0 #38 Anil Passi 2007-06-04 00:00
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.

Parame ters for the entities are:-

FORM
-------
FORM _APP_SHORT_NAME
FORM_NAME

FUNCTION
-----------
FUNC_APP_SHORT_ NAME
FUNCTION_ NAME


Thank s,
Anil Passi
Quote
0 #39 Raj Naik 2007-06-19 00:00
Hi Anil,

Raj again, i missed one point. What about XML Reports, i mean Data Definition & Templates?

T hanks
Raj Naik
Quote
0 #40 Raj Naik 2007-06-19 00:00
Hi Anil,

Raj again, i missed one point. What about XML Reports, i mean Data Definition & Templates?

T hanks
Raj Naik
Quote
0 #41 Ashish Gairola 2007-06-20 00:00
Anil,

I need one favor.Can we migrate Assign profile options and Asssign security rules using FNDLOADER
Quote
0 #42 Anil Passi 2007-06-20 00:00
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?

Than ks,
AniL Passi
Quote
0 #43 nagender 2007-07-02 23:37
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,
N agender
Quote
0 #44 passianil 2007-07-03 00:06
Hi Nag

You simply need to copy the rdf file into respective $MODULE_TOP/rep orts/US
or some other relevant language directory

than ks
anil
Quote
0 #45 nagender 2007-07-03 01:10
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.
Ho w 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.

Thank s,
Nagender
Quote
0 #46 Anil Passi 2007-07-03 21:43
Hi Nag,

If you are moving concurrent program definition for the reports then of course you can use FNDLOAD.

Howev er if you are upgrading to 11.5.10, then upgrade process will retain your custom reports registered with custom application

Th anks,
Quote
0 #47 pruthvi 2007-07-11 06:42
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,
Pr uthvi M.

Quote
0 #48 APassi 2007-07-11 07:05
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,
An il
Quote
0 #49 Sandra 2007-07-30 07:29
Hi Anil,
thank ypu for script, it helps very much.
I used it for upload fnd_new_message s, 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
Quote
0 #50 Anil Passi 2007-07-30 09:25
Hi Sandra

Please request your DBA to generate message files. That should fix the issue

Thanks,
Anil
Quote
0 #51 Sandra 2007-07-30 14:19
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_t l- what should I do to see changes in application?
Re gards,
Sandra
Quote
0 #52 Anil Passi 2007-07-30 19:56
Hi Sandra,

Can you see the description reflected in fnd_languages_v l ?
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.

Thank s,
Anil Passi
Quote
0 #53 Kiks 2007-08-10 14:21
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.

--DOWNL OAD from one instance--
FNDL OAD 0 Y DOWNLOAD $ALR_TOP/patch/ 115/import/alr. lct ALR_ALERTS APPLICATION_SHO RT_NAME= ALERT_NAME=

-- UPLOAD to another instance--
FNDL OAD 0 Y UPLOAD $ALR_TOP/patch/ 115/import/alr. lct

Best Regards,
Kiks
Quote
0 #54 Tuan 2007-08-29 15:05
hello Anil,
I am noving custom responsibilitie s that has custom Menus and functions. Do I need to FNDLOAD custom Functions and Menus before FNDLOAD custom Responsibility?
Quote
0 #55 Anil Passi 2007-08-30 05:46
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.
Wh en you FNDLOAD menu's, form funtions and form definitions attached to the menu's will also get FNDLOAD'ed

Tha nks
Anil
Quote
0 #56 krishnab 2007-09-13 07:17
Hi Anil,
When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CO NTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CO NTROL table and if I not inserted into GL_INTERFACE_CO NTROL what will happen?
Quote
0 #57 Anil Passi 2007-09-13 08:30
Hi Krishnab

If you are submitting the JournalImport programatically , then you must create a record in GL_INTERFACE_CO NTROL.
This is so, because the GL Import process, when called programatically , must be passed the interface_run_i d as shown below
v_conc_id := fnd_request.sub mit_request(app lication => 'SQLGL'
,program => 'GLLEZL'
,description => NULL
,start_time => SYSDATE
,sub_request => FALSE
,argument1 => v_interface_run_i d
,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_co ntrol.

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.
O ne such example is that project accounting uses PA_GL_INTERFACE . Hence in this case, GL_INTERFACE_CO NTROL.INTERFACE _TABLE_NAME will have a value of PA_GL_INTERFACE

If you leave GL_INTERFACE_CO NTROL.INTERFACE _TABLE_NAME as null, then gl_interface will become the source for importing the journals

Thank s,
Anil Passi
Quote
0 #58 krishnab 2007-09-14 07:15
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?
Quote
0 #59 krishnab 2007-09-14 07:59
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?
Quote
0 #60 krishnab 2007-09-14 08:01
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?
Quote
0 #61 Anita 2007-09-21 05:27
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,Elemen t,Setup Payroll)I will be greatful to you.

Thanks
An ita
Quote
0 #62 Anil Passi 2007-09-23 08:28
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
Metal ink 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/pype tt.lct

--For transferring Element Input Values
$PAY_TOP/patch/ 115/import/pypi vt.lct

Note: Please test these lct files before usage, as I am yet to use these loader files myself

Thanks,
Anil Passi
Quote
0 #63 Marco Ramos 2007-09-26 21:46
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_SHO RT_NAME and CONCURRENT_PROG RAM_NAME but I keep getting the message below in my log file:

An entity name must be specified for the download operation
Quote
0 #64 Anil Passi 2007-09-27 05:23
Hi Marco

To download, you do not need to specify the ENTITY

FNDLOAD apps/$CLIENT_AP PS_PWD O Y DOWNLOAD $FND_TOP/patch/ 115/import/afcp prog.lct XX_CUSTOM_ORACL E_INTERFACE_PRO G.ldt PROGRAM APPLICATION_SHO RT_NAME="XXGMS" CONCURRENT_PROG RAM_NAME="XX_CU STOM_ORACLE_INT ERFACE_PROG"

T hanks,
Anil Passi
Quote
0 #65 Dilee 2007-09-27 06:59
Hi Anil,

Is is posible to download the ldt files of concurrent programs without the values of independent valuesets?

Tha nks & Regards,
Dilee
Quote
0 #66 ankur jaiswal 2007-10-04 07:46
Hi Anil
can we use FNDLOAD to transfer Transaction Type set up IN AME/OAM.
also,c ould you guide us to create new lcts.
Regards
A nkur
Quote
0 #67 naga 2007-10-16 16:34
Hi Anil,
How can we move XML publisher reports, Templates and Data definitions?

t hanks
Siva
Quote
0 #68 Vishal Goyal 2007-10-19 03:47
Hi Anil,

Is there a way to transfer setups like JE Sources/Categor ies/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/categor ies.

Thanks.
V ishal.
Quote
0 #69 Anil Passi 2007-10-22 15:25
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.

FNDLO AD can
---------
U pload and download the data definition information and the template metadata


XDOL oader 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


Th anks,
Anil Passi
Quote
0 #70 vinayaksawal 2007-10-23 06:10
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.?

C an you please suggest your expertise ?

Cheers,
Vina y
Quote
0 #71 Anil Passi 2007-10-24 05:31
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,
An il Passi
Quote
0 #72 Deepthi J 2007-10-25 12:14
If it is using Fast Formula Assitant please let me know the process.
Quote
0 #73 Anil Passi 2007-10-25 13:18
Hi Deepthi

I am pasting this straight from Metalink Note 435765.1, as below

Applies to:
Oracle Payroll - Version: 11.5.10
Informa tion in this document applies to any platform.

Goal
How do you set up FastFormula Assistant (new functionality in HRMS Family Pack K ) ?



Solution
H ere are the steps:

1)
Add the following menus
Cross-Bus iness Group Home Page
FastFormul a Assistant Home Page
to a suitable point in the SHRMS Navigator menu tree.
Responsib ility : System Administrator
N avigation : 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).
Res ponsibility : System Administrator
N avigation : Application > Menu

3)
Ensure the 'FastFormula Transaction Manager' concurrent manager is
running on your environment.
Lo g 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


Thank s,
Anil Passi
Quote
0 #74 Deepthi J 2007-10-25 13:45
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
De epthi
Quote
0 #75 Ramachandra 2007-10-29 05:49
Hi Anil

I want to pass application short name as parameters for this afscursp.lct
so me 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.
RamaChandr a.N
Please give me suggestions.
Quote
0 #76 Anil Passi 2007-10-30 20:45
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.

Thank s
Anil Passi
Quote
0 #77 Ramya 2007-10-31 18:06
Hi Anil,

I have a sample code of downloading the valuesets,concu rrent programs and Request Groups using FNDLOAD.

In the request area...in old sample code they had used UNIT_TYPE and UNIT_NAME....wh at these are related to.

Kindly Clarify...

Ram ya
Quote
0 #78 punit 2007-11-05 10:07
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.
Quote
0 #79 Anil Passi 2007-11-05 10:31
Hi Punit

Have a look at presentation in oracle.anilpassi.com/fndload-a-dive-into-basics-2.html

That will help you find the answer yourself.

Than ks,
Anil Passi
Quote
0 #80 Ramchandra 2007-11-13 10:08
Hi Anil

I am Trying to upload Responsibilitie s individually by using FNDLOAD.
But, it giving error like

Uploading from the data file xxbmc_bcm_respo nsibility.ldt
A ltering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u001/app/ocap 2dv1/ocap2dv1ap pl/fnd/11.5.0/p atch/115/import /afscursp.lct(1 15.44), xxbmc_bcm_respo nsibility.ldt) to stage tables
Dump LCT file /u001/app/ocap2 dv1/ocap2dv1app l/fnd/11.5.0/pa tch/115/import/ afscursp.lct(11 5.44) into FND_SEED_STAGE_ CONFIG
Dump LDT file xxbmc_bcm_respo nsibility.ldt into FND_SEED_STAGE_ ENTITY
Dumped the batch (FND_APPLICATIO N BMCSREV , FND_RESPONSIBIL ITY BMCSREV BMC_COLLECTIONS _MANAGER ) into FND_SEED_STAGE_ ENTITY
Upload from stage tables
Error loading seed data for FND_RESPONSIBIL ITY: APPLICATION_SHO RT_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.

Than k you.
Regards
Ra mchandra.N
Quote
0 #81 Ramchandra 2007-11-13 15:16
Hi anil

I am trying uploading menus individually. but it giving error like

Please give me solution for these error.

Uploadi ng from the data file xxbmc_401_menu. ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u001/app/ocap 2dv1/ocap2dv1ap pl/fnd/11.5.0/p atch/115/import /afsload.lct(11 5.59), xxbmc_401_menu. ldt) to stage tables
Dump LCT file /u001/app/ocap2 dv1/ocap2dv1app l/fnd/11.5.0/pa tch/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_SHO RT_NAME = BMCS, FORM_NAME = BMCS401K, ORA-01400: cannot insert NULL into ("APPLSYS"."FND _FORM"."APPLICA TION_ID")
ORA-0 6512: 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_SHO RT_NAME = BMCS, FORM_NAME = BMCSLOAN, ORA-01400: cannot insert NULL into ("APPLSYS"."FND _FORM"."APPLICA TION_ID")
ORA-0 6512: 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.l dt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u001/app/ocap 2dv1/ocap2dv1ap pl/fnd/11.5.0/p atch/115/import /afsload.lct(11 5.59), xxbmc_ar_menu.l dt) to stage tables
Dump LCT file /u001/app/ocap2 dv1/ocap2dv1app l/fnd/11.5.0/pa tch/115/import/ afsload.lct(115 .59) into FND_SEED_STAGE_ CONFIG
Dump LDT file xxbmc_ar_menu.l dt into FND_SEED_STAGE_ ENTITY
Dumped the batch (MENU *NULL* , MENU AR_CONTROL_GUI ) into FND_SEED_STAGE_ ENTITY
Upload from stage tables
Quote
0 #82 Anil Passi 2007-11-13 15:58
Hi Ramchandra,

Pl ease run this SQL in the destination environment.
Do es 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_sho rt_name = 'BMCS';

Thanks,
Anil Passi
Quote
0 #83 Mugunthan.S 2007-11-13 16:37
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 responsibilitie s/ 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.
Quote
0 #84 Ramchandra 2007-11-14 03:03
Hi Anil

I am Trying to upload Responsibilitie s individually by using FNDLOAD.
But, it giving error like

Uploading from the data file xxbmc_bcm_respo nsibility.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u001/app/ocap 2dv1/ocap2dv1ap pl/fnd/11.5.0/p atch/115/import /afscursp.lct(1 15.44), xxbmc_bcm_respo nsibility.ldt) to stage tables
Dump LCT file /u001/app/ocap2 dv1/ocap2dv1app l/fnd/11.5.0/pa tch/115/import/ afscursp.lct(11 5.44) into FND_SEED_STAGE_ CONFIG
Dump LDT file xxbmc_bcm_respo nsibility.ldt into FND_SEED_STAGE_ ENTITY
Dumped the batch (FND_APPLICATIO N BMCSREV , FND_RESPONSIBIL ITY BMCSREV BMC_COLLECTIONS _MANAGER ) into FND_SEED_STAGE_ ENTITY
Upload from stage tables
Error loading seed data for FND_RESPONSIBIL ITY: APPLICATION_SHO RT_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
Quote
0 #85 Sanjib Kundu 2007-11-14 12:10
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 Responsibilitie s. 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.

Than ks,

Sanjib Kundu
Jamshedpu r, INDIA
Quote
0 #86 Nitin Gaopande 2007-11-14 13:02
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 :)
Quote
0 #87 vivekclement 2007-11-15 11:35
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 ?
Quote
0 #88 Vinay 2007-11-16 04:57
While Transferring Cocurrent programme through FNDLOAD,will it transfer the value set with that.If not how that can be achived.

Thank s & Regards

Vinay
Quote
0 #89 Ramchandra 2007-11-16 09:04
Hi anil I am uploading menus by useing fndload.

While uploading i am getting log files.

1)Uploa ding from the data file /u001/app/applm gr/ftp/xxbmc_me nu_24_BMCSREV_O E _USER.ldt
Alter ing database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u001/app/ocap 2dv1/ocap2dv1ap pl/fnd/11.5.0/p atch/115/import /afsload.lct(11 5.59), /u001/app/applm gr/ftp/xxbmc_me nu_24_BMCSREV_O E _USER.ldt) to stage tables
Dump LCT file /u001/app/ocap2 dv1/ocap2dv1app l/fnd/11.5.0/pa tch/115/import/ afsload.lct(115 .59) into FND_SEED_STAGE_ CONFIG
Dump LDT file /u001/app/applm gr/ftp/xxbmc_me nu_24_BMCSREV_O E _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
log on is username/passwo rd[@connect]
mo de is UPLOAD, UPLOAD_PARTIAL or DOWNLOAD
config file 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
ba tch_id is batch id


Please give me solution for this.

thank you.
Regards
Ra machandra.N
Quote
0 #90 prabhakarreddy 2007-11-19 04:12
hi anil,
i want information about tuning in RICE cpmponents.plse

Please give me solution for this.

Thanks and Regards
Prabhakar
Quote
0 #91 Ashish_arora 2007-11-26 09:43
Can u please provide anything related to Lookup type which is missing in this how to download or upload lookups.
Quote
0 #92 ramanath kamath 2007-11-27 09:04
Hi Anil,
please provide detailed information regarding backing up of request sets and trading partner setups

Thanks
Ramanath Kamath
Quote
0 #93 amresh 2007-12-18 08:46
Hello Anil,

How to use in the case of Multilingual Concurrent programs.
Means from english to diffirent languges.

Than ks & Regards,
Amresh
Quote
0 #94 RahulHRMS 2008-01-16 15:16
Hi all ,

How do i download EIT's.

Thanks ,
Rahul
Quote
0 #95 Anil Passi 2008-01-16 15:56
Hi Rahul

HRMS EIT is a DFF.
Please use the DFF Syntax on FNDLOAD

Thanks ,
Anil Passi
Quote
0 #96 madhusudhan padamatinti 2008-01-18 12:26
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
Quote
0 #97 Anil Passi 2008-01-18 12:48
Hi Madhu

Please use WFLOAD command to upload your workflow wft file to other environments.

Please search metalink for wfload syntax

Thanks,
Anil Passi
Quote
0 #98 Jim Boyland 2008-01-25 14:14
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/afcp prog.lct 29599_p
rog.ldt PROGRAM APPLICATION_SHO RT_NAME="TFND" CONCURRENT_PROG RAM_NAME=
"Tupperware DBA Rebuild Indexes"
Quote
0 #99 Anil Passi 2008-01-25 19:43
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_PROG RAM_NAME=
"TUPP ERWARE_DBA_REBU ILD"

As per your FNDLOAD command, currently all your concurrent programs belonging to application TFND will be downloaded.

Pa ssing the short name of concurrent program will resolve this issue.

Thanks,
Anil Passi
Quote
0 #100 Seshu Nukala 2008-02-05 22:03
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 /
Quote
0 #101 Yan 2008-02-11 10:46
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.
Whe n 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
Quote
0 #102 Natasa Radosevic 2008-02-18 09:01
Hi,

I generated message file throw adadmin for ICX module and I've got next messages: "No Oracle Message files selected for generation".
Me ssage 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
Quote
0 #103 raj6367 2008-02-26 14:45
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_AP PS_PWD 0 Y DOWNLOAD $FND_TOP/patch/ 115/import/afcp rset.lct FNDRSSUB1992_RE Q_SET_DEF.ldt REQ_SET REQUEST_SET_NAM E="FNDRSSUB1992 "
FNDLOAD apps/$CLIENT_AP PS_PWD 0 Y DOWNLOAD $FND_TOP/patch/ 115/import/afcp rset.lct FNDRSSUB1992_RE Q_SET_LK.ldt REQ_SET_LINKS REQUEST_SET_NAM E="FNDRSSUB1992 "

For upload this is what i used.

FNDLOAD apps/$CLIENT_AP PS_PWD 0 Y UPLOAD $FND_TOP/patch/ 115/import/afcp rset.lct FNDRSSUB1992_RE Q_SET_DEF.ldt
FNDLOAD apps/$CLIENT_AP PS_PWD 0 Y UPLOAD $FND_TOP/patch/ 115/import/afcp rset.lct FNDRSSUB1992_RE Q_SET_LK.ldt

Thanks.

Quote
0 #104 Martand Joshi 2008-03-06 12:11
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
Quote
0 #105 Srini 2008-04-12 13:04
Hi Anil,

I have seen this question posted before, but some how, I did not find any answer for this. I have gone through your presentation located at: http://oracle.anilpassi.com/fn...ics-2.html.

We are using FNDLOAD utility to migrate AOL objects between instances. This utility migrates the value set values, automatically, along with defeinition of concurrent program, if the concurrent program has any parameter tied to an independent value set. This is causing a major issue of corrupting value set values in the target instance. Is there any option for FNDLOAD, not to bring these value set values from source to target instance, while migrating concurrent programs? Are there any other AOL objects behave the same way?

I have checked the UPLOAD_PARTIAL option. But it is to upload certain given entity, but I did not see any option not to load certain entity from a
downloaded ldt file.

I appreciate your help. This site is really the best one. It has got more detailed information than any other sites/discussio n forums, including metalink.

Than ks,
Srini
Quote
0 #106 Anil Passi 2008-04-12 16:12
Hi Srini


You can use UPLOAD_PARTIAL, and upload only the desired entities.

Plea se have a look at presentation in http://apps2fusion.com/technical-articles-mainmenu-27/miscellaneous-mainmenu-40/21-miscellaneous-technology/198-fndload-a-dive-into-basics

Thanks,
Anil Passi
Quote
0 #107 Srini 2008-04-12 19:09
Thanks Anil, for your prompt reply.

So in this case for uploading a concurrent program, can I use all the entity names on the same command line, excluding value set values, while uploading partial?
Or do I have to upload one entity at a time, for the concurrent program?

Is there any option to DOWNLOAD_PARTIA L, and not to include value set values for a concurrent program?

But how the other companies are handling this situation. Because it's look like a common problem. I have used FNDLOAD about 4 years back, but that version's configuration file is not downloading value set values along with the other entities for conc. program.

Thank You,
Srini
Quote
0 #108 Anil Passi 2008-04-13 08:29
Hi Srini

Yes, there is an option for DOWNLOAD_PARTIA L too.


FNDLOAD apps/apps 0 Y DOWNLOAD_PARTIA L $FND_TOP/patch/ 115/import/afsc ursp.lct $FND_TOP/patch/ 115/import/pass iuser.ldt FND_USER USER_NAME='ANIL PASSI'



FNDLO AD apps/apps 0 Y UPLOAD $FND_TOP/patch/ 115/import/afsc ursp.lct $FND_TOP/patch/ 115/import/pass iuser.ldt FND_USER

End result is the same. If you already have downloaded the definitions, simply use upload partial.

Cheer s
Anil
Quote
0 #109 Srini 2008-04-13 16:02
Hi Anil,

Since I have downloaded the conc. program ldt file from source instance, it will have all the entities within the file for coc. progrm. such as program, executable,
parameter, valueset definition and valuset values.

When I upload the same file in the target instance, can I just use FNDLOAD command once and use mulitple entity names on the command line?
Or do I have to use multiple times, one for each entity in the concurrent program ldt file? Because I have to just exclude value set values, but all
other entity definitions from the downloaded ldt file should be uploaded in the target instance.

What is the best practice? Is any documentation by Oracle?

Thank You Very much for your help.

-- Srini
Quote
0 #110 Anil Passi 2008-04-13 18:09
Hi Srini

Yes, you should be able to specify multiple entities at command line.
You do that anyway for download too, for example, for downloading a single concurrent program, you can give Conc Short Name and the Application Short Name together.

Than ks,
Anil Passi
Quote
0 #111 TUAN 2008-04-25 14:21
Hello Anil,
First, I like to thanks for all the valuable works that you done.
I am working on the FNDLOAD the profile option and have a question about it.
I am moving the value of all required profile options for custom responsibilitie s from instance X to instance Y. However, instance X has more responsibilitie s
than instance Y. What would happen when I upload the profile options from X to Y?
Quote
0 #112 Anil Passi- 2008-04-25 15:54
HI Tuan

FNDLOAD for profile options does not extract responsibility_ id's.
What happens is this
DURING DOWNLOAD
1. For profile values at resp level, responsibility keys are downloaded

DUR ING UPLOAD
1. The responsibility keys from downloaded file are translated into responsibility_ id [if found]
2. The responsibility_ id is then loaded using FNDLOAD into profile options value table

If a responsibility does not exist in target system, then fndload will not be able to derive the resp_id from resp_key. Hence that record will be skipped.

What I am trying to say here is that, I do not foresee data corruption.

Ha ving said so, it is ideal for you to ensure that responsibility_ keys in downloaded ldt file exist in target system as well.
It does not matter if the responsibility_ id is same or different. What matters is the match between the responsibility_ key

Thanks
Ani l Passi
Quote
0 #113 TUAN 2008-04-25 17:14
Anil,

Thanks a ton. It's the answer I am looking for.
Quote
0 #114 TUAN 2008-05-17 12:34
Hi Anil,
Please find below is the error during FNDLOAD Profile Options:

Uploa ding from the data file GL_SET_OF_BKS_I D.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/apps5/applmgr /11i/pyriteappl /fnd/11.5.0/pat ch/115/import/a fscprof.lct(115 .52), GL_SET_OF_BKS_I D.ldt) to stage tables
Dump LCT file /apps5/applmgr/ 11i/pyriteappl/ fnd/11.5.0/patc h/115/import/af scprof.lct(115. 52) into FND_SEED_STAGE_ CONFIG
Dump LDT file GL_SET_OF_BKS_I D.ldt into FND_SEED_STAGE_ ENTITY
Dumped the batch (PROFILE GL_SET_OF_BKS_I D , FND_PROFILE_OPT ION_VALUES 10003 LNV_FIN_INV_CA_ USER_FI INV ) into FND_SEED_STAGE_ ENTITY
Upload from stage tables
Error loading seed data for FND_PROFILE_OPT ION_VALUES: PROFILE_NAME = GL_SET_OF_BKS_I D, LEVEL = 10003, LEVEL_VALUE = LNV_CONTROL_TOW ER_US, LEVEL_VALUE_APP = CSF, ORA-01403: no data found

Is there any requirements prior to FNDLOAD Profile Options? I was successful with the Responsibility and now trying to the Profile Options but it error out. Can you please help?
Thanks,
T uan
Quote
0 #115 Anil Passi 2008-05-17 16:05
Hi Tuan

Looks like one of the users or the responsibility in ldt file from source system does not exist in target system.
Have you migrated all the new responsibilitie s from source to target, retaining the Responsibility Key? Likewise for FND_USER.USER_N AME

Thanks,
An il Passi
Quote
0 #116 TUAN 2008-05-19 08:58
Hello Anil,
Both source and target instance are CRP instance. I only migrated the responsibilitie s that we wanted to keep and carry over to the future production instance. Therefore, the target instance has less responsibilitie s than the source instance. Also, the FND_USER.USER_N AME is not the same. I am not sure if my DBA abort the job or it abort itsefl when encounter the error but I did not see any thing came over to the target instance. I ws hoping that it would skip to the next record when responsibility key was not found. Do you have any other advise? since I do not want move unwanted responsibilitie s to move to the target instance.
Thank s,
Tuan
Quote
0 #117 Anil Passi 2008-05-19 09:03
If you do not want unwanted responsibilitie s to be moves across, then you will have to manually cleanup the ldt file.
Quote
0 #118 Prabhakar Somanathan 2008-06-30 08:19
FNDLOAD apps/$CLIENT_AP PS_PWD 0 Y DOWNLOAD $FND_TOP/patch/ 115/import/afff load.lct XXX_FND_COMMON_ LOOKUPS_DFF.ldt DESC_FLEX APPLICATION_SHO RT_NAME=FND DESCRIPTIVE_FLE XFIELD_NAME='FN D_COMMON_LOOKUP S' DESCRIPTIVE_FLE X_CONTEXT_CODE= 'XXX_STATUS'
Quote
0 #119 Anil Passi 2008-06-30 08:21
Cheers Prabhakar, for sharing this, as it is a common practice to download just one single DFF structure.
Quote
0 #120 Ram Balasubramanyan 2008-07-16 13:13
Hi,

Can FNDLOAD be used to migrate OA Framework Personalization s also? Pl. let me know, if there is any others way of migrating these from one instance to another.

Thank s
Ram Balasubramanyan
Quote
0 #121 Anil Passi- 2008-07-16 14:38
To move OAF Personalization s, 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


Than ks
Anil Passi
Quote
0 #123 TUAN 2008-08-01 16:44
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
Quote
0 #124 Anil Passi 2008-08-02 01:37
No I haven't

But you can cd to $MODULE_TOP/pat ch/115/import/ and grep for collection tables within lct files.

Thanks,
Anil Passi
Quote
0 #125 Elaine Fortin 2008-08-08 16:30
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/xdot mpl.lct XMLPData.ldt XDO_DS_DEFINITI ONS APPLICATION_SHO RT_NAME='HUICX' DATA_SOURCE_COD E='HUICXDELEGRP T'

I tried with double quotes and no quotes as well. Can you see a problem?

Thank s,
Elaine
Quote
0 #126 Shiraz 2008-08-10 03:35
Hi Anil,

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.

Thanks,
S hiraz
Quote
0 #127 Anil Passi 2008-08-10 03:57
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
0 #128 Shiraz 2008-08-10 04:40
Hi Anil,

Many thanks for the quick response.

sele ct * from PAY_ELEMENT_TYP ES_F where element_name like 'test1'
O/p gives 1 record

But FNDLOAD apps/**** O Y DOWNLOAD $PAY_TOP/patch/ 115/import/pype tt.lct test1.ldt PAY_ELEMENT_TYP ES 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 ...
Quote
0 #129 Shiraz 2008-08-10 05:29
Hi Anil,

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...

Th anks again,
Shiraz
Quote
0 #130 Anil Passi 2008-08-10 06:10
Hi Shiraz,

Anothe r 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
Quote
0 #131 Cyril 2008-09-23 05:09
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.

H ope it can help you.

Bye

Cyri l
Quote
0 #132 Parag gurjar 2009-02-14 01:25
Anil
can you suggest me how to move fast formula from one bg to other in bulk
Quote
0 #133 Annada 2009-04-14 11:09
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
Quote
0 #134 Anil Passi 2009-04-27 15:37
You can download by specifying the Application Shortname , leaving the object name blank.
You will have to do this for each lct file separately

Tha nks
Anil Passi
Quote
0 #135 Tina 2009-04-28 06:18
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?
Quote
0 #136 nishant 2009-05-15 03:04
Hello,

Can some one email me how to download and upload the KFF and Profile option definitions !
am not able to do that.

Nishant
Quote
0 #137 aryan 2009-07-06 09:53
Hello Anil,

Can we use fndload to migrate the concurrent programs from 11i ebs to R12 ebs.

Thank you.
Quote
0 #138 Siddharth Shah 2009-11-18 12:32
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.
Uploadin g from the data file SITEL_GLSTRING_ SET.ldt
Alterin g database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/prod/prodappl /fnd/11.5.0/pat ch/115/import/a fcprset.lct(115 .28), SITEL_GLSTRING_ SET.ldt) to stage tables
Dump LCT file /prod/prodappl/ fnd/11.5.0/patc h/115/import/af cprset.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_SHO RT_NAME = SITGL, REQUEST_SET_NAM E = FNDRSSUB2458, STAGE_NAME = STAGE10, SEQUENCE = 10, ORA-01403: no
data found
I checked for the application and it exists. Please suggest.
Thanks in advance.
Siddha rth
Quote
0 #139 Vishal 2010-09-01 03:37
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
Quote
0 #140 Josef 2010-12-01 18:20
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
Quote
0 #141 Pranav Muley 2011-03-25 15:15
Dear Anil,

Thanks for the great explaination on FNDLOAD.

As I understand using FNDLOAD apps/$CLIENT_AP PS_PWD O Y DOWNLOAD $PAY_TOP/patch/ 115/import/pype tt.lct XX_ELEMENT_TYPE _NAME.ldt PAY_ELEMENT_TYP ES E_ELEMENT_NAME= "ELEMENTNAMEHER E"

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?

Rega rds,

Pranav Muley
Quote
0 #142 sachinpy 2011-07-01 05:31
We are using OM_POST_BOOK_EV ENT 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_i nstance 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?
Quote
0 #143 SurdAce 2012-10-18 07:57
Hi I have a valueset with dff... is there any way i can you FNDLOAD to download the valueset with its values and the dff assigned to the values.
Quote
0 #144 NP 2013-04-01 21:59
Hi Anil,

FNDLOAD for lookup works fine for a common lookup, but for responsibility specific ones (the ones with the Global Security check box NOT CHECKED) it doesnt create the file correctly!!! Any suggestions?? does the lct file change other than aflvmlu.lct

Re gards
NP
Quote
0 #145 Myc 2013-10-04 14:30
this article is very helpful. Thank u
Quote

Add comment


Security code
Refresh

You are here: Home Technical Articles Oracle Scripts Oracle FNDLOAD Script Examples