Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: Unable to Find an Output Post Processor Service to Post-Process Request, "FRM-40212: Invalid value for field MGR_TYPE_ICM"
"Unable to find an Output Post Processor service to post-process request"
When the Concurrent Manager Define form , FNDCPDCQ, is queried for the 'Output Post Processor' manager, FNDCPOPP, the following error occurs.
"FRM-40212: Invalid value for field MGR_TYPE_ICM"
Symptoms:
All the Bi Publisher reports are failing with the warning : "Unable to find an Output Post Processor service to post-process request"
When the Concurrent Manager Define form , FNDCPDCQ, is queried for the 'Output Post Processor' manager, FNDCPOPP, the following error occurs.
"FRM-40212: Invalid value for field MGR_TYPE_ICM"
Solution:
The value for the MANAGER_TYPE/SERVICE_ID columns in certain tables is < 1000 .
1. Backup the tables from sqlplus...
create table fnd_cp_services_tl_bak as select * from fnd_cp_services_tl
create table fnd_cp_services_bak as select * from fnd_cp_services
create table fnd_concurrent_queues_bak as select * from fnd_concurrent_queues
2.Run the following select statement to bring back a numeric value for the manager type for FNDCPOPP eg 21 .
create table fnd_cp_services_tl_bak as select * from fnd_cp_services_tl
create table fnd_cp_services_bak as select * from fnd_cp_services
create table fnd_concurrent_queues_bak as select * from fnd_concurrent_queues
2.Run the following select statement to bring back a numeric value for the manager type for FNDCPOPP eg 21 .
select CONCURRENT_QUEUE_NAME,MANAGER_TYPE from fnd_concurrent_queues
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP';
3. Shutdown the concurrent managers eg adcmctl.sh stop apps/apps
4. Update the tables using the sql below
( Use the numeric value obtained from step 2 to replace '21' in the sql statements below )
update fnd_cp_services
set service_id=1091
where service_id=21;
update fnd_cp_services_tl
set service_id=1091
where service_id=21;
update fnd_concurrent_queues
set manager_type=1091
where manager_type=21;
5. The three sql statements above should update 1 row each, if all 3 do this then commit otherwise rollback.
6. Restart the concurrent managers eg adcmctl.sh start apps/apps
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP';
3. Shutdown the concurrent managers eg adcmctl.sh stop apps/apps
4. Update the tables using the sql below
( Use the numeric value obtained from step 2 to replace '21' in the sql statements below )
update fnd_cp_services
set service_id=1091
where service_id=21;
update fnd_cp_services_tl
set service_id=1091
where service_id=21;
update fnd_concurrent_queues
set manager_type=1091
where manager_type=21;
5. The three sql statements above should update 1 row each, if all 3 do this then commit otherwise rollback.
6. Restart the concurrent managers eg adcmctl.sh start apps/apps
References:
Unable to Find an Output Post Processor Service to Post-Process Request [ID 783046.1]
1 comment:
just dropping by to say hey
Post a Comment