Oracle Apps- Unix Commands

Forms
==========
f60gen $XX_TOP/forms/US/XX.fmb apps/$apps_pw module_type=FORM output_file=$XX_TOP/forms/US/XX.fmx

f60gen XX.fmb  apps/oracle123 module_type=FORM

PLL
====
f60gen $CUSTOM_TOP/resource/CUSTOM.pll  username/pass(of oracle) module_type=LIBRARY output_file=$CUSTOM_TOP/CUSTOM.plx

***********
Step1 -> Connect to Unix Box

Step2 -> Set Environment variables
sudo -u xxerp -i
. /xxerp/erpapp/appl/xxerp_xxerp.env
. /xxerp/erpapp/comn/conf/xxerp_xxerpp/8.0.6/xxerp_xxerp.env

Step3 ->
FORMS60_PATH=:FORMS60_PATH:$AU_TOP/resource:$AU_TOP/forms/US;

Step4 ->
export FORMS60_PATH;
cd $XX_TOP/forms/US
f60gen XX.fmb  apps/oracle123

Unix Commands
============
1-Convert PDF/image to ps (Postscript) to send docs to printer

pdftops $PDF_FILE_NAME > $FILE_NAME.ps
imagetops -gray $DEST_PATH$FILE_NAME > $FILE_NAME.ps

2-print command

lp -d $PRINTER_NAME -o media=A4 -o fitplot -o sides=two-sided-short-edge $FILE_NAME

3-find file name to capture in variable or validate in if condition

if [ -e "$(find -name "$FILE_NAME*" -print)" ];
then
FNAME=$(find -name "$FILE_NAME*" -print)

Comments

Popular posts from this blog

PO & Receipt Query

Supplier SQL query

Inventory Item Attributes, Categories, Vendor & Costs