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.
