Oracle A75089-02 User Manual
Oracle e-Commerce Gateway
User’s Guide
Release 11i.2
August, 2000
Part No. A75089-02
Oracle e-Commerce Gateway User’s Guide, Release 11i.2 (as a variable) for Platform (as a variable)
Part No. A75089-02
Copyright © 1996, 1999, Oracle Corporation. All rights reserved.
Primary Author: Bonnie Williams
Contributing Authors: Fred Graham, Janet Lee, Garret Minakawa, Steve Moriarty
Contributors: Debbie, Quezada, Bonnie Shebat Williams, David Wrightson
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent, and other intellectual and industrial property
laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required
to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Oracle8i, Developer/2000, Oracle Application Object Library,
Oracle Alert, and Oracle Workflow are trademarks or registered trademarks of Oracle Corporation. All
other company or product names mentioned are used for identification purposes only and may be
trademarks of their respective owners.
Contents
Send Us Your Comments .................................................................................................................. vii
Preface............................................................................................................................................................ ix
1 Overview.................................................................................................................................1 - 1
Oracle e-Commerce Gateway Overview...................................................................................... 1 - 2
How Oracle e-Commerce Gateway Works................................................................................... 1 - 3
EDI Transaction Support ................................................................................................................ 1 - 5
2 Setting Up ..............................................................................................................................2 - 1
Setting Up Oracle e-Commerce Gateway..................................................................................... 2 - 2
Oracle e-Commerce Gateway Profile Options............................................................................ 2 - 4
Setting Profile Options ................................................................................................................... 2 - 8
3 Trading Partners..................................................................................................................3 - 1
Trading Partners................................................................................................................................ 3 - 2
Defining Trading Partner Data ..................................................................................................... 3 - 4
4 Code Conversion ................................................................................................................4 - 1
Code Conversion............................................................................................................................... 4 - 2
Defining Code Conversion Categories ........................................................................................ 4 - 8
Assigning Categories .................................................................................................................... 4 - 10
Predefined Code Categories ......................................................................................................... 4 - 11
Defining Code Conversion Values ............................................................................................. 4 - 15
5 Interface Data File...............................................................................................................5 - 1
Changing the Interface Data File Record Layout ...................................................................... 5 - 2
Assigning Process Rules ................................................................................................................. 5 - 5
iii
Assigning Column Rules ............................................................................................................... 5 - 7
6 Inbound Exception Processing ..................................................................................... 6 - 1
Inbound Exception Processing....................................................................................................... 6 - 2
Viewing Staged Documents ........................................................................................................... 6 - 3
Viewing Process Violations ........................................................................................................... 6 - 7
Viewing Column Violations .......................................................................................................... 6 - 8
7 Inbound Transactions ...................................................................................................... 7 - 1
Running the Invoice Inbound (INI) Program ............................................................................ 7 - 2
Running the Price / Sales Catalog Inbound (CATI) Program .................................................. 7 - 4
Running the Response to Request for Quote Inbound (RRQI) Program ............................. 7 - 6
Running the Ship Notice / Manifest Inbound (ASNI) Program ............................................. 7 - 9
Running the Shipping and Billing Notice Inbound (SBNI) Program ................................. 7 - 11
8 Outbound Transactions................................................................................................... 8 - 1
Extensible Architecture.................................................................................................................... 8 - 2
Running the Application Advice Outbound (ADVO) Extract Program ............................... 8 - 2
Running the INTRASTAT Movement Statistics (MVSTO) Extract Program ...................... 8 - 4
Running the Invoice Outbound (INO) Extract Program .......................................................... 8 - 7
Running the Credit Memo / Debit Memo (CDMO) Extract Program .................................... 8 - 9
Running the Payment Order / Remittance Advice Outbound (PYO) Extract Program .... 8 - 10
Running the Planning and Shipping Schedule (SSSO and SPSO) Extract Program ....... 8 - 12
Running the Purchase Order Outbound (POO) Extract Program ........................................ 8 - 15
Running the Outbound Purchase Order Change Request (POCO) Extract Program ....... 8 - 17
Attachments ..................................................................................................................................... 8 - 20
9 Oracle e-Commerce Gateway Reports ...................................................................... 9 - 1
Reports ................................................................................................................................................ 9 - 2
Code Conversion Values Report .................................................................................................... 9 - 2
Interface File Data Report ............................................................................................................... 9 - 3
Transaction Layout Definition Report.......................................................................................... 9 - 5
Trading Partner Report .................................................................................................................... 9 - 5
Transactions / Trading Partners Report......................................................................................... 9 - 6
iv Oracle e-Commerce Gateway User’s Guide
Viewing the Status of Concurrent Programs............................................................................... 9 - 7
A Windows and Navigator Paths
Windows and Navigator Paths....................................................................................................... A - 2
B Seed Data Reconciliation
Seed Data Reconciliation ................................................................................................................ B - 2
Performing Seed Data Reconciliation .......................................................................................... B - 4
Index
v
vi Oracle e-Commerce Gateway User’s Guide
Send Us Your Comments
Oracle e-Commerce Gateway User’s Guide, Release 11i
Part No. A75089-01
Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this
publication. Your input is an important part of the information used for revision.
■ Did you find any errors?
■ Is the information clearly presented?
■ Do you need more information? If so, where?
■ Are the examples correct? Do you need more examples?
■ What features did you like most about this manual?
If you find any errors or have any other suggestions for improvement, please indicate the chapter,
section, and page number (if available). You can send comments to us in the following ways:
■ E-mail - apps-docmgrs@us.oracle.com
■ FAX - 650/ 506-7299. Attn: Oracle e-Commerce Gateway
■ Postal service:
Oracle Corporation
Oracle Applications Documentation Manager
500 Oracle Parkway
Redwood Shores, CA 94065
USA
If you would like a reply, please give your name, address, and telephone number below.
If you have problems with the software, please contact your local Oracle Support Services.
vii
Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this
publication. Your input is an important part of the information used for revision.
You can send comments to us in the following ways
■ Postal service
Oracle Corporation
Oracle Applications Documentation Manager
500 Oracle Parkway
City, State 94065
USA
Please provide the following information:
Name:
Tit le:
Company:
Department:
E-Mail Address:
Postal Address:
Phone Number:
Book Title:
Part Number:
If you like, you can use the following questionnaire to give us feedback:
■ Did you find any errors?
■ Is the information clearly presented?
■ Do you need more information? If so, where?
■ Are the examples correct? Do you need more examples?
■ What features did you like most about this manual?
If you find any errors or have any other suggestions for improvement, please indicate the chapter,
section, and page number (if available).
If you have problems with the software, please contact your local Oracle Support Services.
viii
Preface
Welcome to the Oracle® e-Commerce Gateway User’s Guide, Release 11i.
This user’s guide includes the information you need to work with Oracle
e-Commerce Gateway effectively. It contains detailed information about the
following:
■ Oracle e-Commerce Gateway setup.
■ Oracle e-Commerce Gateway windows.
■ Oracle e-Commerce Gateway reports and processes.
This preface explains how this user’s guide is organized and introduces other
sources of information that can help you.
ix
About This User’s Guide
This guide contains overviews as well as task and reference information about
Oracle e-Commerce Gateway.
Note: For Release 11i, we created the Oracle e-Commerce Gateway
Implementation Manual. Most of the information contained in
previous releases of the Oracle EDI Gateway User’s Guide has been
moved to the implementation manual. For detailed information,
see the Oracle e-Commerce Gateway Implementation Manual.
Also note that for Release 11i, the product name changed from
Oracle EDI Gateway to Oracle e-Commerce Gateway.
This guide includes the following chapters:
■ Chapter 1 provides a brief overview of e-Commerce Gateway.
■ Chapter 2 describes basic setup procedures.
■ Chapter 3 describes how to set up trading partners.
■ Chapter 4 provides setup details on how to set up code conversion.
■ Chapter 5 describes how to customize the interface data file.
■ Chapter 6 provides instructions on viewing staged documents, process
violations, and column violations.
■ Chapter 7 provides instructions on how to run inbound transactions.
■ Chapter 8 provides instructions on how to run outbound transactions.
■ Chapter 9 describes how to run reports.
■ Appendix A lists windows and navigator paths.
■ Appendix B describes how to reconcile your seed data during an upgrade.
Audience for This Guide
This guide is intended for Oracle e-Commerce Gateway users. The Oracle
e-Commerce Gateway Implementation Manual is intended for system administrators,
consultants, and any member of your implementation team.
x
Do Not Use Database Tools to Modify Oracle Applications Data
Because Oracle Applications tables are interrelated, any change you make using
Oracle Applications can update many tables at once. But when you modify Oracle
Applications data using anything other than Oracle Applications, you may change a
row in one table without making corresponding changes in related tables. If your
tables get out of synchronization with each other, you risk retrieving erroneous
information and you risk unpredictable results throughout Oracle Applications.
When you use Oracle Applications to modify your data, Oracle Applications
automatically checks that your changes are valid. Oracle Applications also keeps
track of who changes information. If you enter information into database tables
using database tools, you may store invalid information. You also lose the ability to
track who has changed your information because SQL*Plus and other database
tools do not keep a record of changes.
Consequently, we STRONGLY RECOMMEND that you never use SQL*Plus or any
other tool to modify Oracle Applications data unless otherwise instructed.
Other Information Sources
Here are some other ways you can increase your knowledge and understanding of
e-Commerce Gateway.
Online Documentation
All Oracle Applications documentation is available online on CD-ROM, except for
technical reference manuals. There are two online formats, HyperText Markup
Language (HTML) and Adobe Acrobat (PDF).
All user’s guides are available in HTML, PDF, and paper. Technical reference
manuals are available in paper only. Other documentation is available in PDF and
paper.
The content of the documentation does not differ from format to format. There may
be slight differences due to publication standards, but such differences do not affect
content. For example, page numbers and screen shots are not included in HTML.
The HTML documentation is available from all Oracle Applications windows. Each
window is programmed to start your web browser and open a specific,
context-sensitive section. Once any section of the HTML documentation is open,
you can navigate freely throughout all Oracle Applications documentation.
xi
Related User’s Guides
Oracle e-Commerce Gateway shares business and setup information with other
Oracle Applications products. Therefore, you may want to refer to other user’s
guides when you set up and use e-Commerce Gateway.
If you do not have the hardcopy versions of these manuals, you can read them
online using the Applications Library icon or Help menu command.
Country-Specific User’s Guides
These manuals document functionality developed to meet specific legal and
business requirements in more than 25 countries. You should use the appropriate
user’s guide, such as the Oracle Financials for Germany User’s Guide, for more
information about using Oracle Financials in a specific country. Consult your
country-specific user’s guide, Oracle Financials Regional User’s Guide, and your
financial product’s manual to effectively use Oracle Financials in your country.
Global Accounting Engine
Use the Global Accounting Engine to replace the transfer to General Ledger and
create subledger accounting entries that meet additional statutory standards within
some countries. The Accounting Engine provides subledger balances, legal reports,
and bidirectional drilldown from General Ledger to the subledger transaction.
Oracle Applications User’s Guide
This guide explains how to enter data, query, run reports, and navigate using the
graphical user interface (GUI) available with this release of e-Commerce Gateway
(and any other Oracle Applications products). This guide also includes information
on setting user profiles, as well as running and reviewing reports and concurrent
processes.
You can access this user ’s guide online by choosing ”Getting Started with Oracle
Applications” from any Oracle Applications help file.
Oracle Applications Demonstration User’s Guide
This guide documents the functional product flows for Vision Enterprises, a
fictional manufacturer of personal computers products and services. As well as
including product overviews, the book contains detailed discussions and examples
across each of the major product flows. Tables, illustrations, and charts summarize
key flows and data elements.
xii
Oracle Inventory User’s Guide
This guide describes how to define items and item information, perform receiving
and inventory transactions, maintain cost control, plan items, perform cycle
counting and physical inventories, and set up Oracle Inventory.
Oracle Master Scheduling/MRP and Supply Chain Planning User’s Guide
This guide describes how to anticipate and manage both supply and demand for
your items. Using a variety of tools and techniques, you can create forecasts, load
these forecasts into master production schedules, and plan your end-items and their
component requirements. You can also execute the plan, releasing and rescheduling
planning suggestions for discrete jobs and repetitive schedules.
Oracle Manufacturing Scheduling User’s Guide
This guide describes how to use Oracle Manufacturing Scheduling to view and
reschedule single discrete jobs or the entire shop floor. Specifically, this guide details
how to easily use the drag and drop functionality to view and reschedule jobs,
operations, and resources.
Oracle Purchasing User’s Guide
This guide describes how to create and approve purchasing documents, including
requisitions, different types of purchase orders, quotations, RFQs, and receipts.
This guide also describes how to manage your supply base through agreements,
sourcing rules and approved supplier lists. In addition, this guide explains how
you can automatically create purchasing documents based on business rules
through integration with Oracle Workflow technology, which automates many of
the key procurement processes.
Oracle Supplier Scheduling User’s Guide
This guide describes how you can use Oracle Supplier Scheduling to calculate and
maintain planning and shipping schedules and communicate them to your
suppliers.
Oracle Payables User’s Guide
This guide describes how accounts payable transactions are created and entered in
Oracle Payables. This guide also contains detailed setup information for Oracle
Payables.
xiii
Oracle Receivables User’s Guide
Use this manual to learn how to implement flexible address formats for different
countries. You can use flexible address formats in the suppliers, banks, invoices,
and payments windows.
Reference Manuals
Oracle Technical Reference Manuals
Each technical reference manual contains database diagrams and a detailed
description of database tables, forms, reports, and programs for a specific Oracle
Applications product. This information helps you convert data from your existing
applications, integrate Oracle Applications data with non-Oracle applications, and
write custom reports for Oracle Applications products.
You can order a technical reference manual for any Oracle Applications product you
have licensed.
Oracle Manufacturing and Distribution Open Interfaces Manual
This manual contains up-to-date information about integrating with other Oracle
Manufacturing applications and with your other systems. This documentation
includes open interfaces found in Oracle Manufacturing.
Oracle Applications Message Reference Manual
This manual describes all Oracle Applications messages. This manual is available
in HTML format on the documentation CD-ROM for Release 11i.
Installation and System Administration
Oracle Alert User’s Guide
This guide explains how to define periodic and event alerts to monitor the status of
your Oracle Applications data.
Multiple Reporting Currencies in Oracle Applications
If you use the Multiple Reporting Currencies feature to record transactions in more
than one currency, use this manual before implementing e-Commerce Gateway.
This manual details additional steps and setup considerations for implementing
e-Commerce Gateway with this feature.
xiv
Multiple Organizations in Oracle Applications
If you use the Oracle Applications Multiple Organization Support feature to use
multiple sets of books for one e-Commerce Gateway installation, this guide
describes all you need to know about setting up and using e-Commerce Gateway
with this feature.
Oracle Applications Implementation Wizard User’s Guide
If you are implementing more than one Oracle product, you can use the Oracle
Applications Implementation Wizard to coordinate your setup activities. This
guide describes how to use the wizard.
Oracle Applications Developer’s Guide
This guide contains the coding standards followed by the Oracle Applications
development staff. It describes the Oracle Application Object Library constituents
needed to implement the Oracle Applications user interface described in the Oracle
Applications User Interface Standards. It also provides information to help you build
your custom Developer/2000 forms so that they integrate with Oracle Applications.
Oracle Applications Flexfields Guide
This guide provides flexfields planning, setup and reference information for the
e-Commerce Gateway implementation team, as well as for users responsible for the
ongoing maintenance of Oracle Applications product data. This manual also
provides information on creating custom reports on flexfields data.
Oracle Applications Upgrade Preparation Manual
This guide explains how to prepare your Oracle Applications products for an
upgrade. It also contains information on completing the upgrade procedure for
each product. Refer to this manual and the Oracle Applications Installation Manual
when you plan to upgrade your products.
Oracle Applications System Administrator’s Guide
This manual provides planning and reference information for the e-Commerce
Gateway System Administrator.
xv
Other Sources
Training
We offer a complete set of formal training courses to help you and your staff master
e-Commerce Gateway and reach full productivity quickly. We organize these
courses into functional learning paths, so you take only those courses appropriate to
your job or area of responsibility.
You have a choice of educational environments. You can attend courses offered by
Oracle Education Services at any one of our many Education Centers, or you can
arrange for our trainers to teach at your facility. In addition, Oracle training
professionals can tailor standard courses or develop custom courses to meet your
needs. For example, you may want to use your organization structure, terminology,
and data as examples in a customized training session delivered at your own
facility.
Support
From on-site support to central support, our team of experienced professionals
provides the help and information you need to keep e-Commerce Gateway working
for you. This team includes your Technical Representative, Account Manager, and
Oracle’s large staff of consultants and support specialists with expertise in your
business area, managing an Oracle8 server, and your hardware and software
environment.
Oracle Support Services maintains the Metalink web site. Metalink is a valuable
resource that contains supplemental documents, white papers, and product
announcements about Oracle e-Commerce Gateway (and other products). Register
for Metalink 2.0 at the server nearest you:
■ United Kingdom, Belgium, Finland, and The Netherlands should use the UK
server:
http://support.oracle.com.uk/
■ Asia Pacific customers should use the Singapore server:
http://support.oracle.com.sg/
■ United States customers should use the US server:
http://metalink.oracle.com/
Oracle e-Commerce Gateway Email The Oracle e-Commerce Gateway management
team maintains an email address and distribution list to broadcast product
announcements and solicit information about EDI best practices. To add yourself or
xvi
About Oracle
another EDI expert to the email distribution list, send your email address to
edisig@us.oracle.com. Please include the full name and the Oracle customer
number. (This email address is not intended for questions that should be directed to
Oracle Support Services.)
Oracle Corporation develops and markets an integrated line of software products
for database management, applications development, decision support, and office
automation, as well as Oracle Applications, an integrated suite of more than 45
software modules for financial management, supply chain management,
manufacturing, project systems, human resources and sales and service
management.
Oracle products are available for mainframes, minicomputers, personal computers,
network computers and personal digital assistants, allowing organizations to
integrate different computers, different operating systems, different networks, and
even different database management systems, into a single, unified computing and
information resource.
Oracle is the world’s leading supplier of software for information management, and
the world’s second largest software company. Oracle offers its database, tools, and
applications products, along with related consulting, education, and support
services, in over 140 countries around the world.
Thank You
Thank you for using e-Commerce Gateway and this user’s guide.
We value your comments and feedback. At the end of this guide is a Reader’s
Comment Form you can use to explain what you like or dislike about e-Commerce
Gateway or this user’s guide. Mail your comments to the following address or call
us directly at (650) 506-7000.
Oracle Applications Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.
Or, send electronic mail to appsdoc@us.oracle.com.
xvii
xviii
1
Overview
This chapter provides a general overview of Oracle e-Commerce Gateway,
including:
■ Oracle e-Commerce Gateway Overview on page 1-2.
■ How Oracle e-Commerce Gateway Works on page 1-3.
■ EDI Transaction Support on page 1-5.
For a detailed overview, see: Overview, Oracle e-Commerce Gateway Implementation
Manual.
Overview 1-1
Oracle e-Commerce Gateway Overview
Oracle e-Commerce Gateway Overview
Oracle Applications provides users with the ability to conduct business
electronically between trading partners based on Electronic Commerce standards
and methodology. One form of Electronic Commerce is Electronic Data Interchange
(EDI). EDI is an electronic exchange of data between trading partners. Interface data
files are exchanged in a standard format to minimize manual effort, speed data
processing, and ensure accuracy. The Oracle e-Commerce Gateway (formerly
known as Oracle EDI Gateway) performs the following functions:
■ Define trading partner groups and trading partner locations.
■ Enable transactions for trading partners.
■ Provide general code conversion between trading partner codes or standard
codes and the codes defined in Oracle Applications.
■ Define interface data files so that application data can integrate with your
trading partner’s application or an EDI translator.
■ For inbound transactions, import data into application open interface tables so
that application program interfaces (API) can validate and update Oracle
application tables.
■ For outbound transactions, extract, format, and write application data to
interface data files.
Oracle e-Commerce Gateway augments the existing standard paper document
capabilities of Oracle Applications, or adds functionality where no corresponding
paper documents exist.
Oracle e-Commerce Gateway Implementation Manual
The documentation for previous releases of Oracle EDI Gateway (renamed to
Oracle e-Commerce Gateway for Release 11i) consisted only of the User’s Guide.
Please note that we have moved much of the documentation from the User’s Guide
into the new Oracle e-Commerce Gateway Implementation Manual. The Implementation
Manual is written for system administrators, consultants, and any members of your
implementation team. This User’s Guide is written primarily for the end user.
See Also
Oracle e-Commerce Gateway Implementation Manual, Release 11i
1-2 Oracle e-Commerce Gateway User’s Guide
How Oracle e-Commerce Gateway Works
Oracle e-Commerce Gateway is designed with an open and flexible architecture for
easy integration with trading partners and / or EDI translators. The e-Commerce
Gateway provides a seamless application to application integration solution. When
used for EDI (Electronic Data Interchange) solutions, e-Commerce Gateway
integrates with EDI translators to provide specific EDI standard formats and
versions.
Oracle e-Commerce Gateway is a file-based integration layer between Oracle
Applications and any other external application. It uses ASCII (American Standard
Code for Information Interchange) formatted interface data files.
Transaction data originating from an external trading party is formatted and
transmitted to the receiving trading partner. Once received, the data may go
through another formatting process, an EDI translator for example, resulting in an
interface data file based on the standard layout defined in the e-Commerce
Gateway. The e-Commerce Gateway then processes the interface data file and
passes the data to the receiving application for additional business rule validation
and transaction creation.
Transaction data originating from Oracle Applications is processed by the
e-Commerce Gateway and formatted into a standard interface data file. The
e-Commerce Gateway then routes the data to the next step in the process flow. The
process flow may include processing by an EDI translator for EDI-specific
formatting or may involve transmission to the receiving trading partner. Each of
these processing steps are integrated and automated so transaction data can flow
seamlessly in either direction from trading partner to trading partner with little if
any human intervention.
How Oracle e-Commerce Gateway Works
Inbound Transactions
For inbound transactions, the e-Commerce Gateway does the following:
The e-Commerce Gateway receives a file from any source in the standard
transaction interface data file format defined in the e-Commerce Gateway.
The e-Commerce Gateway then processes the data by first validating the trading
partner sending the transaction against trading partners defined in e-Commerce
Gateway. The e-Commerce Gateway then processes any enabled code conversion,
process rules, and column rules.
Transactions that pass process and column rules are mapped and written to
specified Oracle Applications open interface tables for application-specific business
rule validation. Transactions that do not pass these validation / code conversion
Overview 1-3
How Oracle e-Commerce Gateway Works
rules remain in the exception module where users can analyze the exceptions. After
corrective action in other modules or in the e-Commerce Gateway, the transaction
may be resubmitted for re-validation. Alternatively, if your trading partner will
re-send the transaction, you may delete the transaction from the exception module.
The base Oracle application continues validating transactions written to the
application’s open interface tables. All valid transactions are written to the
application tables. Invalid transactions remain in the open interface tables subject to
the application’s standard error handling procedures. All these processes are
automated so that transactions with no errors are posted directly to the base
application tables with no human intervention.
Outbound Transactions
For outbound transactions, the e-Commerce Gateway does the following:
A user-defined or an application event signals the e-Commerce Gateway to begin
the outbound process. User-defined events are set up using Oracle Application’s
Concurrent Manager.
The e-Commerce Gateway extracts data from the application transaction tables and
verifies that the receiving trading partner is authorized to receive the transaction.
Code conversion rules are applied to the data and the data is mapped and written
to the transaction interface data file. The format of this file is based on the standard
file layout define in the e-Commerce Gateway.
1-4 Oracle e-Commerce Gateway User’s Guide
EDI Transaction Support
The following transactions are supported:
Table 1–1 EDI Transaction Support
ASC
X12
Inbound Transactions
810 INVOIC INI Inbound Invoice. This includes support for the following
832 PRICAT CATI Inbound Price / Sales Catalog
843 QUOTES RRQI Inbound Response to Request for Quote
856 DESADV ASNI Inbound Ship Notice / Manifest
857 No
Outbound Transactions
824 APERAK ADVO Outbound Application Advice
810 INVOIC INO Outbound Invoice. This includes support for the following
812 CREADV /
820 PAYO R D /
830 DELFOR SPSO Outbound Planning Schedule
862 DELJIT SSSO Outbound Shipping Schedule
850 ORDERS POO Outbound Purchase Order
860 ORDCHG POCO Outbound Purchase Order Change Request
None CUSDEC MVSTO Outbound Movement Statistics
EDIFACT
equivalent
DEBADV
REMADV
EDI Transaction Support
Transaction
Code
SBNI Inbound Shipping and Billing Notice
CDMO Outbound Credit Memo / Debit Memo
PYO Outbound Payment Order / Remittance Advice
Description
transactions: Air Freight Details and Invoice (110), Motor
Carrier Freight Details and Invoice (210), Rail Carrier
Freight Details and Invoice (410), and Grocery Product
Invoice (880).
transactions: Air Freight Details and Invoice (110), Motor
Carrier Freight Details and Invoice (210), Rail Carrier
Freight Details and Invoice (410), and Grocery Product
Invoice (880).
Overview 1-5
EDI Transaction Support
Other Transactions
The following transactions are available through other products, specifically, Oracle
Process Manufacturing, Oracle Order Management, and Oracle Release
Management.
ASC
X12
Oracle Process Manufacturing Transactions
850 ORDERS GPOI OPM: Inbound Purchase Order
855 ORDRSP GPOAO OPM: Outbound Purchase Order Acknowledgment
856 DESADV GASNO OPM: Outbound Ship Notice / Manifest
EDIFACT
Transaction
Code
Long Name
Note: The following transactions will be supported in a
future release that includes the Oracle Order
Management and Oracle Shipping Execution
products:
ASC
X12
Oracle Order Management and Shipping Execution Transactions
850 ORDERS POI Inbound Purchase Order
855 ORDRSP POAO Outbound Purchase Order Acknowledgment
856 DESADV DSNO Outbound Ship Notice / Manifest
860 ORDCHG POCI Inbound Purchase Order Changes
865 ORDRSP PCAO Outbound Purchase Order Change Acknowledgment
Oracle Release Management Transactions
830 DELFOR SPSI Inbound Planning Schedule
862 DELJIT SSSI Inbound Shipping Schedule
866 No
EDIFACT
equivalent.
Transaction
Code
PSQI Inbound Production Sequence
Long Name
See Also
Oracle e-Commerce Gateway Implementation Manual, Release 11i
1-6 Oracle e-Commerce Gateway User’s Guide
2
Setting Up
This chapter explains the Oracle e-Commerce Gateway profile options and how to
set them up:
■ Setting Up Oracle e-Commerce Gateway on page 2-2.
■ Oracle e-Commerce Gateway Profile Options on page 2-4.
■ Setting Profile Options on page 2-8.
Setting Up 2-1
Setting Up Oracle e-Commerce Gateway
Setting Up Oracle e-Commerce Gateway
This section briefly describes Oracle e-Commerce Gateway setup steps. For the
complete discussion, refer to Setting Up, Oracle e-Commerce Gateway Implementation
Manual.
Note: Oracle e-Commerce Gateway relies on several base Oracle
Applications. Please refer to the setup and open interfaces
documentation for those products, specifically the appropriate
Oracle Applications Implementation Wizard. See: Setting Up,
Oracle e-Commerce Gateway Implementation Manual.
Step 1. Set Profile Options
Profile options must be set up for basic e-Commerce Gateway functions. See: Oracle
e-Commerce Gateway Profile Options on page 2-4.
Step 2. Define Data File Directories
To use e-Commerce Gateway, you must first create directories where data files, for
both inbound and outbound transactions, are stored. You must then specify these in
the INIT.ORA file and in the e-Commerce Gateway profile options. See: Defining
Data File Directories, Oracle e-Commerce Gateway Implementation Manual.
Step 3. Define Trading Partner Data
First, define a trading partner group and associate all trading partner location
(address) entities to this group. Assign the trading partner to an address entity in
Oracle Applications such as a customer, supplier, or bank branch address. The
trading partner assignment and entry of the trading partner detail data establishes
the link between the trading partner as defined in Oracle Applications and its
identification in your trading partner’s application or EDI translator application.
See: Overview of Trading Partners, Oracle e-Commerce Gateway Implementation
Manual, and Defining Trading Partner Data on page 3-4.
Step 4. Define Code Conversions
The Oracle e-Commerce Gateway code conversion function provides a method by
which trading partner and standard codes can be converted to Oracle Application
codes and vice versa. See: Overview of Code Conversion, Oracle e-Commerce
Gateway Implementation Manual.
2-2 Oracle e-Commerce Gateway User’s Guide
Setting Up Oracle e-Commerce Gateway
1.
Define code conversion categories to specify a subset of codes within the code
conversion table. See: Defining Code Conversion Categories on page 4-8.
2. For each data element in a transaction that requires code conversion by
e-Commerce Gateway, assign one code conversion category. See: Assigning
Categories on page 4-10.
3. Enter the actual code conversion values from the internal codes to external
codes into the code conversion table. The internal codes are defined in the
Oracle Applications. The external codes are the associated values required by
the trading partner or chosen EDI standard.
Step 5. Customize Interface Data File Formats
Oracle delivers a standard predefined data file format containing all the data that
may be required to support a particular EDI transaction. You may customize this
data file to meet specific business needs. See: Overview of Data File Structure,
Oracle e-Commerce Gateway Implementation Manual and Changing the Interface Data
File Record Layout on page 5-2.
Step 6. Transactions
Once data file directories, trading partner information, code conversions, and
optional customizations of interface data file formats have been performed, use
Oracle Applications Standard Request Submission to run extract programs for
outbound transactions and import programs for inbound transactions.
See Also
Setting Up, Oracle e-Commerce Gateway Implementation Manual
Profile Options, Oracle e-Commerce Gateway Implementation Manual
Setting Up, Oracle Manufacturing and Distribution Open Interfaces Manual
Oracle Financials Open Interfaces Guide
Setting Up 2-3
Oracle e-Commerce Gateway Profile Options
Oracle e-Commerce Gateway Profile Options
There are three system level profile options you must set. These affect all
e-Commerce Gateway transactions:
■ Outbound directory.
■ Inbound directory.
■ Allow Split Words in Attachment.
There are other transaction level profile options.
■ Enable / disable each transaction.
■ Address derivation precedence.
■ Attachment segment size.
■ Enabling header-level attachments.
■ Enabling line-level attachments.
■ Enabling inventory line attachments.
■ Enabling master item attachments.
Note: There may be more profile options in other Oracle
Applications products that affect e-Commerce Gateway. These
products include: Purchasing, Inventory, Order Entry / Shipping,
Payables, Receivables, Supplier Scheduling, and Planning.
System Level Profile Options
ECE_IN_FILE_PATH (ECE: Inbound File Path)
Indicate the directory where inbound interface data files are expected. This value
must match the actual directory on disk and that designated in the INIT.ORA file.
2-4 Oracle e-Commerce Gateway User’s Guide
Oracle e-Commerce Gateway Profile Options
ECE_OUT_FILE_PATH (ECE: Output File Path)
Indicate the directory where outbound interface data files are written. This value
must match the actual directory on disk and that designated in the INIT.ORA file.
Note: For the e-Commerce Gateway, you must create inbound and
outbound directories on your server, and then specify them in the
INIT.ORA file and in the “ECE: Inbound directory” and “ECE:
Outbound file path” profile options, respectively. See: Defining
Data File Directories, Oracle e-Commerce Gateway Implementation
Manual, Release 11i.
ECE_ATT_SPLIT_WORD_ALLOWED (ECE: Split Word Allowed)
An attachment is usually plain text used as a note.
If you allow words to be split in an attachment, a new line begins within a word. If
you do not allow words to be split, the new line is created after a space or a
punctuation mark, not within a word. Thus, if you do not allow words to be split,
some segment sizes fall below the attachment segment size, and vice versa.
New lines are created once the current line reaches the attachment segment size.
For further information, refer to attachment segment size profile options for
individual transactions.
Transaction Level Profile Options
Each transaction has a common set of profile options. For purposes of brevity, each
type is documented below. For complete documentation, see: Oracle e-Commerce
Gateway Profile Options, Oracle e-Commerce Gateway Implementation Manual, Release
11i.
Each of the profile options below lists the variable <transaction_code>. For a listing
of the transaction codes used below, see: EDI Transaction Support on page 1-5.
ECE_<transaction_code>_ENABLED
Indicates whether the transaction is enabled at the site level. The default is Yes.
ECE_<inbound_transaction_code>_ADDRESS_PRECEDENCE
Applies to inbound transactions only. Determines the precedence by which trading
partner addresses are derived.
Setting Up 2-5
Oracle e-Commerce Gateway Profile Options
When inbound EDI transactions are imported into Oracle Applications, the unique
business site address must be established before the transaction can be processed.
Each trading partner must have a unique address.
A trading partner is a site, such as a plant, a warehouse, a bank branch, or some
other business unit. A trading partner is not necessarily a company; one company
can have several sites.
The correct address can be obtained from one to three sources, each of which has a
precedence code:
Precedence Code Meaning
LON Unique ID number for location name.
LTC Location / translator code combination.
PHA Physical address or site detail.
When you set this profile option using the Transaction Profiles window, you must
select from the following values:
■ LTC, P H A , LON (default).
■ LTC, LO N, PHA.
■ PHA, LTC, LON.
■ PHA, LON, LTC.
■ LON, LTC, PHA.
■ LON, PHA, LTC.
You must set up each inbound transaction to derive the correct address based on the
precedence of the three precedence codes, LON, LTC, and PHA. For example, one
transaction may be set up to derive the address based first on location / translator
code (LTC), then the physical address (PHA), and finally, the location name (LOC).
This means that the first attempt to derive the trading partner uses the combination
of the EDI location code and the translator code. If a unique address ID is not found,
a second attempt uses the physical site address. Finally, if the second attempt fails,
the location name is used.
The following profile options apply only to the Purchase Order Outbound (POO)
and Purchase Order Change Request Outbound (POCO) transactions:
2-6 Oracle e-Commerce Gateway User’s Guide
Loading...