Oracle Apps- Unix Commands

By -
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

Post a Comment

Popular posts from this blog

PO & Receipt Query

By -
Query to get PO & Receipt Data: select aps.segment1  "Supplier Number", poh.segment1  "Purchase Order Number", poh.AUTHORIZATION_STATUS  "Purchase Order Status", Null  "Purchase Order Release Number", poh.START_DATE  "Purchase Order Date", papf.full_name  "Buyer", msi.segment1   "Purchase Order Item Number", pll.closed_code  "Purchase Order Item Status", pol.PURCHASE_BASIS  "Purchase Order Item Type", msi.segment1  "Location Part Number", msi.description  "Location Part Description", pol.VENDOR_PRODUCT_NUM  "Supplier Part Number", POL.QUANTITY  "Item Order Quantity", pol.unit_price  "Location Item Price", poh.CURRENCY_CODE  "Location Currency Code", pol.unit_price  "Supplier Item Price", aps.PAYMENT_CURRENCY_CODE  "Supplier Currency Code", msi.PRIMARY_UNIT_OF_MEASURE  "Inventory Unit of Me...
Read more

Supplier SQL query

By -
Query to get Supplier data from Oracle R12 SELECT   aps.segment1 "SupplierNum",          assa.vendor_site_code "Address Book Identifier ",          aps.vendor_name "Supplier Company Name ",          --Hou.name "Operating Unit Name",          Assa.address_line1 "Supplier Address Line1",          Assa.address_line2 "Supplier Address Line2",          assa.address_line3 "Supplier Address Line3",          assa.address_line4 "Supplier Address Line4",          assa.city "Supplier city",          assa.state || assa.PROVINCE "Supplier State/Province",          assa.country "Supp_country_Code",          assa.zip "Supp_postal_Code",          apsite_rmt.ADDRESS_LINE1 "Supp_Remit_...
Read more

Sales Order SQL

By -
Query to get Sales Order data ======================== select distinct ooh.CREATION_DATE , Ooh.Order_number  "Sales Order Number", VERSION_NUMBER  "Sales Order Revision Number  ", to_char(ORDERED_DATE,'DD-MM-RRRR')  "Entered Date", (select ORDER_CATEGORY_CODE from apps.oe_transaction_types_all where transaction_type_id = ooh.ORDER_TYPE_ID )  "Order Type",ooh.ORDER_TYPE_ID, Ooh.Quote_number  "Quote Number", ooh.TAX_EXEMPT_FLAG  "Order Taxable  ", (select name from apps.ra_terms where Term_id = ooh.PAYMENT_TERM_ID)  "Payment Terms", ooh.TAX_EXEMPT_NUMBER  "Tax Exempt Id Number", (select p.FIRST_NAME  from apps.fnd_user f,       apps.Per_all_people_f p where f.EMPLOYEE_ID = p.PERSON_ID   and f.user_id = ooh.LAST_UPDATED_BY )  "Last Maintenance - First Name", (select p.LAST_NAME  from apps.fnd_user f,       apps.Per_all_people_f p where f.EMPLOYEE_ID = p.PERSON_ID...
Read more