Tuesday, October 24, 2017

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.

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...