This discussion is archived
2 Replies Latest reply: Dec 8, 2011 12:51 AM by 884825 RSS

Standard Manager executing other programs which are not INCLUDED .

884825 Newbie
Currently Being Moderated
hello guys,

We are having eBiz 11.5.9 environment and 9.2.0.6 Database on AIX 5.3 32-bit environment.

I am new to this client's environment and found that, there are 3 include specialization rules defined for Standard Manager which does not include "Active Responsibilities" program but still this Standard Manager is executing "Active Responsibilities" without any issues.

How is this possible ???

Ideally, Standard Manager should only run those 3 included programs ONLY and for rest of the programs which are not assigned to any of the concurrent manager , we should get "INACTIVE/No Manager" message.

My 2nd question is, when I am running this oracle seeded script $FND_TOP/sql/afrqscm.sql which shows the manager assigned to the perticular request id, it gives the below output,(Below is request id is for "Active Responsibilities")

===================================
SQL> @afrqscm.sql
Enter request ID : 22035368

Request 22035368 can be run by the following concurrent managers:

Running Manager
- - - - - - - - - - - - - - -
20 STANDARD
0 ALTS

Below are the active concurrent manager log filenames:

no rows selected
===================================



In our environment , ALTS is DISABLED manager without having any specialization rules attached to it and its basically a "Backup standard manager".

I am wondering, what setup is required to have backup concurrent manager like ALTS which will take care of requests in case standard manager goes down ?????

Ebiz architecture is one Admin/conc/db Tier (Aix 32 bit) and 5 Web nodes ( RHEL Linux 32 bit).

Thanks,
Prasad

Edited by: 881822 on Dec 7, 2011 3:00 AM
  • 1. Re: Standard Manager executing other programs which are not INCLUDED .
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I am new to this client's environment and found that, there are 3 include specialization rules defined for Standard Manager which does not include "Active Responsibilities" program but still this Standard Manager is executing "Active Responsibilities" without any issues.

    How is this possible ???
    Was the CM bounced after setting the specialization rules?
    I am wondering, what setup is required to have backup concurrent manager like ALTS which will take care of requests in case standard manager goes down ?????
    Please see http://docs.oracle.com/cd/B53825_08/current/acrobat/121sacg.pdf (Page 7-2).

    Thanks,
    Hussein
  • 2. Re: Standard Manager executing other programs which are not INCLUDED .
    884825 Newbie
    Currently Being Moderated
    Hi Hussein,

    Thnks for your reply,

    My second doubt is resolved as even though there are no specialization rules assigned to ALTS manager , that means it is exactly the same as that of Standard Manager and will execute all the programs. Below is statement from your mentioned pdf ,

    =========
    Specialize your manager to run only certain kinds of requests. Without specialization rules, a manager accepts requests to start any concurrent program.
    =========


    Regarding your first question, Yes , we do bounce managers once in a month , below is the status of those two conc programs which are INCLUDED in Standard Manager.



    SQL> select 'Concurrent program '||fcp.concurrent_program_name||' is ' ||decode(fcqc.include_flag,'I','included in ','E','excluded from ')||fcqv.user_concurrent_queue_name specialization_rule_details from fnd_concurrent_queues_vl fcqv,fnd_concurrent_queue_content fcqc,fnd_concurrent_programs fcp where fcqv.concurrent_queue_id=fcqc.concurrent_queue_id and fcqc.type_id=fcp.concurrent_program_id and fcp.concurrent_program_name='CPINR080C';

    SPECIALIZATION_RULE_DETAILS
    - - - - - - - - - - - - - - -
    Concurrent program CPINR080C is included in Standard Manager
    Concurrent program CPINR080C is excluded from TESTPlus General

    SQL> select 'Concurrent program '||fcp.concurrent_program_name||' is ' ||decode(fcqc.include_flag,'I','included in ','E','excluded from ')||fcqv.user_concurrent_queue_name specialization_rule_details from fnd_concurrent_queues_vl fcqv,fnd_concurrent_queue_content fcqc,fnd_concurrent_programs fcp where fcqv.concurrent_queue_id=fcqc.concurrent_queue_id and fcqc.type_id=fcp.concurrent_program_id and fcp.concurrent_program_name='CPDOR270C';

    SPECIALIZATION_RULE_DETAILS
    - - - - - - - - - - - - - - -
    Concurrent program CPDOR270C is excluded from TESTPlus General
    Concurrent program CPDOR270C is included in Standard Manager


    Thanks,
    Prasad

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points