4 Steps for Host based concurrent program

hi,

what if i require to run the shell scripti from another responsibility other than sys admin

Ranjith

I am calling pl/sql procedure,from my shell method concurrent prog.
can i use fnd_file.put_line to log message ?

I use a shell script without extension and I have two custom parameters defined in the concurrent manager. I’m able to get the values through my shell script, by reading the whole parameter list and parsing it. However, the parameters are encolosed with double quotes which is causing issues. How do I get rid of the double quotes surrounding my parameters?

Help is greatly appreciated.

there should be no problem ….as far as you attached with fndcpesr by mean of soft line…
additionally you can pass as many parameter as you can….the more over you need to check the corresponding mapping..
I will check my script, will send you offline

How to get program status or “WARNING” in host method concurrent program?

I have similar problem as Amresh.

Can some one shed some light on
how to get program status or “WARNING” in host method concurrent program?

Regards,
Raj.

Dear Sanjit,

As per your saying, i added to my test_data_host_prog.prog file four compulsory parameters ,but during registration in sysadmin -> concurrent-> program -> define
,in parameters window i had left all blank.
During running of the concurrent program it is giving error: The executable file /dev02/CPS/apps/apps_st/appl/ja/12.0.0/bin/test_data_host_prog for this concurrent program can not be executed.

my script file is as follows:

# Parameters passed into program

ORA_USER_PASS=$1
USERID=$2
USERNAME=$3
REQUESTID=$4

#LOGON_STRING=’apps/appscps@cps’
#FILENAME=$5

sqlload userid=apps/appscps@cps control=/usr/tmp/test_data_host.ctl data=/usr/tmp/test_data_host.txt log=/usr/tmp/test_data_host_log.log bad=/usr/tmp/test_data_host_bad.bad ERRORS=100000 silent=FEEDBACK <<!
!

RC=$?
echo “The sql loader exit code for loading Header table is :”$RC

if [ $RC -eq 0 -o $RC -eq 2 ]
then
echo ‘Loading of file table successful.’
else
echo ‘Error: Loading of file table has errors. Sqlload return code is ‘$RC
exit 1
fi

case “$RC” in
0) echo “SQL*Loader execution successful” ;;
1) echo “SQL*Loader execution exited with failure, see logfile” ;;
2) echo “SQL*Loader execution exited with warning, see logfile” ;;
3) echo “SQL*Loader execution encountered a fatal error” ;;
*) echo “unknown return code $RC” ;;
esac

kindly help me with the same.

Thanks & Regards

Vishnu Pratap Patel

echo should work.what is version of your oracle u are using.

Command like
echo “Line 1.”
echo “line 2.”

suppose to print
Line 1.
Line 2.
in log file.

are u sure prog completed successfully. some time access previlege also causing , as there is no debug options unless developer is realize that something pre-requssite is not performed yet.

this is simple host based concuuurent prog used to Moves files from one directory to another

Three input parameter is there.

once you put the script in to Unix box, donot forgot to run this command
ln -s -f $FND_TOP/bin/fndcpesr XXTEST

–here is code

# Initialise environment variables
echo " Initialise location specific environment variables" 
ORA_USER_PASS=$1
USERID=$2
USERNAME=$3
REQUESTID=$4
P_SOURCE_DIR=`eval echo $5`
P_TARGET_DIR=`eval echo $6`
P_FILENAME=$7

DIR=`eval echo $1`

# Initialise common environment variables
echo " Initialise common environment variables" 
SCRIPT=XXTEST.prog

# Variables for Load filenames
echo " " 
echo "Input Directory = " $P_SOURCE_DIR

# Setting the Directory Names
CTLDIR=$XXPH_TOP/bin
LOGDIR=$XXPH_TOP/log
BADDIR=$XXPH_TOP/log


# Setting the Log file for the .prog file
REPFILE=$APPLCSF/$APPLLOG/l$REQUESTID.req
PROBLEMS=0
# ----------------------------------------------------------
echo "\n Start" $SCRIPT
echo " ************************************"
# ------------------------------------------------------------------

# Display all parameters entered
  echo " For Supplier data conversion -- Parameters entered:-" >> $REPFILE
  echo " SQL*Plus userid   = " $USERID >> $REPFILE
  	  
# Display Other parameters :-

  echo "Other Parameters :-" >> $REPFILE
  echo "--------------------" >> $REPFILE
  echo "Source directory = " $P_SOURCE_DIR >> $REPFILE
  echo "Target directory = " $P_TARGET_DIR >> $REPFILE
  echo "Filename         = " $P_FILENAME >> $REPFILE
  
echo "At the end of Parameter Listing " >>  $REPFILE 

#
# Check if the Data Files Exist 
echo "At the start of Data Files Check " >>  $REPFILE
#
if [ ! -f $P_SOURCE_DIR/$P_FILENAME ]
then
    echo  $P_SOURCE_DIR/$P_FILENAME " does not exist"
    echo "**************************************************" >> $REPFILE
    echo "*$P_SOURCE_DIR/$P_FILENAME " does not exist"           *" >> $REPFILE
    echo "**************************************************" >> $REPFILE
    PROBLEMS=1
    exit 1
fi
#
echo "At the end of Data File Check " >>  $REPFILE   
#
#   Move the file to the target directory
# ------------------------------------------------------------------
mv $P_SOURCE_DIR/$P_FILENAME $P_TARGET_DIR
if [ $? != 0 ]
then
    echo "**************************************************" >> $REPFILE
    echo "*$P_SOURCE_DIR/$P_FILENAME " failed to move "          *" >> $REPFILE
    echo "**************************************************" >> $REPFILE
    PROBLEMS=1
fi
mv $P_SOURCE_DIR/$P_FILENAME'.o' $P_TARGET_DIR
if [ $? != 0 ]
then
    echo "**************************************************" >> $REPFILE
    echo "*$P_SOURCE_DIR/$P_FILENAME'.o " failed to move "    *" >> $REPFILE
    echo "**************************************************" >> $REPFILE
    PROBLEMS=1
fi
# ------------------------------------------------------------------
#
if test $PROBLEMS = 1
then
    echo "\nUnsuccessful termination of" $SCRIPT >> $REPFILE
    echo "\n------------------------------------" >> $REPFILE
    exit 1
else
    echo "\n----------------------------------" >> $REPFILE
    echo "Successful termination of" $SCRIPT >> $REPFILE
    echo "----------------------------------" >> $REPFILE
fi
exit 0

Hi,

this tutorial is perfect, thank you for your information.

Do you have an example of a host program which would ftp a file from the apps server to a remote ftp server?

I need the same for r12…. It seems that something was changed…

Best Regards,
Marcelo

Marcelo ,Mervin

There is no such difference in R12 and R11i of the host program based concurrent program.

I am suspecting either your softlink is not created or loader file path is not correct.

Are u getting some message or your program is ending with red color error.

Could you share your log file offline at sanjitanand@yahoo.com, and if posssible share the screen snapshots of
1. Concurrent registration of prog
2.screen snap shots of $FOLDER/bin
i want to make sure privileges
3.log file of the concurrennt program

Got it resolved.There was something wrong with the fndcpesr file itself in r12.
Took the fndcpesr file from an r11 instance and copied it into r12 $FND_TOP/bin/ and renamed it to fndcpesr1.
Then created the link to this file.
It works!!!

To write to output, find the name of the output file by querying FND_CONCURRENT_REQUESTS in the shell script. Then redirect your output and append it to the output file.

How to send the status as WARNING for a HOST concurrent program.

Thx a lot :)

[…] 7. Go to system admin,complete the steps as mention in this post. […]

hi Snajit,

I have a req- like I have a SQL query which returns like – 700 records – now – this SQL script need to be scheduled – to run everymonth 15th.

Req: When we run this SQL through Concurent request – the out of this SQL script sud be placed in one of the FTP server location in XLS format

Qsn: – how do I start for this req – like after I read ur tthread I learned – that I have to register as a Host program – but how abt that SQL whcich returns – values ??

plz shed some light on this to start..
my email – rameshkumar.pujari@gmail.com

thax in adv