R12.2 Apps DBA. Powered by Blogger.

problem viewing new XML Publisher output generated.

No comments :
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

No comments :

Post a Comment

Note: only a member of this blog may post a comment.