Move concurrent program from One Instance to Another Instance with same name

Move concurrent program from One Instance to Another Instance with same name. It should work under the same responsibility and

request

Use FNDLOAD commands.

concurrent program name:

Instance :

Solved:

Step 1. Connect toad to and check the

application_short_name,

concurrent_program_name,

request_group_name and other required information using below query.

SELECT b.application_id, b.concurrent_program_id, b.concurrent_program_name,

b.executable_application_id, b.executable_id, b.iprog_id,

t.user_concurrent_program_name, t.description,

fa.application_short_name, fa.basepath, fa.product_code,

fat.application_name, fat.description application_description,

frgu.application_id request_application_id, frgu.request_group_id,

frgu.request_unit_id, frgu.unit_application_id, frg.request_group_name,

frg.description request_group_description

FROM fnd_concurrent_programs_tl t,

fnd_concurrent_programs b,

fnd_application fa,

fnd_application_tl fat,

fnd_request_group_units frgu,

fnd_request_groups frg

WHERE b.application_id = t.application_id

AND b.concurrent_program_id = t.concurrent_program_id

AND t.LANGUAGE = USERENV ('LANG')

AND fa.application_id = t.application_id

AND fat.application_id = t.application_id

AND frgu.request_unit_id = t.concurrent_program_id

AND frgu.unit_application_id = t.application_id

AND frg.request_group_id = frgu.request_group_id

AND frg.application_id = frgu.application_id

AND t.user_concurrent_program_name LIKE '& Program Name';

Step 2. Now run the below query for application_short_name and other required information.

SELECT fr.responsibility_key, fat.application_name, fa.application_short_name,

fa.basepath, fa.product_code, fr.application_id, fr.request_group_id,

fr.responsibility_id, fr.data_group_application_id, fr.menu_id,

fr.group_application_id

FROM fnd_responsibility fr, fnd_application_tl fat, fnd_application fa

WHERE 1 = 1

AND fa.application_id = fat.application_id

AND fat.application_id = fr.application_id

AND (fr.request_group_id, fr.application_id) IN (

SELECT frgu.request_group_id, frgu.application_id

FROM fnd_concurrent_programs_tl t,

fnd_concurrent_programs b,

fnd_application fa,

fnd_application_tl fat,

fnd_request_group_units frgu,

fnd_request_groups frg

WHERE b.application_id = t.application_id

AND b.concurrent_program_id = t.concurrent_program_id

AND t.LANGUAGE = USERENV ('LANG')

AND fa.application_id = t.application_id

AND fat.application_id = t.application_id

More Next Blog»

10/24/2017 Oracle Applications: Move concurrent program from One Instance to Another Instance with same name. It should work under the same re…

http://oracleapps88.blogspot.com/2011/06/move-concurrent-program-from-to.html 2/3

Newer Post Home Older Po

Subscribe to: Post Comments (Atom)

Best Blogger Gadgets

Posted by Raju Chinthapatla at 7:19:00 PM

Labels: AOL, LDT, REPORTS, SCRIPTS

AND frgu.request_unit_id = t.concurrent_program_id

AND frgu.unit_application_id = t.application_id

AND frg.request_group_id = frgu.request_group_id

AND frg.application_id = frgu.application_id

AND t.user_concurrent_program_name LIKE '&Programe Name')

Step 3. Now login to Putty in . And run the below command to get concurrent program related ldt file. Change the ldt file name, application_short_name and

concurrent_program_name as per your our requirement.

FNDLOAD (Data Base user Name)/(Data Base PassWord) O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_PROG.ldt

PROGRAM APPLICATION_SHORT_NAME="CUSTOM" CONCURRENT_PROGRAM_NAME="CUSTOMAGINGBUCKET"

We will get ldt and log file.

Step 4. Also run the below command for getting Request Group related ldt file. Again change the ldt file name, request_group_name, application_short_name and unit_name a

per your our requirement. Here unit_name is nothing but concurrent_program_name.

FNDLOAD (Data Base user Name)/(Data Base PassWord) O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_MY_REPORT_GROUP_NAME2.ldt

REQUEST_GROUP REQUEST_GROUP_NAME="All Reports" APPLICATION_SHORT_NAME="PO" REQUEST_GROUP_UNIT

UNIT_NAME="CUSTOMAGINGBUCKET"

Now again we will get another ldt and log file.

Step 5. Connect to PSFTP and get the both ldt file and report file (if concurrent program is used for report) into local drive.

Step 6. Now disconnect putty from instance and connect to .

Step 7. Now disconnect PSFTP from instance and connect to . Now put the both downloaded ldt file and report file (if concurrent program is used for report) into unix drive.

Step 8. Now run the below command for register the concurrent program. Change the ldt file name if we had changed in above code.

FNDLOAD (Data Base user Name)/(Data Base PassWord) O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_PROG.ldt

Step 9. Now run the below command for assigning the program to request group. Here also change the ldt file name if we had changed in above code.

FNDLOAD (Data Base user Name)/(Data Base PassWord) O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_MY_REPORT_GROUP_NAME2.ldt

Step 10. Now verify the program from the front end.