document sur la redirection d’imprimante dans le bureau à distance

8/10/2019 Document Sur La Redirection dImprimante Dans Le Bureau Distance

1/57

cle FNDLOAD Script Examples http://apps2fusion.com/apps/scripts/18-oracle-scripts/19-oracle-fndloa...

57 16/12/2014 11:10


2/57


57 16/12/2014 11:10


3/57

Objects

Extend

FNDLOAD

LOGIN

USERNAME

PASSWORD

REMEMBER ME

Log in

Forgot your

password?

Forgot your

username?

Create an

account

environment after having transferred the ldt le

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"

##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 le

where concurrent program de nition will be extracted

## ##To uploadFNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD

$FND_TOP/patch/115/import/afcpprog.lct


57 16/12/2014 11:10


4/57

XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt

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

To FNDLOAD Oracle Descriptive Flex elds

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y

DOWNLOAD $FND_TOP/patch/115/import/a oad.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 ex eld against PO Headers is registered

## PO_REQUISITION_HEADERS

is the name of Descriptive Flex eld against PO

Requisition Headers

## Use the SQL below to nd 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_ exs_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/a oad.lct

XX_PO_REQ_HEADERS_DFF.ldt

## OK another example for DFF against FND_LOOKUPSFNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD

$FND_TOP/patch/115/import/a oad.lct


57 16/12/2014 11:10


5/57

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/a oad.lct

XX_PA_EXPENDITURE_TYPES_DESC_FLEX_DFF.ldt

DESC_FLEX APPLICATION_SHORT_NAME=PA

DESCRIPTIVE_FLEXFIELD_NAME='PA_EXPENDITURE_TYPES_DESC_

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

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 le

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y

UPLOAD $FND_TOP/patch/115/import/afsload.lct

ICX_POR_SSP_HOME.ldt

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


57 16/12/2014 11:10


6/57

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


$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


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

de ned lookup

## To upload

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOADa vmlu.lct XX_TRX_BATCH_STATUS.ldt


57 16/12/2014 11:10


7/57

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

You can also move the User de nitions from

FND_USER


$FND_TOP/patch/115/import/afscursp.lct

./XX_FND_USER_PASSI.ldt FND_USERUSER_NAME='ANILPASSI'

#Do not worry about your password being extracted, it

will be encrypted as below in ldt le

#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


$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 De nition 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 pro le 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


57 16/12/2014 11:10


8/57

## POR_ENABLE_REQ_HEADER_CUST is the short name

of pro le option

## We aren't passing the user pro le option name in

this case. Validate using ...

########----->select application_id,

PROFILE_OPTION_NAME || '==>' || pro le_option_id ||'==>' ||

########----->USER_PROFILE_OPTION_NAME

########----->from FND_PROFILE_OPTIONS_VL

########----->where PROFILE_OPTION_NAME like '%'

|| upper('&pro le_option_name') || '%'

########----->order by PROFILE_OPTION_NAME

########----->/

## Now to uploadFNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD

$FND_TOP/patch/115/import/afscprof.lct

POR_ENABLE_REQ_HEADER_CUST.ldt

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

Now for the request se t s that contain the stages

and link s for underlying concurrent programs

## For this you will be rstly required to download the

request set de nition.

## Next you will be required to download the Sets

Linkage de nition

## Well, lets be clear here, the above sequence is more

important while uploading


$FND_TOP/patch/115/import/afcprset.lct

XX_GL_MY_INTERFACE_SET.ldt REQ_SET

REQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"


$FND_TOP/patch/115/import/afcprset.lct

XX_GL_MY_INTERFACE_SET_LINK.ldt REQ_SET_LINKSREQUEST_SET_NAME="FNDRSSUB4610101_Will_look_like_this"

## Note that FNDRSSUB4610101 can be found by doing


57 16/12/2014 11:10


9/57


10/57

$FND_TOP/patch/115/import/a rmcus.lct

XX_HZ_ARXCUDCI_STD.ldt FND_FORM_CUSTOM_RULES

function_name="HZ_ARXCUDCI_STD"



XX_AP_APXVDMVD.ldt FND_FORM_CUSTOM_RULESfunction_name="AP_APXVDMVD"

## Note that the function name above is the function

short name as seen in the Function De nition Screen

## Now to upload the forms personalizations that are

de ned against these forms functions....



XX_PERWSHRG.ldtFNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD


XX_HZ_ARXCUDCI_STD.ldt



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 ex elds that

reference value sets with independent values for GLSegment Codes.

By doing so, you will download and extract all the test


f 57 16/12/2014 11:10


11/57


12/57


13/57

Quote

0

Quote

0

H_ORIGIN

Thanks,Anil Passi

Anil Passi 2006-12-09 00:00

Hi Vishal

The dates or rather the entire RowWhoinformation will be passed in fromm SourceSystem, i.e. whatever is in the ldt le.

Open the lct le by doingvi $FND_TOP/patch/115/import/a fload.lct

search for string fnd_ ex_loader_apis.up_desc_flex

In the parameter last_update_date you can pass

sysdate, replacing the value read from ldt lePlease note this is customization and is notsupportableThe reason value sets were not included isbecause they always get downloaded or uploadedalong with Flex eld Segments or Conc ProgramParameters. But anyway, please nd the script forFNDLOAD of value set

$FND_TOP/bin/FNDLOAD apps/apps 0 YDOWNLOAD $FND_TOP/patch/115/import/a f load.lct XX_SSHR_01_ETH_VALUE_SET.ldt

VALUE_SET FLEX_VALUE_SET_NAME=XX_HRMS_ETH_ORIGIN

Thanks,Anil Passi

Vikram Unde 2006-12-26 00:00

Hi Anil,

I used FBNDLOAD to donload/upload the ldt forRequest Set & its Links. I am sucsessful todownload the Request Set & its Links from oneinstance, but the upload to another instance giveserror as follows:---------------------Uploading from the data le XX_THA_GLDOIUPR

_REP_DEF.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/u02/appluat/uatappl/fnd/11.5.0/patch/115/import/afcprset.lct(115.26), XX_THA_GLDOIUPR_REP_DEF.ldt) tostage tablesDump LCT le /u02/appluat/uatappl/fnd/11.5.0/patch/115/import/afcprset.lct(115.


f 57 16/12/2014 11:10


14/57

Quote

0

Quote

0

26) into FND_SEED_STAGE_CONFIGDump LDT le XX_THA_GLDOIUPR_REP_DEF.ldtinto FND_SEED_STAGE_ENTITYDumped the batch (REQ_SET SQLGLXX_THA_GLDOIUPR_REP , STAGE_PROG 10 ) intoFND_SEED_STAGE_ENTITYUpload from stage tablesError loading seed data for STAGE_PROG:APPLICATION_SHORT_NAME = SQLGL, REQUEST_SET_NAME = XX_THA_GLDOIUPR_REP,STAGE_NAME = 1, SEQUENCE = 10, ORA-01403:nodata found---------------------Could you please advice urgently.

Thanks & Regards,

Vikram Unde

Anil Passi 2007-01-12 00:00

Hi Vikram,

The most likely cause of ORA-01403 duringFNDLOAD is that Custom Application de ned inyour dev environment does not exist on otherenvironment.

Hi Minal,I am sorry for the late response to your urgentquery, I had a busy day at work today.

For your concurrent program, the parametersmust be downloaded by default. Please email methe lct le you are using.Has anyone modi ed the afcpprog.lct in yourenvironment? Check if its version di ers fromother environment. Or email me your lct

Thanks,Anil Passi

Anil Passi 2007-01-18 00:00

.

.

.Hi Ruma,Link http://www.google.com/search?q=site:apps2fusion.com+ nd-request-group-for-concurrent-programsshould answer your question, though partially.

Which application did you attach this Request Setto? It is possible that the Request Group against


f 57 16/12/2014 11:10


15/57

Quote

0

Quote

0

Quote

0

all those responsibilities includes the Applicationwhich is attached to your Request Set.

Thanks,Anil Passi

siddh 2007-01-19 00:00

Hi,We have customized dashboard functionality intelesales. We have to move it into other instances.can you let me know how to do the download forpro le check variables, pro le checks, drilldownfor pro le checks using FNDLOAD. The lct le usedis cscprfbk.lct and cscprfck.lct

Anil Passi 2007-01-20 00:00

Hi Ruma,

I need to know the APPLICATION to which thisrequest set is attached?

Not the responsibility.

Query the Request Set from Request set de nitionscreen and see which application is that attachedto.

I think the APPLICATION associated with yourrequest set is included in most of your requestgroups.

If so is not the case, then you need to raise Tar.Although, I very much doubt this being a bug.

Thanks,Anil

Anil Passi 2007-01-20 00:00

Hi Ruma,

I need to know the APPLICATION to which thisrequest set is attached?

Not the responsibility.

Query the Request Set from Request set de nitionscreen and see which application is that attachedto.

I think the APPLICATION associated with your

request set is included in most of your requestgroups.

If so is not the case, then you need to raise Tar.Although, I very much doubt this being a bug.


f 57 16/12/2014 11:10


16/57

Quote

0

Quote

0

Quote

0

Quote

0

Quote

Thanks,Anil

siddh 2007-01-22 00:00

Hi Anil,

Can you send one example to load telesalesdashboard objects like pro le variables anddrilldown using FNDLOAD?

Thanks.-Siddh

Anil Passi 2007-01-23 00:00

Hi Siddh

I think you need to open the lct le , and see thekey parameters in DOWNLOAD section

Also see the UPLOAD section of lct, as that willhave the API calls,with parameters mapped to ldtvalues. This will give you the idea of the attributesthat can be migrated.

Thanks,Anil Passi

Venugopal 2007-01-26 00:00

Hi Anil,

I want to migrate Lookup types with their valuesfrom one instance to another. The FNDLOAD withdownload and upload runs ne for me. But thereis no data in the ldt le. There are around 1500lookup values for a particular lookup type butwhen I upload it says no data to upload. Checkedthe ldt le it shows only the lookup typede nition. Request you kindly help at the earliestThanks and RegardsVenugopal

Venugopal 2007-01-28 00:00

Anil,

eld size to varchar2(250) butg

le to you ( ). Request you to

go through and suggest changes.RegardsVenugopal


f 57 16/12/2014 11:10


17/57

0

Quote

0

Quote

0

Quote

0

Quote

0

Anil Passi 2007-01-29 00:00

Hi Venu

Use the lct le from this link.

See if this workshttp://www.apps2fusion.com/docs_apps/demo/wf /ic_a vmlu.lct

Thanks,Anil Passi

Venugopal 2007-01-29 00:00

Hi Anil,

Tried with the .lct le you provided but it is notworking. What could be the issue? Please help.

RegardsVenugopl

Nilesh 2007-01-29 00:00

Hi Anil,I have created one Oracle Alert in oneenvironment and trying to migrate it to anotherenvironment. The original alert action details texthas some formatting which is getting lost duringupload. Can you suggest me how to maintain thistext formatting?

Anil Passi 2007-01-31 00:00

.

.

.Hi Nilesh,

Interesting, I never moved alerts using fndload.But anyway, are you transferring the les in asciimode?

thanksanil

Anil Passi 2007-02-01 00:00

.

.

.Hi Alexander,

You need to do two things.1. check if your ldt le has required information,


f 57 16/12/2014 11:10


18/57


19/57

Quote

0

Quote

0

Quote

0

Quote

0

want, then simply edit the ldt le and remove theunwanted entries.

**Pls test this on other instance, I think it shouldwork, because I can see that lct le is callingfnd_menu_entries_pkg.LOAD_ROW for the Menusavailable in ldt le

Thanks,Anil Passi

Anil Passi 2007-02-02 00:00

Hi Chandra

I am yet to use iSetup myself, as I think it does notcover every possible setup.Also, it appears to be based on linking di erentenvironments which involves admni activity,

which I nd to be a turn-o of getting this agreedwith management

any wonder why not many people use iSetup?

Anil Passi 2007-02-05 00:00

Excellent stu Alexander.

Anil Passi 2007-02-13 00:00

Hi BSR

Each data type like value set , ex value etc have ainternal id generated by the sequence.

If you do export and import, the value of thesequence used to generate unique key may di erin the two environments. This can cause overlapand con icts

Hence, use FNDLOAD, because FNDLOAD usesrespective APIs

thanks,anil

Anil Passi 2007-03-12 00:00

Hi Frank,

Please check the width of the columns mentionedin lct le. Possibly one of the column have lessnumber of VARCHAR2(lenngth) than thecorresponding length in the fnd_lookup_values


f 57 16/12/2014 11:10


20/57


21/57

Quote

0

Quote

0

Quote

0

Quote

0

le which is uploaded.The reason is suppose if i have uploaded the ldt

le (Concurrent Program with values) with wrongdata, how can i rollback the ldt le.

ThanksAshok

Babu 2007-04-19 00:00

hi anil,I am using FNDLOAD to migrate a custom reportfrom the test instance to the production instance.i am able to con gure everything in theproduction system except the parameters of thereport.i have used the sample scripts that arepublished in your site, can help me out please incon guring my report parameters from the testsystem to the prodution system.thanks in advance.

Thanks & Regards,Babu.

Anil Passi 2007-04-20 00:00

Hi Babu

The scipt will download and upload the

parameters too. Simply con gure your parameterson DEV/TST, then download, and then upload onPRD

ThanksAnil

Satya 2007-04-26 00:00

Hello experts,

I have a spreadsheet which has around 300-400responsibilities and wanted to load into oracletables.

Does, anybody has any ideas what will the processinvolved these responsibilities from spreadsheetto oracle tables.

Any ideas will be highly appriciated.

-Satya

Vishnu 2007-05-09 00:00


f 57 16/12/2014 11:10


22/57

Quote

0

Quote

0

Quote

0

Quote

0

API on Status change in Property Manager

Nagesh 2007-05-23 00:00

Hi Anil,

My Request group which i would like to migratehas lot of other Programs added in that which arenot available in Prod.Hence when i try migratingthe whole request group, its throwing an errorsaying it could not nd those programs.However i would like to migrate only one programfrom that request group onto production usingFNDLOAD for reguest group.

Could you please let me know if i could migrateonly one(or couple) of concurrent progs from arequest group using FNDLOAD. I tried ltering bya parameter UNIT_NAME in it, however it giving

blank values for others and causing probs.Thanks,Nagesh

Michu 2007-05-29 00:00

Hi Anil,Can you send some information about Oracleprojects, am new to this module, I have to do

costing conversions,project conversionsThanks

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 FormFunction separately?

Please advice.

Thanks & Regards,Dhiman.

Anil Passi 2007-06-04 00:00

Hi Dhiman

If you download the menu, that will downloadboth form and form function for you.


f 57 16/12/2014 11:10


23/57

Quote

0

Quote

0

Quote

0

Quote

0

To upload just the forms or form functions, kindlyuse the UPLOAD PARTIAL mode.

Parameters for the entities are:-

FORM-------FORM_APP_SHORT_NAMEFORM_NAME

FUNCTION-----------FUNC_APP_SHORT_NAMEFUNCTION_NAME

Thanks,Anil Passi

Raj Naik 2007-06-19 00:00

Hi Anil,

Raj again, i missed one point. What about XMLReports, i mean Data De nition & Templates?

ThanksRaj Naik

Raj Naik 2007-06-19 00:00

Hi Anil,

Raj again, i missed one point. What about XMLReports, i mean Data De nition & Templates?

ThanksRaj Naik

Ashish Gairola 2007-06-20 00:00

Anil,

I need one favor.Can we migrate Assign pro leoptions and Asssign security rules usingFNDLOADER

Anil Passi 2007-06-20 00:00

HiMigrating pro les by default will transfer all thevalues for that pro le option set at all possiblelevels.


f 57 16/12/2014 11:10


24/57

Quote

0

Quote

0

Quote

0

Quote

0

With regards to Security pro les, please elaborate.Are you referring to the Rules to restrict Value setvalues?

Thanks,AniL Passi

nagender 2007-07-02 23:37

Hi anil,Good to know about FNDLOAD and itsfunctionalities.Mr. Anil can we use FNDLOAD to port reportsfrom one environment to another. Myrequirement is to port reports from 11 to 11i.

Thanks,Nagender

passianil 2007-07-03 00:06

Hi Nag

You simply need to copy the rdf le into respective$MODULE_TOP/reports/USor some other relevant language directory

thanksanil

nagender 2007-07-03 01:10

Hi Anil,Thanks for the quick reply.Bur sry, I did not getyou, my requirement is to movie all the existingreports/custom reports in 11 environment to11i(11.5.10.2) environment.How can we do this, Can it be done usingFNDLOAD.

Sorry, If I was not clear in my previous post.And also Mr.Anil, how can we preserve thecustomizations we made for forms or reportswhen we upgrade or migrate to a higher version.

Thanks,Nagender

Anil Passi 2007-07-03 21:43

Hi Nag,

If you are moving concurrent program de nitionfor the reports then of course you can useFNDLOAD.


f 57 16/12/2014 11:10


25/57

Quote

0

Quote

0

Quote

0

Quote

0

However if you are upgrading to 11.5.10, thenupgrade process will retain your custom reportsregistered with custom application

Thanks,

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 alongwith the parameters it uses and the value setsassociated with it will be stored in one tab.In shortwhat ever the data is generated by lct le in theldt le i need it as an excel sheet.I have tried toconvery the data in the ldt le into xl format butiam not successful.Now i am trying to use the lct

le and work on the code available in lct le to getthe work done.Can you please suggest me what would be thebest way to capture all the AOL related data intoan xl sheet or if there are any existing scriptsavailable other that the .lct scripts to perform the

job.Thanks,Pruthvi M.

APassi 2007-07-11 07:05

Hi Pruthvi

Your second approach, of using SQL in lct le isthe best approach.In every lct le, there is a DOWNLOAD section thatcontains SQL's used to extract data.

You should use the same SQL as that inDOWNLOAD section of lct

Thanks,Anil

Sandra 2007-07-30 07:29

Hi Anil,thank ypu for script, it helps very much.I used it for upload fnd_new_messages, uploadwas succesful,i check table value, but when I startapplication, there is no change in prompt_text atall. It is still the old value.Thanks,

Sandra

Anil Passi 2007-07-30 09:25


f 57 16/12/2014 11:10


26/57

Quote

0

Quote

0

Quote

0

Quote

0

Hi Sandra

Please request your DBA to generate messageles. That should x the issue

Thanks,Anil

Sandra 2007-07-30 14:19

Thank you Anil very much!I generate message le throw adadmin, and itworks for all applications except for fnd (formessage name with start FND_SSO%).I have one more question: I also changedescription for language in table fnd_languages_tl-what should I do to see changes in application?Regards,

Sandra

Anil Passi 2007-07-30 19:56

Hi Sandra,

Can you see the description re ected infnd_languages_vl ?You can try this from SQL*Plus, ensuring that NLSfor SQL Session is same as that for theresponsibility being used to test the changes.

Thanks,Anil Passi

Kiks 2007-08-10 14:21

Below are the commands to download & upload.ldt les useful for Alerts migration. As you know,one should use APPS or APPS_READ passwords inorder to generate the .ldt les.

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

Tuan 2007-08-29 15:05


f 57 16/12/2014 11:10


27/57

Quote

0

Quote

0

Quote

0

hello Anil,I am noving custom responsibilities that hascustom Menus and functions. Do I need toFNDLOAD custom Functions and Menus beforeFNDLOAD custom Responsibility?

Anil Passi 2007-08-30 05:46

Hi Tuan

FNDLOAD for responsiblity will download for youthings like security group, user groupHence you need to upload the MENU rst usingafsload.lct.When you FNDLOAD menu's, form funtions andform de nitions attached to the menu's will alsoget FNDLOAD'ed

ThanksAnil

Hardeep Singh 2007-09-13 07:17

Hi Anil,When we importing the journals in GL module weneed to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question iswhat is the use of inserting the data intoGL_INTERFACE_CONTROL table and if I notinserted into GL_INTERFACE_CONTROL what willhappen?

Anil Passi 2007-09-13 08:30

Hi Krishnab

If you are submitting the JournalImportprogramatically, then you must create a record in

GL_INTERFACE_CONTROL.This is so, because the GL Import process, whencalled programatically, must be passed theinterface_run_id as shown belowv_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');


f 57 16/12/2014 11:10


28/57

Quote

0

Quote

0

Quote

0

Quote

0

In case you are submitting GL Import from screen,then the screen will do the insert intogl_interface_control.

Another purpose of this table is in case you wishto use a custom or some other table for GLImport, 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 willbecome the source for importing the journals

Thanks,Anil Passi


Hi Anil,In Oracle12i they introduced LEDGER_ID insteadof SET_OF_BOOKS_ID,means is it same asSET_OF_BOOKS_ID or any other use?


Hi Anil,In Oracle12i they introduced LEDGER_ID insteadof SET_OF_BOOKS_ID,means is it same asSET_OF_BOOKS_ID or any other use?


Hi Anil,We can extract the data from in 2 ways.1.Useing UTL File2.Useing Spool

From above 2 which one is the usefull andpreferable?

Anita 2007-09-21 05:27

Hi,I want to migrate Element,Fast Formula and setupto production Env from development env. Can Imigrate Element and Fast Formula usingFNDLOAD, If you can provide sample script for theabove(FF,Element,Setup Payroll)I will be greatful toyou.


f 57 16/12/2014 11:10


29/57


30/57

Quote

0

Quote

0

Quote

0

Quote

0

Quote

0

ERFACE_PROG"

Thanks,Anil Passi

Dilee 2007-09-27 06:59

Hi Anil,

Is is posible to download the ldt les of concurrentprograms without the values of independentvaluesets?

Thanks & Regards,Dilee

ankur jaiswal 2007-10-04 07:46

Hi Anilcan we use FNDLOAD to transfer Transaction Typeset up IN AME/OAM.also,could you guide us to create new lcts.RegardsAnkur

naga 2007-10-16 16:34

Hi Anil,How can we move XML publisher reports,Templates and Data de nitions?

thanksSiva

Vishal Goyal 2007-10-19 03:47

Hi Anil,

Is there a way to transfer setups like JESources/Categories/Security Rules from Instance Ato Instance B. We have huge many setups in GLand want to xfer them, rather then using dataloader to load them again manually. I have DFFsas well on sources/categories.

Thanks.Vishal.

Anil Passi 2007-10-22 15:25

Hi Siva


f 57 16/12/2014 11:10


31/57

Quote

0

XML Publisher stores the metadata and physicalles for templates and data de nitions

in BLOB columns in its schema. XML Publisherallows you to use FNDLOADin conjunctionwith XDOLoader to allow you to move themetadata and physical les for your templatesand data de nitions from one instance toanother.

FNDLOAD can---------Upload and download the data de nitioninformation and the template metadata

XDOLoader can-------------Upload and download the physical les like (RTF,PDF, XSL-FO, XML, and XSD)

For complete details, see page 251 onwards fromthe link belowhttp://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 forGeneral LedgerSets of BooksChart of AccountsStatistical Units of MeasureAccount Code CombinationsAccounting CalendarCurrencies

Thanks,Anil Passi

vinayaksawal 2007-10-23 06:10

Hi Anil,

First of all we appreciate your dedication towardsthe APPS community. i am strong follower of yourportalI have one questionMy question may be bit wierd for you.

I need to move all the FND objects from oneinstance to another in one shot is it possible?and also to that i need whichever are present onthe destination sever should not get overlapped.?

Can you please suggest your expertise ?

Cheers,Vinay


f 57 16/12/2014 11:10


32/57


33/57

Quote

0

Quote

0

NOTE : We DO NOT provide a prompt for thesesubmenus.These menus are needed only to give theappropriate permissions for all the functionsbelow eachmenu.

2)Add the following functionsFF Assistant Cross-Business Group Search PageFF Assistant Search Pageto the SHRMS BASIC menu giving an appropriateprompt for each function(i.e. Global FastFormula Assistant and FastFormulaAssistant).Responsibility : System AdministratorNavigation : Application > Menu

3)Ensure the 'FastFormula Transaction Manager'concurrent manager isrunning on your environment.Log in as System Administrator

Concurrent > Manager > De neQuery back FastFormula Transaction Manager

Is Enabled Checkbox ticked ?If not can you :-a) Check Enable checkboxb) Save changesc) Activate Manager :-1) Navigation : Concurrent > Manager >Administer2) Query back Fast% (there should be 1 or moreprocesses).3) Click on Activate if FastFormula TransactionManager not already running

Thanks,Anil Passi

Deepthi J 2007-10-25 13:45

Hi Anil,Followed the steps and setted up the fast formulaassistant,but i am not able to upload the fastformula.I am able to download the Fast formulabut not able to upload the formula.If you knowthe process and if can explain me the same thatwould be of great help.ThanksDeepthi

Ramachandra 2007-10-29 05:49

Hi Anil

I want to pass application short name as


f 57 16/12/2014 11:10


34/57

Quote

0

Quote

0

Quote

0

Quote

0

parameters for this afscursp.lctsome of the entities like fnd_user etc... did't haveapplication table. so how can i pass applicationshort name as parameter for this afscursp.lct le.

Plese give me advise.

Thank you.RamaChandra.N

Please give me suggestions.

Anil Passi 2007-10-30 20:45

Hi Rama

Please visit http://www.google.com/search?q=site:apps2fusion.com+fndload-a-dive-into-basics for the answer to your question. Thepresentation explains that concept.

ThanksAnil Passi

Ramya 2007-10-31 18:06

Hi Anil,

I have a sample code of downloading thevaluesets,concurrent programs and Request

Groups using FNDLOAD.In the request area...in old sample code they hadused UNIT_TYPE and UNIT_NAME....what these arerelated to.

Kindly Clarify...

Ramya

punit 2007-11-05 10:07I have a requirementI have created a concurrent program, which hasparameters like cost centre number(using DFFvaluesets). I want to move the concurrentprogram from TEST to production, but i do notwant the d values from Test to overwrite thevalues in Production. Is there some way we candown load only the vlaue set name in ldt le forConcurrent progtrams not the values.

Anil Passi 2007-11-05 10:31

Hi Punit

Have a look at presentation in


f 57 16/12/2014 11:10


35/57


36/57

Quote

0

Please give me solution for these error.

Uploading from the data le xxbmc_401_menu.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59), xxbmc_401_menu.ldt) tostage tablesDump LCT le /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59)into FND_SEED_STAGE_CONFIGDump LDT le xxbmc_401_menu.ldt intoFND_SEED_STAGE_ENTITYDumped the batch (MENU *NULL* , MENU 401KMAINTENANCE ) into FND_SEED_STAGE_ENTITYUpload from stage tablesError loading seed data for FORM:

APPLICATION_SHORT_NAME = BMCS,FORM_NAME = BMCS401K, ORA-01400: cannotinsert NULL into ("APPLSYS"."FND

_FORM"."APPLICATION_ID")ORA-06512: at "APPS.FND_FORM_PKG", line 23ORA-06512: at "APPS.FND_FORM_PKG", line 277ORA-01403: no data foundError loading seed data for FORM:APPLICATION_SHORT_NAME = BMCS,FORM_NAME = BMCSLOAN, ORA-01400: cannotinsert NULL into ("APPLSYS"."FND

_FORM"."APPLICATION_ID")ORA-06512: at "APPS.FND_FORM_PKG", line 23ORA-06512: at "APPS.FND_FORM_PKG", line 277ORA-01403: no data found

and another one is

Uploading from the data le xxbmc_ar_menu.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59), xxbmc_ar_menu.ldt) to stagetablesDump LCT le /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59)into FND_SEED_STAGE_CONFIGDump LDT le xxbmc_ar_menu.ldt intoFND_SEED_STAGE_ENTITYDumped the batch (MENU *NULL* , MENUAR_CONTROL_GUI ) into FND_SEED_STAGE_ENTITYUpload from stage tables

Anil Passi 2007-11-13 15:58


f 57 16/12/2014 11:10


37/57

Quote

0

Quote

0

Hi Ramchandra,

Please run this SQL in the destinationenvironment.Does this return a record?Perhaps you haven't yet setup this customapplication on the destination environment.

select application_id from fnd_application whereapplication_short_name = 'BMCS';

Thanks,Anil Passi

Mugunthan.S 2007-11-13 16:37

Hi Anil,

We are trying to do the upgrade from 11.0.3 to11.5.10.2 (Financials). How simply can we upgradeor migrate the "Custom responsibilities/ menus(include and exclude) to the 11i environment ? Isthere a script available or is it part of the upgradeprocess.

Your help is very much appreciated.

Ramchandra 2007-11-14 03:03

Hi Anil

I am Trying to upload Responsibilities individuallyby using FNDLOAD.But, it giving error like

Uploading from the data le xxbmc_bcm_responsibility.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44), xxbmc_bcm_responsibility.ldt) to stage tablesDump LCT le /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afscursp.lct(115.44)into FND_SEED_STAGE_CONFIGDump LDT le xxbmc_bcm_responsibility.ldt intoFND_SEED_STAGE_ENTITYDumped the batch (FND_APPLICATION BMCSREV ,FND_RESPONSIBILITY BMCSREVBMC_COLLECTIONS_MANAGER ) intoFND_SEED_STAGE_ENTITYUpload from stage tablesError loading seed data for FND_RESPONSIBILITY:APPLICATION_SHORT_NAME = BMCSREV,


f 57 16/12/2014 11:10


38/57

Quote

0

Quote

0

Quote

0

RESP_KEY = BMC_COLLECTIONS_MANAGER,ORA-20001: APP-FND-01572: Invalid foreign keydata was found for this record.Value CL_BMC_COLLECTIONS_MANAGER forcolumn MENU_NAME does not exist in tableFND_MENUS_VL.

Please give me solution.

Thank you.RegardsRamchandra.N

Sanjib Kundu 2007-11-14 12:10

Hello Anil,

I nd your site very useful. Really worth goingthru all the blogs and articles.

My question to you is:We have implemented 11.5.10.2. In one of ourDevelopment instances ( clone of Productioninstance) we have created several Menu's andResponsibilities. While creating the Menu's wehave given 10, 20 , 30 , 40 ... and so on ... as theSequence Number in the De ne Menu's form.When we have FNDLOAD the same Menu's in theproduction instance the Sequence Numberchanged from 10, 20, 30 , 40 ..... to 1,2,3,4.

Why this has happened.

Thanks,

Sanjib Kundu Jamshedpur, INDIA

Nitin Gaopande 2007-11-14 13:02

Hi Anil,Following are my questions.Hope I get answers:1. When a concurrent program is downloaded, isEXECUTABLE not required to be downloaded too?or it is created automatically or manually has tobe created??2. Can FNDLOAD delete program once created(but not yet run)??

Thnks for this inforamtive siteNitin :)

vivekclement 2007-11-15 11:35

Hi,We have the sameI want to override the existing Menu's in the 1stinstance with the new menu from the 2ndinstance. But on a normal FNDLOAD upload it


f 57 16/12/2014 11:10


39/57

Quote

0

Quote

0

appends to the existing menu items.Is there any option by which i can upload withoutdeleting the submenu's on the table level and doit from the FNDLOAD itself ?

Vinay 2007-11-16 04:57

While Transferring Cocurrent programme throughFNDLOAD,will it transfer the value set with that.If not how that can be achived.

Thanks & Regards

Vinay

Ramchandra 2007-11-16 09:04

Hi anil I am uploading menus by useing fndload.While uploading i am getting log les.

1)Uploading from the data le /u001/app/applmgr/ftp/xxbmc_menu_24_BMCSREV_OE _USER.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/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) tostage tablesDump LCT le /u001/app/ocap2dv1/ocap2dv1appl/fnd/11.5.0/patch/115/import/afsload.lct(115.59)into FND_SEED_STAGE_CONFIGDump LDT le /u001/app/applmgr/ftp/xxbmc_menu_24_BMCSREV_OE _USER.ldt intoFND_SEED_STAGE_ENTITYDumped the batch (MENU *NULL* , MENUBMCSREV_OE _USER ) into FND_SEED_STAGE_ENTITYUpload from stage tableswherelogon is username/password[@connect]mode is UPLOAD, UPLOAD_PARTIAL orDOWNLOADcon g le is the con guration ledata le is the data leentity is an entity name, or - to specify all values inan uploadparam is a NAME=VALUE string used forparameter substitutionbatch_id is batch id

Please give me solution for this.

thank you.Regards


f 57 16/12/2014 11:10


40/57

Quote

0

Quote

0

Quote

0

Quote

0

Quote

0

Quote

0

Ramachandra.N

prabhakarreddy 2007-11-19 04:12

hi anil,i want information about tuning in RICE

cpmponents.plsePlease give me solution for this.

Thanks and RegardsPrabhakar

Ashish_arora 2007-11-26 09:43

Can u please provide anything related to Lookuptype which is missing in this how to download orupload lookups.

ramanath kamath 2007-11-27 09:04

Hi Anil,please provide detailed information regardingbacking up of request sets and trading partnersetups

ThanksRamanath Kamath

amresh 2007-12-18 08:46

Hello Anil,

How to use in the case of Multilingual Concurrentprograms.Means from english to di rent languges.

Thanks & Regards,Amresh

RahulHRMS 2008-01-16 15:16

Hi all ,

How do i download EIT's.

Thanks ,Rahul

Anil Passi 2008-01-16 15:56


f 57 16/12/2014 11:10


41/57

Quote

0

Quote

0

Quote

0

Quote

0

Hi Rahul

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

Thanks,Anil Passi

madhusudhan padamatinti 2008-01-1812:26

Hi Anil,This page is very good and helps a lot. But i haveone questionI have created one work ow noti cation in oneenvironment and trying to move it to anotherenvironment. Can you suggest me how to movethis noti cation?Regards--------madhu

Anil Passi 2008-01-18 12:48

Hi Madhu

Please use WFLOAD command to upload yourwork ow wft le to other environments.

Please search metalink for w oad syntax

Thanks,Anil Passi

Jim Boyland 2008-01-25 14:14

I only want to migrate one concurrent programfrom one instance to another.I used fndload to download one concurrentprogram and the .lct le seems to containevery de nition for the custom applicationshortname.I am hesitant to upload it

FNDLOAD apps/apps002 O Y DOWNLOAD$FND_TOP/patch/115/import/afcpprog.lct29599_prog.ldt PROGRAM APPLICATION_SHORT_NAME="TFND" CONCURRENT_PROGRAM_NAME="Tupperware DBA Rebuild Indexes"

Anil Passi 2008-01-25 19:43


f 57 16/12/2014 11:10


42/57


43/57

Quote

0

Quote

0

Hi,

I generated message le throw adadmin for ICXmodule and I've got next messages: "No OracleMessage les selected for generation".Message les for other modules can be generatedsuccessfuly and I have a problem only for this one.What could be a cause?

And is there a solution?Tnx in advance!Natasa

raj6367 2008-02-26 14:45

Hi Folks,

I am using FNDLOAD utility to migrate the req setsfrom one instance to another. But the req sets are

not being updated, after the rst time. I mean if imake any changes to req set in dev, thendownload the req set using FNDLOAD and migratethe same to UAT and upload it. The new changesare not re ected. Am i missing any steps here!!please help. I am also trying by using FORCE foruploading.

for dowload this is the command i used:

FNDLOAD apps/$CLIENT_APPS_PWD 0 YDOWNLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_DEF.ldt REQ_SETREQUEST_SET_NAME="FNDRSSUB1992"FNDLOAD apps/$CLIENT_APPS_PWD 0 YDOWNLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB1992_REQ_SET_LK.ldtREQ_SET_LINKS REQUEST_SET_NAME="FNDRSSUB1992"

For upload this is what i used.


$FND_TOP/patch/115/import/afcprset.lctFNDRSSUB1992_REQ_SET_DEF.ldtFNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD$FND_TOP/patch/115/import/afcprset.lctFNDRSSUB1992_REQ_SET_LK.ldt

Thanks.

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 canwe generate it or migrate it ?


f 57 16/12/2014 11:10


44/57

Quote

0

Quote

0

Quote

0

Thanks

Srini 2008-04-12 13:04

Hi Anil,

I have seen this question posted before, but somehow, I did not nd any answer for this. I havegone through your presentation located at:http://www.google.com/search?q=site:apps2fusion.com+fn...ics-2

We are using FNDLOAD utility to migrate AOLobjects between instances. This utility migratesthe value set values, automatically, along withdefeinition of concurrent program, if theconcurrent program has any parameter tied to anindependent value set. This is causing a majorissue of corrupting value set values in the targetinstance. Is there any option for FNDLOAD, not to

bring these value set values from source to targetinstance, while migrating concurrent programs?Are there any other AOL objects behave the sameway?

I have checked the UPLOAD_PARTIAL option. Butit is to upload certain given entity, but I did notsee any option not to load certain entity from adownloaded ldt le.

I appreciate your help. This site is really the bestone. It has got more detailed information thanany other sites/discussion forums, includingmetalink.

Thanks,Srini

Anil Passi 2008-04-12 16:12

Hi Srini

You can use UPLOAD_PARTIAL, and upload onlythe desired entities.Please have a look at presentation inhttp://apps2fusion.com/technical-articles-mainmenu-27/miscellaneous-mainmenu-40/21-miscellaneous-technology/198-fndload-a-dive-into-basics

Thanks,Anil Passi

Srini 2008-04-12 19:09

Thanks Anil, for your prompt reply.

So in this case for uploading a concurrent


f 57 16/12/2014 11:10


45/57


46/57

Quote

0

Quote

0

Quote

0

Or do I have to use multiple times, one for eachentity in the concurrent program ldt le? BecauseI have to just exclude value set values, but allother entity de nitions from the downloaded ldt

le should be uploaded in the target instance.

What is the best practice? Is any documentationby Oracle?

Thank You Very much for your help.

-- Srini

Anil Passi 2008-04-13 18:09

Hi Srini

Yes, you should be able to specify multiple entitiesat command line.You do that anyway for download too, for

example, for downloading a single concurrentprogram, you can give Conc Short Name and theApplication Short Name together.

Thanks,Anil Passi

Valeria 2008-04-25 14:21

Hello Anil,First, I like to thanks for all the valuable worksthat you done.I am working on the FNDLOAD the pro le optionand have a question about it.I am moving the value of all required pro leoptions for custom responsibilities from instanceX to instance Y. However, instance X has moreresponsibilitiesthan instance Y. What would happen when Iupload the pro le options from X to Y?

Anil Passi- 2008-04-25 15:54

HI Tuan

FNDLOAD for pro le options does not extractresponsibility_id's.What happens is thisDURING DOWNLOAD1. For pro le values at resp level, responsibilitykeys are downloaded

DURING UPLOAD

1. The responsibility keys from downloaded leare translated into responsibility_id [if found]2. The responsibility_id is then loaded usingFNDLOAD into pro le options value table


f 57 16/12/2014 11:10


47/57


48/57

Quote

0

Quote

0

Quote

0

Quote

0

Options but it error out. Can you please help?Thanks,Tuan

Anil Passi 2008-05-17 16:05

Hi TuanLooks like one of the users or the responsibility inldt le from source system does not exist in targetsystem.Have you migrated all the new responsibilitiesfrom source to target, retaining the ResponsibilityKey? Likewise for FND_USER.USER_NAME

Thanks,Anil Passi

Valeria 2008-05-19 08:58

Hello Anil,Both source and target instance are CRP instance.I only migrated the responsibilities that wewanted to keep and carry over to the futureproduction instance. Therefore, the targetinstance has less responsibilities than the sourceinstance. Also, the FND_USER.USER_NAME is notthe same. I am not sure if my DBA abort the job or

it abort itse when encounter the error but I didnot see any thing came over to the targetinstance. I ws hoping that it would skip to thenext record when responsibility key was notfound. Do you have any other advise? since I donot want move unwanted responsibilities to moveto the target instance.Thanks,Tuan

Anil Passi 2008-05-19 09:03

If you do not want unwanted responsibilities to bemoves across, then you will have to manuallycleanup the ldt le.

Prabhakar Somanathan 2008-06-30 08:19

FNDLOAD apps/$CLIENT_APPS_PWD 0 YDOWNLOAD $FND_TOP/patch/115/import/a f load.lct XXX_FND_COMMON_LOOKUPS_DFF.ldtDESC_FLEX APPLICATION_SHORT_NAME=FNDDESCRIPTIVE_FLEXFIELD_NAME='FND_COMMON_LOOKUPS' DESCRIPTIVE_FLE


f 57 16/12/2014 11:10


49/57

Quote

0

Quote

0

Quote

0

Quote

0

Quote

0

X_CONTEXT_CODE='XXX_STATUS'

Anil Passi 2008-06-30 08:21

Cheers Prabhakar, for sharing this, as it is acommon practice to download just one single DFF

structure.

Ram Balasubramanyan 2008-07-16 13:13

Hi,

Can FNDLOAD be used to migrate OA FrameworkPersonalizations also? Pl. let me know, if there isany others way of migrating these from oneinstance to another.

ThanksRam Balasubramanyan

Anil Passi- 2008-07-16 14:38

To move OAF Personalizations, do this1. Login to Functional Administrator responsibility2. Navigate to Personalization tab, and within thatImport ExportEnsure that Ro;oti;r% pro le is set to a validdirectory on mid-tier

ThanksAnil Passi

Anil Passi- 2008-07-16 14:49

Hi Ram

Have a look at this link http://apps2fusion.com/apps/oa-framework/14-fwk/215-move-oa-framework-personalizations-from-one-environment-to-another

Thanks,Anil Passi

Valeria 2008-08-01 16:44

Hello Anil,Have you done the FNDLOAD for collectionelements and collection plans? Can we useFNDLOAD for this? Can you give an example? Youradvise is greatly appreciate here.


f 57 16/12/2014 11:10


50/57

Quote

0

Quote

0

Quote

0

Quote

0

Thanks in Advande

Anil Passi 2008-08-02 01:37

No I haven't

But you can cd to $MODULE_TOP/patch/115/import/ and grep for collection tables within lct

les.

Thanks,Anil Passi

Elaine Fortin 2008-08-08 16:30

Hi Anil,I'm getting the error:"An entity must be speci ed for the downloadoperation." when running this command:

$FND_TOP/bin/FNDLOAD apps/***** 0 Ydownload $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt XDO_DS_DEFINITIONSAPPLICATION_SHORT_NAME='HUICX'DATA_SOURCE_CODE='HUICXDELEGRPT'

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

Thanks,Elaine

Shiraz 2008-08-10 03:35

Hi Anil,

Plese can you give the syntax for DownloadingElement Types with Input Values using FNDLOAD.

Please if you can help us ASAP, I shall be greatfulto you.

Thanks,Shiraz

Anil Passi 2008-08-10 03:57

Try the below

Quote:FNDLOAD apps/$CLIENT_APPS_PWD O Y

DOWN LOAD $ PAY_ TOP/p a t ch /11 5 / imp o rt

/pypet t . lc t XX_ELEMENT_TYPE_NAME.ld t


f 57 16/12/2014 11:10


51/57

Quote

0

Quote

0

Quote

0

Quote

PAY_ELEMENT_TYPES

E_ ELEMENT_ NAME= ELEMENTNAMEHERE

Shiraz 2008-08-10 04:40

Hi Anil,

Many thanks for the quick response.

select * from PAY_ELEMENT_TYPES_F whereelement_name like 'test1'O/p gives 1 record

But FNDLOAD apps/**** O Y DOWNLOAD$PAY_TOP/patch/115/import/pypett.lct test1.ldtPAY_ELEMENT_TYPES E_ELEMENT_NAME="test1"Gives no data in ldt le, when substitutedE_ELEMENT_NAME with ELEMENT_NAME is theabove FNDLOAD command, it gives some data butnot for "test1"Please advice ...

Shiraz 2008-08-10 05:29

Hi Anil,

Thanks for you support.

We have found the problem, its with the lct le ascondition "BUSINESS_GROUP_ID is NULL " ishard-coded in it. We have a Business groupde ned.Please advice if we can change the condition in lct& Download from UAT instance & Upload toProduction instance...

Thanks again,Shiraz

Anil Passi 2008-08-10 06:10

Hi Shiraz,

Another problem you will face is that input valueswill not be downloaded and uploaded via that lct

le.Perhaps FNDLOAD is not ideal for what you aretrying to achieve.

You should also have a look at Oracle iSetup

Thanks,Anil Passi


f 57 16/12/2014 11:10


52/57

0

Quote

0

Quote

0

Quote

0

Quote

0

Cyril 2008-09-23 05:09

Hi,

I reply to the issue of Yann concerning thecompiled_value_attributes.

I understand you have infact two elds topopulate in the compiled_value_attributes withthe values Y and Y (that you have changed with Nand N). To solve your problem, modify the ldt lereplacing :'Y

Y'by : 'Y'||chr(10)|| 'Y'

Then you can upload in the destinationenvironment.

Hope it can help you.

Bye

Cyril

Parag gurjar 2009-02-14 01:25

Anilcan you suggest me how to move fast formulafrom one bg to other in bulk

Annada 2009-04-14 11:09

Hi,

We want to transfer all the customized objects infnd_top from one instnce to another because weare not copying fnd_top.

Can you please help me out.Its very very urgent.. Thanks a lot

Anil Passi 2009-04-27 15:37

You can download by specifying the ApplicationShortname , leaving the object name blank.You will have to do this for each lct le separately

ThanksAnil Passi

Tina 2009-04-28 06:18

Hi,


f 57 16/12/2014 11:10


53/57

Quote

0

Quote

0

Quote

0

I want to download concurrent program alongwith executable and value sets (even customones). Can you please let me know the correctcommand?

nishant 2009-05-15 03:04

Hello,

Can some one email me how to download andupload the KFF and Pro le option de nitions !am not able to do that.

Nishant

aryan 2009-07-06 09:53

Hello Anil,Can we use fndload to migrate the concurrentprograms from 11i ebs to R12 ebs.

Thank you.

Siddharth Shah 2009-11-18 12:32

Hi Anil,I am trying to create request set from oneinstance to another. I have downloaded the ldtand am trying to upload the ldt and getting thiserror.Uploading from the data le SITEL_GLSTRING_SET.ldtAltering database NLS_LANGUAGE environment toAMERICANDump from LCT/LDT les (/prod/prodappl/fnd/11.5.0/patch/115/import/afcprset.lct(115.28),SITEL_GLSTRING_SET.ldt) to stage tablesDump LCT le /prod/prodappl/fnd/11.5.0/patc

h/115/import/afcprset.lct(115.28) intoFND_SEED_STAGE_CONFIGDump LDT le SITEL_GLSTRING_SET.ldt intoFND_SEED_STAGE_ENTITYDumped the batch (REQ_SET SITGLFNDRSSUB2458 , STAGE_PROG 10 ) intoFND_SEED_STAGE_ENTITYUpload from stage tablesError loading seed data for STAGE_PROG:APPLICATION_SHORT_NAME = SITGL,REQUEST_SET_NAME = FNDRSSUB2458,

STAGE_NAME = STAGE10, SEQUENCE = 10,ORA-01403: nodata foundI checked for the application and it exists. Pleasesuggest.Thanks in advance.


f 57 16/12/2014 11:10


54/57


55/57

0

Quote

0

Quote

0

Quote

0

Quote

0

Quote

sachinpy 2011-07-01 05:31

We are using OM_POST_BOOK_EVENT for writingpersonalization on sales order form post booking.When we try to create LDT, this record is skipped.When we changed it to seeded (LOV) likewhen_new_form_instance or when_new_block_instance, it gets extracted in LDT le.

Any idea what needs to be done?Is this an issue with FNDLOAD with customevents?

SurdAce 2012-10-18 07:57

Hi I have a valueset with d ... is there any way ican you FNDLOAD to download the valueset withits values and the d assigned to the values.

NP 2013-04-01 21:59

Hi Anil,

FNDLOAD for lookup works ne for a commonlookup, but for responsibility speci c ones (theones with the Global Security check box NOTCHECKED) it doesnt create the le correctly!!! Anysuggestions?? does the lct le change other thana vmlu.lct

RegardsNP

Cornell 2014-08-26 18:38

I'm trying to migrate a new Descriptive Flex eldsegment from development to QA machines.

It seems the FNDLOAD for DFF exports allsegments for a table. But there's a commentabove about how it can work for a speci edsegment.How does one do that?

Thank you

Anil Passi 2014-08-26 19:19

Please edit the downloaded le and retain justthose segments,

Thanks,Anil


f 57 16/12/2014 11:10


56/57


57/57

Oracle Golden Gate Training

Oracle Data Integrator Training

SLA Part 8 - Creating Application Accounting

De nition - AAD

Oracle Fusion Procurement Training

Oracle ADF TrainingOracle SOA 12c is exciting

Oracle Fusion Applications DBA - Live scenario

question

Linkage between Oracle EBS HR FND_USER and

Oracle IDM OIM AD

Do you need Training - Contact Us

Running user role synchronization processes in

Fusion AppsOracle Fusion HCM Core Implementation Training

Fusion General Ledger integration with Essbase

Short Hand Alias in Fusion Financials Key Flex eld

Our Oracle Press Books

Oracle Fusion HCM - Some cool features


document sur la redirection d’imprimante dans le bureau à distance

Documents