APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 37,356 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    August 2012
    M T W T F S S
    « Jun   Nov »
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
  • Archives

  • Authors

Not able to cancel concurrent request & Unable to activate CM after cloning

Posted by appsinfo on August 20, 2012

Below are the two issues that I have faced after cloning from production

Q: How to terminate a concurrent request that cannot be cancelled

1.  Identify the request number to terminate.

2.  Shut down the concurrent managers and issue the following sql command as applsys:

            update fnd_concurrent_requests  set status_code = ‘E’, phase_code = ‘C’  where Request_id = <reqnum>; (reqnum = request number)

Q: A Manager is not activating.         

Check the count in sys.dual, system.dual, & apps.fnd_dual. There should only be one (1) row for each. 
If the count is greater, change to one only. This can be done from sqlplus as  follows:

    As user apps:
                   select * from SYS.DUAL;

    Any extra rows should be deleted.

                   delete rownum from SYS.DUAL; (rownum = the row number to delete)

    Any extra rows for apps.fnd_dual must be removed by performing the following SQL command:

                 delete from fnd_dual where rownum < (select max(rownum) from fnd_dual);

**For more on concurrent managers you can refer to FAQ (Concurrent Manager Unix specific Note ID: 105101.1)**

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: