How to integrate the Barcode Label Printing into your Oracle Application

1
How to integrate the Barcode Label Printing into
your Oracle Application?

• Anunaya Shrivastava
• March 8,
  2004

HCL Technologies (IL)
2
Agenda

• Background of the bar-coding issue
• Barcode Process Overview
• Oracle Application landscape
• Technical Architecture
• Key Accomplishments

HCL Technologies (IL)
3
Background

• Third Party Application
• Ease of Use
• Cost Benefit of the new approach
• Maintenance and Support Considerations

HCL Technologies (IL)
4
Background (contd)

• Telnet based software
• Required data-entry
• No facility to do a print preview of the label
• Costs
• Difficult maintenance and server installs

HCL Technologies (IL)
5
Solution Considerations

• Reduce Costs
• Integration with Oracle Applications
• Reduce redundant data-entry
• Provide WSYWYG capabilities
• Provide direct printing from Oracle Applications

HCL Technologies (IL)
6
Current Process Analysis

• User needs to log on to a non-windows based
  application using telnet.
• User needs to note down the data input in some
  format (writing down on a paper, sticking the
  information in a notepad file)
• User needs to input this information (6-7 data
  input items)
• Issue a print

HCL Technologies (IL)
7
Design Considerations

• Remove dual data input
• Aim for Validated input
• Give the user a vignette about whats printing
• Provide ability to print from the Oracle
  Applications

HCL Technologies (IL)
8
Technical Architecture of the Solution

• Application Form
• Custom.pll
• Print Preview capability
• Concurrent Program
• Printer Setup
• Receipt notification for the printed label

HCL Technologies (IL)
9
PROCESS OVERVIEW
HCL Technologies (IL)
10
Oracle Applications considerations

• Application Form
• Custom.pll
• Print Preview capability
• Concurrent Program
• Printer Setup
• Receipt notification for the printed label

HCL Technologies (IL)
11
Label Printer

• Intermec Printer
• Printer instructions
• Registering the printer in Oracle Applications
• Printer Driver and Style in Oracle Applications

HCL Technologies (IL)
12
Label Design in Oracle Forms
HCL Technologies (IL)
13
Key Accomplishments

• User requirements met
• No extra software
• Supported Customization
• WYSWYG capabilities
• Low maintenance requirements

HCL Technologies (IL)
14
Q A

HCL Technologies (IL)
15

• THANK - YOU

HCL Technologies (IL)