Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: July 2009

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • How to Setup Pasta for Epson Esc/P Printers !!!!!
    Thursday, July 23, 2009
    1. On server where the concurrent manager resides, setup the printer at the OS level. As the applmgr, verify that the OS print queue is working by submitting a print job, from the OS command line to the target printer, with a simple ASCII text file. Check the OS vendor manual for the command and syntax required or printing from a command line.
    i.e lpstat -p

    2. If Pasta is not already at the latest version of 3.0.4, install the latest released Pasta patch (3325651). Use the following command to determine the current version of Pasta: FNDPSTAX -v

    3. Copy the default Pasta configuration file in order to create a configuration files that support non-Postscript printers (any name can be used *.cfg):

    a) cp $FND_TOP/resource/pasta.cfg $FND_TOP/resource/pasta_epson.cfg

    b) Take a backup of the pasta_epson.cfg file under $FND_TOP/resource and Edit the pasta_epson.cfg file and change the 'outputFormat' parameter to text and/or a character set that the printer supports, as follows:

    i.e. outputFormat=text.WE8ISO8859P1 or outputFormat=text

    4. Logon as sysadmin

    Responsibility = System Administrator
    Navigate --> Install: Printer: Driver

    Copy the three main Pasta drivers as following:

    ==> Copy PASTA_LANDWIDE the PASTA_EPSON_LANDSCAPE
    User Driver - Pasta Epson driver for Landscape
    Description - Pasta universal driver for Epson Landscape style
    SRW Driver - PSTLL
    Driver Method - Program
    Driver Method Parameters - Check "Spool File" Option
    Program Name - FNDPSTAX
    Argument - -pn$PROFILES$.PRINTER -f$PROFILES$.FILENAME -c$PROFILES$.CONC_COPIES -l -Fpasta_epson.cfg
    Initialization to /eC66/eP/017

    ==> Copy PASTA_LANDWIDE to PASTA_EPSON_LANDWIDE

    User Driver - Pasta Epson driver for Landwide
    Description - Pasta universal driver for Epson Landwide style
    SRW Driver - PSTWL
    Driver Method - Program
    Driver Method Parameters - Check "Spool File" Option
    Program Name - FNDPSTAX
    Argument - -pn$PROFILES$.PRINTER -f$PROFILES$.FILENAME -c$PROFILES$.CONC_COPIES -l -s7 -Fpasta_epson.cfg
    Initialization - /eC66/eP/017

    ==> Copy PASTA_PORTRAIT to PASTA_EPSON__PORTRAIT

    User Driver - Pasta Epson driver for Landwide
    Description - Pasta universal driver for Epson Portrait style
    SRW Driver - PSTWL
    Driver Method - Program
    Driver Method Parameters - Check "Spool File" Option
    Program Name - FNDPSTAX
    Argument - -pn$PROFILES$.PRINTER -f$PROFILES$.FILENAME -c$PROFILES$.CONC_COPIES -Fpasta_epson.cfg
    Initialization - /eC66/eP

    5. Create a new printer type that reuses the existing Pasta print styles. Link the styles to the new Pasta printer drivers for Epson Esc/P (non-Postscript) printers.

    a) Responsibility = System Administrator
    b) Navigate --> Install: Printer: Types

    c) Create a new printer type such as

    Type: Pasta Epson Printer Type
    Description : Pasta Epson Printer Type

    Style Driver
    Landscape PASTA_EPSON_LANDSCAPE
    Landwide PASTA_EPSON_LANDWIDE
    Portrait PASTA_EPSON__PORTRAIT

    6. On the Apps register printer form, associate the "Pasta Epson Printer Type" with the target printer(s).

    a) Responsibility = System Administrator
    b) Navigate --> Install: Register
    c) Query the traget printer's name
    d) Update the printer "Type" field with the "Pasta Epson Printer Type"

    7. Bounce the concurrent manager.


    Reference:
    Note 739186.1
    posted by Jaswinder Singh @ 5:48 PM   1 comments
    Pasta Configuration to setup the printer in Oracle Applications !!!!!
    Thursday, July 2, 2009
    -> Printer should be setup at the operating system level .Use lpstat –a command
    and check if the printer is configured as OS level.

    To check if printer is printing at OS level use the following command:

    Lp -d

    -> File name can be any text file (ex any .req file $APPLCSF/$APPLLOG directory)

    -> Network team and firewall team may need to be involved if the printer is not accessible from OS level.Only after printer is accessible from OS level we can configure Pasta to use the printer.

    Configuration:

    -> The version of pasta can be checked from $FND_TOP/bin

    FNDPSTAX is the executable program for pasta.

    FNDPSTAX -v
    Pasta version 3.0.4.0 - unicode/bidi printing utility.
    Copyright (c) Oracle Corporation 1999-2003.

    -> Pasta patch is provided as standard AD patch of Oracle Applications and it needs to be applied on the concurrent processing node.

    -> Patch 3325651 provides the above pasta release.

    -> Setting up your system to use Pasta is much simpler than the standard Oracle Applications printer setup procedure. The Printer Type, Printer Driver, and SRW driver files are provided. The only setup required to begin printing is the registration of the printer with Oracle E–Business Suite.

    -> Pasta comes with default Printer type:

    Responsibility: System Administrator Menu Path: Install->Printer->Type

    --PASTA Universal Printer Type. We can use the same printer type or configure a new printer type.

    -> Associate the printer type with different printers as required.

    Responsibility: System Administrator Menu Path: Install->Printer->Register

    Example :

    * Login in As sysadmin
    * Navigate => System Administrator => Install : Printer => Register

    Printer :
    Type : --PASTA Universal Printer Type
    Description :

    -> Pasta configuration files are located in $FND_TOP/resource directory.
    Pasta looks for files pasta_.cfg file in the above directory.
    If the file is not present it will look for the file pasta.cfg

    -> You can change the file that is defined as the default configuration file for Pasta by using the –F command line parameter.

    For example, suppose you create a PCL print–specific configuration file
    named pcl.cfg. Set the FNDPSTAX command line option as follows: –Fpcl.cfg
    Pasta will look for pcl_.cfg first, and if it is not found,
    Pasta will use pcl.cfg as the default.

    These files must be placed under the $FND_TOP/resource directory.
    The –F command line parameter can be set in the Arguments field of
    the Printer Drivers window.

    Pasta_pdf.cfg is the file used by pasta to print pdf converted to postscript
    By 3rd party utility.The driver name is PASTA_PDF.

    Ex:
    In pasta_pd.cfg : preprocess=pdf2ps {infile} {outfile}.

    -> The configuration file Pasta.cfg file governs many printing options.The file is a simple ASCII text file.

    Some important options :

    1. OutputFormat = ps/text ( ps stands for printers which support postscript format and text stands for printers which doesnt support post script Format)
    2. Preprocess = ( Ex: pdf2ps utility To convert pdf to postscript )
    3. Printcommand = lp (Print command for unix platform)
    4. Pagewidth
    5. pageheight .

    There are lot of other options which can be configured like fontname, font size.

    Note :

    * During first time setup of pasta make sure all the information regarding the Printer is available and OS level pringting is working (Using lp command) before configuring pasta.

    * For most of the changes made to configuration files it is necessary to bounce concurrent manager for changes to take effect.
    posted by Jaswinder Singh @ 10:37 AM   2 comments
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .