Logo Background

Oracle Concurrent Request Process Code

  • By on January 3, 2009 | No Comments

    Applications maintains this type of information in FND_LOOKUPS view.

    The following query would provide you the information regarding the status_code and its meaning for fnd_concurrent_processes.

    SQL> select lookup_code, meaning from fnd_lookups where lookup_type=’CP_PROCESS_STATUS_CODE’

    LOOKUP_CODE
    ————
    A -> Active
    C -> Connecting
    D -> Deactiviating
    G -> Awaiting Discovery
    K -> Terminated
    M -> Migrating
    P -> Suspended
    R -> Running
    S -> Deactivated
    T -> Terminating
    Z -> Initializing

    Here are the status_codes for fnd_concurrent_requests and their meanings :-

    PROCESS_STATUS_CODE
    ——————–
    A -> Waiting
    B -> Resuming
    C -> Normal
    D -> Cancelled
    E -> Error
    F -> Scheduled
    G -> Warning
    H -> On Hold
    I -> Normal
    M -> No Manager
    Q -> Standby
    R -> Normal
    S -> Suspended
    T -> Terminating
    U -> Disabled
    W -> Paused
    X -> Terminated
    Z -> Waiting

    PHASE_CODE
    ———–
    C -> Completed
    I -> Inactive
    P -> Pending
    R -> Running

    Previous
    Next
    » Apply 11i Patch When adpatch Is Running
Leave a Comment