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

Thread: Concsub to Submit Concurrent Requests

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

    Lightbulb Concsub to Submit Concurrent Requests

    The concurrent request can also be submitted from the command lind syntax using the Concurrent Submission utility CONCUSUB. It allows the users to submit the concurrent request at the OS level without login to the forms. This utility submits a concurrent request from the command line and returns to the command line once the request is completed.

    The syntax for CONCSUB is given below:

    CONCSUB <APPS username>/<APPS password> \
    <responsibility application short name> \
    <responsibility name> \
    <username> \
    [WAIT=N|Y|<n seconds>] \
    CONCURRENT \
    <program application short name> \
    <program name> \
    [PROGRAM_NAME=”<description>”] \
    [REPEAT_TIME=<resubmission time>] \
    [REPEAT_INTERVAL= <number>] \
    [REPEAT_INTERVAL_UNIT=< resubmission unit>] \
    [REPEAT_INTERVAL_TYPE=< resubmission type>] \
    [REPEAT_END=<resubmission end date and time>] \
    [START=<date>] \
    [IMPLICIT=< type of concurrent request> \
    [<parameter 1> ... <parameter n>]


    These are the compulsary Parameters :

    • ORACLE ID: Username and Password of the ORACLE ID for Applications, separated by a slash (“/”). This would be apps/appspass

    • Responsibility Application Short Name: Enter the short name of the application for your responsibility. This name, along with your responsibility name, will be used to select a responsibility for your request to run in. eg : SYSADMIN

    • Responsibility Name: This name, along with your responsibility application short name, will be used to select a responsibility for your concurrent request to run in.
    eg : ”System Administrator”

    • User name: Enter the name of your Application Object Library user. This name will be used to update the Who information for any data your concurrent manager changes.
    eg : SYSADMIN

    • CONCURRENT : A flag that separates the program–specific parameters from the operating system parameters.

    • Program application short name: The application short name of your concurrent program.
    eg : FND

    • Program name : The uppercase name of your program. It must be the short name that you enter in the Concurrent Programs window when defining a concurrent program.



    REGARDS
    ANKIT
    Last edited by Hemant; 12-04-2011 at 11:57 AM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Example:
    ==========
    In order to submit a Concurrent request to gather statistics directly from the OS prompt ,

    CONCSUB apps/<apps_password> SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND FNDGSCST \
    START="14-OCT-11\ 01:00:00" REPEAT_DAYS=7 REPEAT_INTERVAL_TYPE="START" "ALL" "25" "3" "NOBACKUP" "" "LASTRUN" "GATHER" "" "Y"

+ Reply to Thread

Similar Threads

  1. Managing alert for concurrent requests
    By dbaANKIT in forum Concurrent Processing Server / Workflow
    Replies: 3
    Last Post: 08-19-2012, 06:57 PM
  2. Script to get all Concurrent Requests pending with CRM
    By Amit in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 11-01-2011, 09:47 AM
  3. Currently Running Concurrent Requests
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:25 PM
  4. List Scheduled Concurrent Requests
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:12 PM
  5. concurrent requests that ran for over X minutes
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:11 PM

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