When you submit the Supplier Mailing Labels report, you choose an output style parameter of either Formatted or Unformatted. If you choose Formatted, Payables prints the supplier label information on Avery brand laser labels. If you choose Unformatted, Payables creates a flat file with the supplier label information. You can then use a custom program to format the flat file and print your custom labels. For more information, see: Supplier Mailing Labels Report.
Before you can run the Supplier Mailing Label report, you must set up a print style and printer driver and assign them to the report. You set up the print style based on whether you want to run the report in the Formatted or Unformatted output style, and if you use a printer in PostScript mode or not.
If you want to use the Formatted output style, and you use a printer in non-PostScript mode, and an SRW driver is not defined for this printer, you must first define a new Portrait type (66 height x 80 width) SRW driver for your printer and it must be in your $FND_TOP/$APPLREP directory. See: Creating Custom SRW Drivers.
Suggestion: If you want to be able to choose both Formatted and Unformatted output styles when you submit the report, assign in the Print Style window an SRW driver that can print in the Unformatted output style, and assign in the Printer Drivers window an SRW driver that can print in the Formatted output style. The system uses the SRW driver in the Print Styles window when, in the Submit Request window, you enter zero in the Copies field. The system uses the SRW driver in the Printer Drivers window if, in the Submit Request window, you enter a value greater than zero in the Copies field, and you enter a printer value in the Printers field. If the Print Style SRW driver is different from the Print Drivers SRW driver, each time you submit the Supplier Mailing Labels program, you must remember to properly set the Copies and Printer fields in the Submit Request window.
Log in to Oracle Applications and choose the System Administrator responsibility.
Navigate to the Print Styles window.
Define the Portrait - Mailing Labels print style by entering and saving the following values and options. For detailed information on the window, see: Print Styles Window.
| Field | Value or Option |
|---|---|
| Style Name | PORTRAITMAILLABELS |
| Sequence | Unique number that specifies order in which the printer name appears on your printer list of values. See: Print Styles Window documentation for more details. |
| User Style | Portrait - Mailing Labels |
| SRW Driver | Select a driver depending on whether an SRW driver for your printer is predefined in Oracle Applications, whether you use your printer in PostScript mode, and whether you use the Formatted (Avery labels) or Unformatted (custom labels) Output Style parameter for the Supplier Mailing Labels Report: - APFMLB (predefined PostScript SRW driver, Formatted output style, with page breaks) - APUMLB (predefined non-PostScript SRW driver, Unformatted output style, without page breaks) - existing Portrait type (66 height x 80 width) SRW driver, e.g. P (predefined non-PostScript SRW driver for Formatted/Unformatted output styles with page breaks) - user-defined |
| Description | Style for Supplier Mailing Labels |
| Columns | 80 |
| Rows | 66 |
| Suppress Header | Disabled |
| Orientation | Portrait |
Save your work
Log in to Oracle Applications and choose the System Administrator responsibility.
Navigate to the Printer Drivers window.
Define a printer driver by entering the following values. For more information, see: Printer Drivers Window .
If you are using a printer in non-PostScript mode, you may want to remove the PostScript references in the values you enter for the Driver Name, User Driver, and Description.
| Field | Value |
|---|---|
| Driver Name | PORTRAITPSMAILLABELS |
| User Driver | PostScript Portrait for Mailing Labels |
| Description | PostScript Portrait 80x66 (8.5"x11"), 0 margins |
| SRW Driver | Select a driver depending on whether an SRW driver for your printer is predefined in Oracle Applications, whether you use your printer in PostScript mode, and whether you use the Formatted (Avery labels) or Unformatted (custom labels) Output Style parameter for the Supplier Mailing Labels Report: - APFMLB (predefined PostScript SRW driver, Formatted output style, with page breaks) - APUMLB (predefined non-PostScript SRW driver, Unformatted output style, without page breaks) - existing Portrait type (66 height x 80 width) SRW driver, e.g. P (predefined non-PostScript SRW Driver for Formatted or Unformatted output styles with page breaks) - user-defined |
| Platform | (blank) |
| Driver Method | Command You can use other Driver Methods. Using an alternate Driver Method may require you to change the values for Spool File, Standard Input, Program Name, and Arguments. |
| Spool File | Enabled |
| Standard Input | Disabled |
| Program Name | (blank) |
| Arguments | lp -c -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES $PROFILES$.FILENAME Note that for some operating systems you will need to alter the Arguments. Using alternate Arguments may require you to change the values for Spool File and Standard Input. |
| Initialization | If you use a printer in PostScript mode, leave the Initialization field blank. If you use a printer in non-postscript mode and want to use the Formatted output style, enter a string with the following escape sequences: - printer coordinate origin in top left corner of physical page - all page margins (top, bottom, left, right) are 0 - page dimensions are 80 characters wide and 66 characters high |
| Reset | If you entered an Initialization string, enter a string that will reset the printer's instructions for the next print job. |
Save your work.
Log in to Oracle Applications and choose the System Administrator responsibility.
Navigate to the Printer Types window. For more information, see: Printer Types Window.
Query the printer you want to use to print the mailing labels.
Select PORTRAITMAILLABELS as the printer style and select the printer driver name you defined, e.g. PORTRAITPSMAILLABELS.
Save your work.
Log in to Oracle Applications and choose the System Administrator responsibility.
Navigate to the Concurrent Programs window. For more information, see: Concurrent Programs Window.
Query the Supplier Mailing Labels Program (short name APXVDLBL).
In the Output region, overwrite the Style default value of 'Portrait' with 'Portrait - Mailing Labels'.
If you do not want to allow users to select other print styles when they submit the report, check the Style Required check box.
Save your work.