EBS : View the concurrent output files *.pdf *.excel in the clone instance

The solution to view the output files is to update the tables fnd_conc_req_outputs, fnd_concurrent_requests.

1.        Create the backup of both the tables fnd_conc_req_outputs, fnd_concurrent_requests

      create table fnd_conc_req_outputs_bkp as select * from fnd_conc_req_outputs;

      create table fnd_concurrent_requests_bkp as select * from fnd_concurrent_requests;

2.       Update the columns in both the tables listed below accordingly.

fnd_concurrent_requests
Column Name	Value
file_name	OS file path for output logfile
file_node_name	node name
fnd_conc_req_outputs
Column Name	Value
logfile_name	OS file path for request logfile
logfile_node_name	node name
outfile_node_name	node name
outfile_name	OS file path for output logfile

3.       Update statements:

update fnd_conc_req_outputs set file_name=replace(file_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn'), file_node_name='DEV';

commit;

update fnd_concurrent_requests set

logfile_name=replace(logfile_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn'),

logfile_node_name='DEV', outfile_node_name='DEV',

outfile_name=replace(outfile_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn') where logfile_name like '%prod%';

commit;