Using EDI in 11i To Reduce Your Company's Operating Expenses

1
Using EDI in 11i To Reduce Your Company's
Operating Expenses
2
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• The extended decline in general business
  activity has forced corporations and government
  organizations alike to drastically cut expenses.

3
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Presentation Objectives
• Examine an effective and viable alternative for
  cutting operating expenses using the latest
  e-Commerce tools available with the 11i
  e-Business suite of applications.
• Realize quick ROI on systems implementation costs.

4
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Presentation Objectives (cont.)
• Discuss infrastructure and architecture issues,
  as well as the details involving Order
  Management, Receivables and Payables modules.
• Illustrate examples of successful implementations
  involving electronic transmission of data between
  vendors and customers.

5
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracles e-Commerce Gateway (a.k.a. EDI Gateway)
A standards-based integration product for
Oracle Applications, which allows for companies
to integrate Oracle Applications with
applications residing inside or outside of the
enterprise communicating via Intranet, Extranet,
or Internet.
6
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracles e-Commerce Gateway (a.k.a. EDI
Gateway) Oracles e-Commerce Gateway is
independent of all EDI standards and can be
integrated with any upstream or downstream
process via an ASCII file. Thus, any EDI
translator or third party application, that best
suits a companys business requirements, can be
selected. Example SPS Commerce helps large
retailers,small manufacturers and large/small
distributors to electronically trade via EDI
(electronic data interchange).
7
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Oracles e-Commerce Gateway Supports
• Seamless integration
• Streamlined implementation process
• Rule-based transaction processing to automate
  business operations

8
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Impact
• Reduce and/or eliminate overhead expenses
• Paper stock for documents
• Invoices
• Checks (only valid with wire transfers or
  lockbox)
• Purchase Orders (and related documents)

9
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Impact
• Paper stock for documents (continued.)
• Ship Notice Manifests
• Shipment/Billing Notices
• Price/Sales Catalogs
• RFQs
• Planning/Shipping Schedules

10
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Impact (cont.)
• Reduce and/or eliminate operating expenses
• Payroll and related benefits
• Transaction processing volume/costs

11
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features            
I. Definition of Access Responsibilities Work
with System Administrator to assign the
e-Commerce Gateway responsibility to the user
community.        II.  Definition of Data
File Directories 1) Work with DBA to set up file
paths for inbound and outbound E-COMMERCE
testing under the home path defined for
Oracle applications in UNIX.
12
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    II.  Definition of Data File
Directories (cont.) 2) Work with DBA to append
the INIT.ORA file and designate the inbound and
outbound file paths. a) Directories should
have open read/write permissions. b)
Database requires restart in order for
changes to take effect.
13
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    II.  Definition of Data File
Directories (cont.) 3) Set up System Profile
Options under the e-Commerce Gateway
responsibility to indicate where
inbound/outbound data files are to be written
and expected (note the values must match the
actual directories specified under 1 and 2
listed above).
14
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    II.  Definition of Data File
Directories (cont.) 4) Additionally,
Transaction Profile Options can be set, but
only as transactions are implemented.
15
Using EDI in 11i To Reduce Your Company's
Operating Expenses

• Oracles e-Commerce Gateway, requires setup of
  the
• following for Seed Data Reconciliation (SDR)
• Definition of transaction record layouts
• Assignment of code categories to a transaction
  record layout
• Definition of process rules associated with a
  transaction
• Definition of column rules associated with a
  transaction

16
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    III. Definition of Trading Partner
Attributes Entity that the company is doing
business with, as well as the key link between
Oracles e-Commerce Gateway and Oracles suite of
e-Business products or any third party
application.
17
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    III. Definition of Trading Partner
Attributes (cont.) 1)Sample Trading Partners
defined for testing a) WALMART b) TARGER
STORES
18
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    IV.  Preliminary Testing Test validity
of all directory path and trading partner setups
with a generic export/import of test data for
each transaction. a) Trading partner used
JCPENNY b) File name used 810test.dat
19
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    IV.  Preliminary Testing (cont.) c) Sample
transactions tested i) 810 - Outbound
Invoices ii) 850 - Inbound Purchase
Orders iii) 856 - Outbound Ship Notice
20
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    V.   Assign Code Conversion
Categories Conversion categories are assigned to
enable code conversion for the trading partners
defined. a) Header level information (e.g. Pay
and Freight Terms, etc.)
21
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    V.   Assign Code Conversion Categories
(cont.) b) Detail level information (e.g.
Handling Codes/Allowance Charges, Ship
Methods, UOM, etc.) c) Delivery level
information (e.g. Carrier Name, Allowance
Charges, etc.) d) Order level information (e.g.
Handling Codes/Allowance Charges, FOB, etc.)
22
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    V.   Assign Code Conversion Categories
(cont.) e) Item level information (e.g.
Handling Codes/Allowance Charges, etc.)
23
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    VI.   Definition of Code Conversion
Values Define conversion values for the
categories assigned above. Examples
are a) Header level values (e.g. Pay
Terms Net 30) b) Detail level values (e.g.
UOM Each)
24
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    VI.   Definition of Code Conversion
Values (cont.) Define conversion values for the
categories assigned above. Examples
are c) Delivery level values (e.g. Carrier
Name UPS) d) Order level values (e.g. FOB
Destination)
25
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    VI.   Definition of Code Conversion
Values (cont.) Define conversion values for the
categories assigned above. Examples
are e) Item level values (e.g. Allowance
50.00)
26
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
   VII.   Testing of Code Conversion
Values The conversion of values from Oracles
financial applications (e.g. AR/OE ) to values
required by the trading partners should be tested
for validation.
27
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Features               
    VIII.  Transaction Testing w/ Live Data
Files Once preliminary testing has been
validated, transactions with data files
containing actual trading partner data should,
finally, be tested.
28
Using EDI in 11i To Reduce Your Company's
Operating Expenses
Oracle e-Commerce Gateway Transaction Listing
(cont.) Listed below are the seeded critical
business transactions and integration
configuration tools for Oracles e-Commerce
Gateway. These items are designed to streamline
your implementation to easily transform a
business to e-Business.
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)