Checking the Type of a Concurrent Program

Check the type of a Concurrent Program before you make decision on which activity to use. For an SRS Concurrent Program, you can use either the Oracle Concurrent Program activity or the Custom Concurrent Program activity. For a non-SRS Concurrent Program, you can only use the Custom Concurrent Program activity.

Procedure

  1. Log on to Oracle SQL*Plus.
    On the command line, enter sqlplus. Enter the Oracle Database system administrator's user name and password.
  2. Run the SQL query for the Concurrent Program of your interest. For example:
    select CONCURRENT_PROGRAM_ID, CONCURRENT_PROGRAM_NAME,
    SRS_FLAG,ENABLED_FLAG,USER_CONCURRENT_PROGRAM_NAME from
    fnd_concurrent_programs_vl where concurrent_program_name='GLBBSU'
    
    Y stands for SRS Concurrent Program, and N stands for non-SRS Concurrent Program.