Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: Control Code in FND..

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Control Code in FND..

    I see one query but I did not get the meaning of -

    Update fnd_concurrent_queues set control_code = null where control_code ='N';

    When we are going to run this query and what purpose does control code in FND_CONCURRENT_QUEUE serve?
    Last edited by ajaysingh; 10-31-2011 at 12:04 PM. Reason: detail

  2. #2
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31
    I want to ask control code N purpose...further.

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Control Code 'N' stand for Target Node or Queue ie Concurrent Manager not being Available.
    This status needs to be cleared off.

    The statement you have stated here is to clear this Status.
    This is also a part of the cmclean.sql script , which is used to clean the state of concurrent managers and requests.

+ Reply to Thread

Similar Threads

  1. OEM Grid Control Training in Delhi : Online Grid Control 11g Training
    By Hemant in forum Oracle Training Modules - Database RAC RMAN DataGuard GoldenGate Apps FMW Weblogic OAM OIM ODS ..
    Replies: 0
    Last Post: 07-28-2012, 01:38 AM
  2. Oracle Clusterware manual control command lines
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-24-2012, 04:15 PM
  3. Backup & Restoration of Control Files using RMAN
    By sandeep.negi27 in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 1
    Last Post: 11-03-2011, 01:13 PM
  4. Time taken by each script/pls code in a AD Patch
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 10:53 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics