Docstoc

Evergreen

Document Sample
Evergreen Powered By Docstoc
					                       Electronic
                        Creation
                          and
                      Distribution
                     of Oracle Data
Robert J. Kragen
Evergreen Data Systems, Inc.
NW OUG July 23, 2001
        Introduction
   Evergreen Data Systems
Oracle Partner for 7 years.
In business for more than 20 years
Provide output solutions to over 3,000 Oracle
 Applications clients
Providing electronic output solutions, world
 wide
       Why implement a
    document management
          solution?
Process efficiency improvements
   Operations  (printing, mailing)
   Real time distribution

Direct costs
   Eliminate   preprinted forms
   Postage
   Resource shift from developer to super
   user or analysts
        Why an Output
       Management Plan
Decisions and strategies for the output
 and distribution of Oracle data.
Identify output data
Define audience
   Customers
   Employees
   Suppliers
     Why Use “Snap-On”
      Output Software
No invasion of Oracle database
Archive feature
Less stress on Oracle Application
Reprint capability
Ease of use
Rapid implementation
         Business Decisions
Standard or customized data stream?
   Additional  data added?
   Include email address, fax number or
    decision flags.

Where will additional data be placed?
   In Oracle Applications data stream
   In an outside database
         Test Environment

Stabilize data streams
   Before form project is created, contents of
    data stream should be established

Create test file for each document
   Submitrequests for average size of batch
   Use maximum filed lengths
   How do most solutions
   Integrate with Oracle?
Components
       Developer, creates projects
       Server, houses projects.
       Projects reside as “printer” on the server.

Oracle set up
       Register printer
       Assign static IP address
       Set up printer type
         Design Elements
Name project
   Follow   good naming conventions

Layout form graphics
   Fonts,lines, boxes, shading
   Bar codes, signatures
   Logos
        Fixed or dynamic
         Design Elements
Data mapping
Suppress data
Dynamic content
Add data from outside source
Ease of change
Add logic
         Data Mapping Without any
        Changes to Host Application
Despatch Note - Delivery Note Number:458976
Delivery Address: 11 Boulton Road, Southsea Portsmouth PO5 1NS
Account Customer - Invoice Number:1456984
Invoice Date:15.07.98
Despatch Advice Number:1254954
Corporate Account:1237
Branch Account:533
Customer Order No:23416537
Originated by:David Smith
Acknowledgement Number:785487
Delivery Note Number:4579254
Packages:3
Quantity Code Description List Price Discount Value
1000 101-345 Capacitors 100pf 34.00 2 33.32
1000 101-346 Capacitors 220pf 34.00 2 33.32
3000 102-143 Resistors 1K0 30.00 5 28.50
2000 102-151 Resistors 10K0 20.00 2 19.60
500 111-982 74LS01 43.00 2 42.66
500 111-549 74LS06 43.00 2 42.66
1 171-145 Screwdriver 4" 4.99 4.99
1 171-316 Pliers 3" 4.99 4.99
3 102-113 Tinned Copper Wire 12swg 21.90 21.90
2 204-111 Tinned Copper Wire 14swg 14.60 14.60
5 214-182 7/.01 Insulated Red 43.00 43.00
5 112-541 7/.01 Insulated Black 43.00 43.00
10 601-315 Connectors 25 way male 34.00 2 33.32
100 601-146 Connectors 25 way female 340.00 5 323.00
30 602-113 DPDT Toggle switch 35.00 35.00
20 602-151 SPST Sub Min Toggle Switch 23.00 23.00
5 607-912 0.1" 3"x4" Veroboard 23.00 23.00
5 607-149 0.1" 4"x6" Veroboard 27.00 27.00
Net 796.86 Carriage 22.00 VAT 122.82 Total 941.68 Number of Parcels:3
           Process Data Flow From
                Oracle to LFE

 ORACLE                                NT             WORK
                      UNIX
  DATA                               SERVER          STATION
Submit request      UNIX_FSGINV01   UNIX_FSGINV01   View
1 copy              Request ID      Print Queue     Reprint
FSGINV01                                            Email
Portrait 15 style                    Mapping        Fax
Create request ID                    Graphic
                                     Logo
                                     Decisions
                                     Distribution
                 Distribution
Print
   Single   or multiple printers

Email
   Summarized   data in body of email with
    PDF attachments
   Error trapping, failed email transmission
   Print-stream security

Fax
   Fax   server required
             Distribution

Store in directory
   Store  document in accessible directory
   File format considerations (PDF, TXT, XML)
   How and who will retrieve

Web page, save to HTTP server
       format considerations (PDF, TXT, XML)
   File
   How and who will retrieve
   Security considerations
              Distribution
Compound distribution
   Output single document to more than one
   destination
        Example: email customer, fax rep limited view
        Example: pick list, packing slip - price
         information suppressed on packing slip
                   Archive
Eliminate paper files
Intelligent compression
   Saves resources (static data) once.
   Saves variable data

Archiving configuration decisions
   How long
   Security
               Retrieve
Create customized indexes
   Search and query functionality
   Search by any indexed data field

Reprint, relieves stress on Oracle
 system.
Electronically distribute
Browser or Network retrieval
      Other Functionality
Create reports from same data stream
   Control   pages can be added to concurrent
    batch
   Detail reports
   Cover pages can be added

Targeted messages.
             notices
   Collection
   Promotional messages
      Other Functionality
Data can be made available in different
 views
   Fulldetail to customer, summary detail to
    sales representative.

Annotations
   Sticky   notes can be added to documents
        Benefit Summary
Efficiency               Cost savings
   Real time delivery.      Preprinted forms.
   Management               Staff reduction
   Quality                  Development
   Oracle resources          salary
   Productivity
                                  Analyst vs.
                                   developer
                             Postage
                             Post   processing
For more information

Please contact:

     Robert J. Kragen
     Evergreen Data Systems, Inc.
     (800) 248-2898
     rkragen@evergrn.com

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:15
posted:8/16/2012
language:English
pages:22