1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to register into the oracle application

Discussion in 'General' started by Myvizhi Selvi, Aug 18, 2011.

  1. Myvizhi Selvi

    Myvizhi Selvi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    After converting the staging file into database table, how to register it into the oracle application using concurrent program from the unix shell environment..
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Sorry your post makes is totally unclear. You need to explain clearly what you are doing.
     
  3. Myvizhi Selvi

    Myvizhi Selvi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    How to register the unix shell scripting as a concurrent program.. This is my exact question..
     
  4. Myvizhi Selvi

    Myvizhi Selvi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    How to register the unix shell scripting as a concurrent program.. This is my exact q

    How to register the unix shell scripting as a concurrent program..
     
  5. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: How to register the unix shell scripting as a concurrent program.. This is my exa

    Are you talking about Oracle EBS or oracle database in general?
     
  6. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Steps To Register Unix Shell Script As A Concurrent Program through Oracle EBS:

    We can register an Unix shell script in our oracle application through a concurrent program. Here are the steps.

    Step 1:

    Copy the .prog script in ASCII mode to the bin directory of your application top directory. For example, call the script XXSHELL.prog and place it under $XXCUST_TOP/bin

    step 2:

    Check the file permissions. Sometimes it is required to give full permission to the script.

    step 3:

    Make a symbolic link from your script to $FND_TOP/bin/fndcpesr For example, if the script is called XXSHELL.prog , then use this:

    cd $XXCUST_TOP/bin

    ln -s $FND_TOP/bin/fndcpesr XXSHELL

    This link should be named the same as your script without the .prog extension. Put the link for your script in the same directory where the script is located.

    step 4:

    Register the concurrent program, using an execution method of ‘Host’. Use the name of your script without the .prog extension as the name of the executable.

    For the example above: Use XXSHELL as executable name.

    Note:

    Your script will be passed at least 4 parameters, from $1 to $4.

    $1 = orauser/pwd
    $2 = userid(apps)
    $3 = username,
    $4 = request_id

    Any other parameters you define will be passed in as $5 and higher. Make sure your script returns an exit status also.

    fndcpesr is a standard utility available in $FND_TOP directory. It is mainly used by the application to parse the above four arguments to the shell scripts.
     
    Myvizhi Selvi and Sadik like this.
  7. Myvizhi Selvi

    Myvizhi Selvi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Re: How to register the unix shell scripting as a concurrent program.. This is my exa

    Oracle EBS