INTRODUCTION:
To run a UNIX shell script as a concurrent program, we need to register the shell script as a Host Concurrent Program. Also we need to ensure that there is execute permission for executable.
High Level Stepts:
Step to regist shell script as a host program or concurrent program in Oracle Applications.
1. Create a shell script ( say xyz) and move it to the appropriate BIN directory in Oracle Application.
2. The parameters in the shell scripts should start with $5 , $6 Onwards.
3. Rename the shell script to *.prog ( xyz.prog).
4. Change Permissions to 755 for the *.prog file.
5. Create Link to the shell Script ( ln -s $FND_TOP/bin/fndcpesr/xyz.prog) to create xyz file.
6. Now Register this executable in the application as a host executable (Using System Administrator Responsibility).
While registering the shell script as a concurrent program make sure that the first parameter in the concurrent program is passed as the Fifth parameter in the shell scripts because the first four parameters are allocated to userid,request_id,resp_id,resp_appl_id.
Step 1: mailx syntax
mailx [-s subject] [-a attachment ] [-c cc-addr] [-b bcc-addr] [-r from-addr] [-h hops] [-A account] [-S variable[=value]] to-addr
Options:
-s – subject of an email. Mention it in double-quotes if it contains space
-a – attach the given filename to message
-b – send blind carbon copies to list of users
-c – send carbon copies to list of users
-r – set the from address.
-v – Verbose mode. This displays details of delivery on the user’s terminal
Note:- All parameters to this command are optional.
Shell Script: MAIL_SCRIPT.sh#!/bin/bash
# |Description : Check mail Sending throgh CP |
# |Change Record: |
# |=============== |
# |Version Date Author Remarks |
# |======= ========== ============= =========== |
# |Draft 23-06-2023 XXXXXXXXXX Initial Version |
# +=============================================+
#Parameters from 1 to 4 i.e $1 $2 $3 $4 are standard parameters
# $1 : username/password of the database
# $2 : userid
# $3 : USERNAME
# $4 : Concurrent Request ID
ToAddress=$5
CcAddress=$6
BccAddress=$7
Subject=$8
echo ------------------
echo -Parameters received from concurrent program ..-
echo - Time : -`date`
echo ------------------
echo - Arguments : -
echo - Apps : -$1
echo - ToAddress : -${ToAddress}
echo - CcAddress : -${CcAddress}
echo - BccAddress : -${BccAddress}
echo - Subject : -${Subject}
echo -------------------
echo - PPDDEBUGNEXTCODE 10
IP=XX.XX.XXX.41
MAIL_SUB="Invalid Object alert @ $ORACLE_SID Production Application server($IP)"
MAILING_LIST_S=erpteam@xxx.in
#mailx syntax
#echo -e "MSG Body" | mailx [-s subject] [-a attachment ] [-c cc-addr] [-b bcc-addr] [-r from-addr] [-h hops] [-A account] [-S variable[=value]] to-addr
echo -e " Dear Team,\n\nWe have found some Invalid Object in Production, please check.\n\nThanks & Regard\nERPTEAM" | mailx -s "$MAIL_SUB" -a $attachment -c cc-addr -b bcc-addr -r from-addr $MAILING_LIST_S
if [ $? -ne 0 ]
then
echo -Entered Exception at mail sending, contact Administrator-
else
echo -Email utility completed successfully-
fi
echo -****************************************************************
Step 2: Rename the shell script to *.prog
Save the shell script to $CUSTOM_TOP/bin as MAIL_SCRIPT.prog
Change Permissions to 755 for the *.prog file.
Step 3: Create Softlink as follows
cd /$CUSTOM_TOP/bin
ln -s $FND_TOP/bin/fndcpesr MAIL_SCRIPT
Step 4: Create Executable
Step 5: Register as Concurrent Program (Using System Administrator Responsibility)
Step 6: Define User Parameters
