Shell Script to Generate LDT Files

To Create Soft Link  Use the below Command

ln -s $FND_TOP/bin/fndcpesr XXMP_SQL_LOADER

Shell Script to Generate LDT File

#!/bin/ksh

#------------------------------------------------------------------------------

#   Filename    :    XXR2RITI611B.prog

#   Description :    This shell script process Credit Card Transaction Files

#   Copyright   :    Oracle Corporation 2015

#----+------------+---------+--------------------+-----------------------------

#--  |Date        |Version  |Author Name         |Description

#----+------------+---------+--------------------+-----------------------------

#--  |18-May-2015 | 1.0     |Prasad Bheemavarapu |Initial creation

#----+------------+---------+--------------------+-----------------------------

CPSN=$5  #Concurrent Program Short Name

email=$6 #Email to send the Ldt file

#Printing the Parameters

echo "Concurren Program Short Name "$CPSN

echo "Email to send the Ldt file "$email

#Setting LDT File Creation Path

LDTFILE=$XXAMW_TOP/bin/$CPSN.ldt

echo "LDT File "$LDTFILE

#touch will create a file

touch sub.txt

#LDT Command to Generate LDT File

FNDLOAD $1 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $LDTFILE PROGRAM CONCURRENT_PROGRAM_NAME=$CPSN

#mutt Command is used to send E-mail

mutt -s "Concurrent Program" -a  $LDTFILE -c prasad.bheemavarapu@oracle.com -- $email < sub.txt

#Cat is used for printing log file

cat $LDTFILE

Shell File to Generate LDT File

Shell File    LDT File

Shell Script to Merge the PDF Files

Pdf Merge Shell

Shell Script for SQL * Loader

SQL Loader