Troubleshooting

 < Day Day Up > 



There are several pieces of information that Oracle Support will request if you have need to open a support request iTAR. This information will also be some of the things that you will start to find yourself doing whenever you start to have a printing related issue before you even consider opening an iTAR.

Concurrent Managers Up

Log into the application using a user ID that has the sysadmin responsibility and check to make sure that the Concurrent Managers are running. Navigate to Concurrent/Manager/Administer and make sure that, at the least, the Internal Concurrent Manager and Standard Manager have numbers under the Actual and Target columns and that these numbers are equal.

Output File Created

Through the requests screen, check to see if the concurrent job in question produced an output file. Do not just stop with checking in the application; also check to make sure that there is an output file in the %PRODUCT_TOP%\out directory. Sometimes there really is one created, but the application seems to forget that it either made one or where it put it. The output file in question will be named with either the username or the request ID of the concurrent request.

Command Line Print

Can you send a print job to the printer from the command line? Attempt to send a file to the printer directly at the OS level or from another application that uses the same printer. If this command no longer works, the problem is not necessarily with the Oracle E-Business Suite, but with something local to the OS itself.

Local to One Report

Try printing another report from within the application. The problem you are experiencing may not be local to the entire application, but may be a specific problem with a single report or a kind of report. Sometimes you will find that PL/SQL reports print successfully, but Oracle Reports-based reports will not, or one product group will have difficulties, but others will not.

Applications Default Printer Defined

Starting in the 11.0 Version of the Oracle E-Business Suite, there has to be a default printer defined for any report, even if you do not want an output file generated or the job in question does not produce an output file by default (like gathering statistics). Add a printer name to the Profile Option printer at the site level. Call it by a real name or call it "Fred," it does not have to be a printer that exists anywhere on the planet, there just has to be a value assigned to that Profile Option. Specifically assigning a printer to a report or to the User's Profile Option will override the pretend default.

Printer Driver Setup

While Oracle ships preseeded printer drivers with the basic installation, the printer driver information may not be entirely correct and is intended to be a template only. You may need to play around with the escape sequences to get it to work successfully with a particular brand or a particular physical printer.

Patches

Have you applied any patches to any part of the application lately? There may not be patches released to directly impact printers or printing, but that does not mean that applying a patch will not break something that was working before.

Copies

Will the same report that is not running, run successfully if you make sure that you set copies = 0 deliberately? If it will not, it is not likely directly a printer issue, but more likely a report issue or an issue with another part of the application.

FND_PRINTER_DRIVERS

If you want to load the FND_PRINTER_DRIVERS table with printer drivers other than those that are defaulted with the application and with drivers that have proven to be trustworthy (by veteran Apps DBA, James Morrow of Plano, Texas), you can run the following script saved as fpd2_unix.ctl from a SQL prompt and easily load the table with valid printer drivers that you can test out on your own system. Table 7.5 is the log file produced from running it on a brand new system. Table 7.6 provides the output log for the control file's SQL*Loader run.

Table 7.5: fpd2_unix.ctl

 load data infile * append into table FND_PRINTER_DRIVERS fields terminated by "|" optionally enclosed by '`' (printer_driver_name, user_printer_driver_name, description, srw_driver, printer_driver_method_code, spool_flag, stdin_flag, arguments, initialization, reset, attribute1, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) BEGINDATA `PORTJJMHP4` | `PORTJJMHP4` | `PORTJJMHP4 - Port, 80x65, 7.3vmi, 12cpi, Letter Gothic` | `HPP` | `C` | `N` | `Y` | 'lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l0O/e&l2A/e&l7.3C/e(s0p12h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `LANDJJMHP4` | `LANDJJMHP4` | `LANDJJMHP4 - Landscape, 132x65, 5.4vmi, 14cpi, courier` | `HPL` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l2A/e&l5.4C/e(s0p14h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `LANDWIDEJJMHP4` | `LANDWIDEJJMHP4` | `LANDWIDEJJMHP4 - Landscape, 180x65, 5.4vmi, 18cpi, Letter Gothic` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l2A/e&l5.4C/e(s0p18h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `LANDLEGALJJMHP4` | `LANDLEGALJJMHP4` | `LANDLEGALJJMHP4 (132x60), 6 vmi, 10cpi, courier (8.5"x14")` | `HPL` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l3A/e&l6C/e(s0p10h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` `LANDWIDELEGALJJMHP4` | `LANDWIDELEGALJJMHP4` | 

 `LANDWIDELEGALJJMHP4 (180x66), 5.4 vmi, 14cpi, courier (8.5"x14")` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES  -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l3A/e&l5.4C/e(s0p14h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `LANDWIDELEDGERJJMHP4` | `LANDWIDELEDGERJJMHP4` | `LANDWIDELEDGERJJMHP4 (180 x 79) 6vmi, 12cpi, courier (11"x17") ` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES  -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l6A/e&l6C/e(s0p12h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` `PORT132JJMHP4` | `PORT132JJMHP4` | `PORT132JJMHP4 - Portrait, 132x65, 5.4vmi, 17cpi, letter gothic` | `HPP` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l0O/e&l2A/e&l5.4C/e(s0p17h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `PORTDXJJMHP4` | `PORTDXJJMHP4` | `PORTDXJJMHP4 - Port, Duplex, 80x65, 7.3vmi, 12cpi, Letter Gothic` | `HPP` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l0O/e&l2A/e&l1s/e&l7.3C/e(s0p12h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` `LANDDXJJMHP4` | `LANDDXJJMHP4` | `LANDDXJJMHP4 - Landscape, Duplex, 132x65, 5.4vmi, 14cpi,4courier` | `HP ` | `C` | `N | `Y` | `lp -d $PRdFILEI$.PRINTER -n $PROFILES$.CONCCCOPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l2A/e&l1s/e&l5.4C/e(s0p14h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` 5.4vmi, 18cpi, Letter Gothic` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | 

 `/eE/e&l1O/e&l2A/e&l1s/e&l5.4C/e(s0p18h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` `LANDLEGALDXJJMHP4` | `LANDLEGALDXJJMHP4` | `LANDLEGALDXJJMHP4 (132x60), Duplex, 6 vmi, 10cpi, courier (8.5"x14")` | `HPL` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l3A/e&l1s/e&l6C/e(s0p10h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0` `LANDWIDELEGALDXJJMHP4` | `LANDWIDELEGALDXJJMHP4` | `LANDWIDELEGALDXJJMHP4 (180x66), Duplex, 5.4 vmi, 14cpi, courier (8.5"x14")` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l3A/e&l1s/e&l5.4C/e(s0p14h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` `LANDWIDELEDGERDXJJMHP4` | `LANDWIDELEDGERDXJJMHP4` | `LANDWIDELEDGERDXJJMHP4 (180 x 79), Duplex, 6vmi, 12cpi, courier (11"x17") ` | `HPW` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES -t "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l1O/e&l6A/e&l1s/e&l6C/e(s0p12h0s0b4099T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11- JUN-97`| `0`| `0``PORT132DXJJMHP4` | `PORT132DXJJMHP4` | `PORT132DXJJMHP4 - Portrait, Duplex, 132x65, `PORT132DXJJMHP4` | `PORT132DXJJMHP4` | `PORT132DXJJMHP4 - Portrait, Duplex, 132x65, 5.4vmi, 17cpi, letter gothic` | `HPP` | `C` | `N` | `Y` | `lp -d $PROFILES$.PRINTER - n $PROFILES$.CONC_COPCES Ct "$PROFILES$.FILENAME" $PROFILES$.FILENAME` | `/eE/e&l0O/e&l2A/e&l1s/e&l5.4C/e(s0p17h0s0b4102T ` | `/eE` | `(C) 1997 — James J. Morrow `| `11-JUN-97`| `0`| `11-JUN-97`| `0`| `0` 

Table 7.6: SQL*Loader Output File

     printer.log SQL*Loader: Release 8.1.7.3.0 - Production on Mon Apr 8 05:37:35 2002 (c) Copyright 2000 Oracle Corporation.   All rights reserved. Control File:   fpd2_unix.ctl Data File:      fpd2_unix.ctl   Bad File:     fpd2_unix.bad   Discard File:  none specified   (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array:     64 rows, maximum of 65536 bytes Continuation:    none specified Path used:       Conventional Table "APPLSYS.""FND_PRINTER_DRIVERS," loaded from every logical record. Insert option in effect for this table: APPEND     Column Name            Position   Len   Term Encl Datatype - — — — — — — — — — — — — — — — — — — — — — - — — — — — — — — — — PRINTER_DRIVER_NAME          FIRST      *    |  O(`)  CHARACTER USER_PRINTER_DRIVER_NAME      NEXT      *    |  O(`)  CHARACTER DESCRIPTION                   NEXT      *    |  O(`)  CHARACTER SRW_DRIVER                    NEXT      *    |  O(`)  CHARACTER PRINTER_DRIVER_METHOD_CODE    NEXT      *    |  O(`)  CHARACTER SPOOL_FLAG                    NEXT      *    |  O(`)  CHARACTER STDIN_FLAG                    NEXT      *    |  O(`)  CHARACTER ARGUMENTS                     NEXT      *    |  O(`)  CHARACTER INITIALIZATION                NEXT      *    |  O(`)  CHARACTER RESET                         NEXT      *    |  O(`)  CHARACTER ATTRIBUTE1                    NEXT      *    |  O(`)  CHARACTER LAST_UPDATE_DATE              NEXT      *    |  O(`)  CHARACTER LAST_UPDATED_BY               NEXT      *    |  O(`)  CHARACTER CREATION_DATE                 NEXT      *    |  O(`)  CHARACTER CREATED_BY                    NEXT      *    |  O(`)  CHARACTER LAST_UPDATE_LOGIN             NEXT      *    |  O(`)  CHARACTER 

 Record 9: Rejected - Error on table "APPLSYS"."FND_PRINTER_DRIVERS", column SPOOL_FLAG. no terminator found after TERMINATED and ENCLOSED field Record 15: Rejected - Error on table "APPLSYS". "FND_PRINTER_DRIVERS", column PRINTER_DRIVER_NAME. Column not found before end of logical record (use TRAILING NULLCOLS) Table "APPLSYS"."FND_PRINTER_DRIVERS":   13 Rows successfully loaded.   2 Rows not loaded due to data errors.   0 Rows not loaded because all WHEN clauses were failed.   0 Rows not loaded because all fields were null. Space allocated for bind array:       61920 bytes(15 rows) Space allocated for memory besides bind array:     0 bytes Total logical records skipped:               0 Total logical records read:                 15 Total logical records rejected:              2 Total logical records discarded:             0 Run began on Mon Apr 08 05:37:35 2002 Run ended on Mon Apr 08 05:37:37 2002 Elapsed time was:     00:00:01.73 CPU time was:          00:00:00.04 



 < Day Day Up > 



Oracle 11i E-Business Suite from the front lines
Oracle 11i E-Business Suite from the Front Lines
ISBN: 0849318610
EAN: 2147483647
Year: 2004
Pages: 122

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net