problem viewing new XML Publisher output generated.
It was found that some to the output file is still pointing to BP11 (11i ) path. Need to update the tables to fix the current issue.Please validate the below action plan and confirm to proceed during the maintenance window.
Action plan:
backup the table though before executing the action plan
select count(*) from FND_CONC_REQ_OUTPUTS where file_name like '%/u01%out%';
select count(*) from FND_CONC_REQ_OUTPUTS where file_node_name='ERPCCP1';
update FND_CONC_REQ_OUTPUTS set
FILE_NAME=replace(FILE_NAME,'/u01/home/bp11/bp11comn/admin/bp11/out','/u11/home/ebsprd/fs_ne/inst/ebsprd/conc/out');
update FND_CONC_REQ_OUTPUTS set FILE_NODE_NAME='EBSX01APPP05'
where FILE_NODE_NAME='ERPCCP1';
Commit;
Currently we have the below
SQL> create table FND_CONC_REQ_OUTPUTS_BAK as select * from FND_CONC_REQ_OUTPUTS;
Table created.
SQL> select count(*) from FND_CONC_REQ_OUTPUTS where file_name like '%/u01%out%';
COUNT(*)
----------
19443
SQL> select count(*) from FND_CONC_REQ_OUTPUTS where file_node_name='ERPCCP1';
COUNT(*)
----------
19443
SQL> update FND_CONC_REQ_OUTPUTS
2 set FILE_NAME=replace(FILE_NAME,'/u01/home/bp11/bp11comn/admin/bp11/out','/u11/home/ebsprd/fs_ne/inst/ebsprd/conc/out');
19660 rows updated.
SQL> update FND_CONC_REQ_OUTPUTS set FILE_NODE_NAME='EBSX01APPP05'
2 where FILE_NODE_NAME='ERPCCP1';
19443 rows updated.
SQL> commit;
Commit complete.
SQL> select count(*) from FND_CONC_REQ_OUTPUTS where file_name like '%/u01%out%';
COUNT(*)
----------
0
SQL> select count(*) from FND_CONC_REQ_OUTPUTS where file_node_name='ERPCCP1';
COUNT(*)
----------
0
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.