Oracle e-Commerce Gateway Implementation Manual

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Introduction

Purpose of the Implementation Manual

Documentation

Oracle e-Commerce Gateway Overview

Processing Traditional EDI Transactions

EDI Translators

Implementation Positioning

Implementation Positioning

Other Application Implementations

Determine Communications Methods For The Transactions

Implementation Planning

Oracle e-Commerce Gateway Implementation Checklist

Implementation Steps

Implementation Checklist for Software Upgrade

Implementation Checklist for Fresh Install

Implementation Details

Define Responsibilities

Define UTL_FILE_DIR Parameter in INIT.ORA File

Review Release 12 Upgrade Guideline

Set Up Profiles

System Profile Window

Transaction Profile Window

Transaction Specific Options

Outbound Purchase Order Transaction Profile

Determine Process and Column Rules and Actions

Enable Additional Transaction Data

Modify Transaction Interface File

Synchronize New Transaction Layout Definitions with Translator

Common Transaction Interface File Definition Errors

Set Up Trading Partners

Common Setup Errors

Set Up Code Conversion

Interface with Translators

Communications

Archive/Backup

Transaction Interface File Architecture

File Structure Overview

Interface Data File Structure

Special Records

Optional Outbound Trading Partner Flexfield Records (0020-0070)

Common Record Key (1-100)

Common Records (Based on Record Layout Code)

Code Conversion Internal and External Codes on the File

Application Transaction Detail

Oracle Inventory

      Outbound Movement Statistics (MVSTO/No X12/CUSDEC)

Oracle Order Management

Inbound Purchase Order (POI/850/ORDERS)

Comment Text

      Flags

      Validate Mode Parameter in Concurrent Manager

      Order Import Open Interface Data

      OE_HEADERS_INTERFACE Table

      OE_LINES_INTERFACE Table

      OE_PRICE_ADJS_INTERFACE Table

      OE_RESERVTNS_INTERFACE Table

      OE_ACTIONS_INTERFACE Table

Review Order Management Open Interface Exceptions

Order Import Item Cross-Referencing

Data in the e-Commerce Gateway Transaction

      Table Searches

      Miscellaneous Item Data

      Inbound Purchase Order Change (POCI/860/ORDCHG)

      Outbound Purchase Order Acknowledgment (POAO/855/ORDRSP) (POCAO/865/ORDRSP)

Oracle Payables

      Inbound Invoice (INI/810/INVOIC)

      Inbound Shipment and Billing Notice (SBNI/857/No EDIFACT)

      Outbound Application Advice (ADVO/824/APERAK)

      Outbound Payment Order/Remittance Advice (PYO/820/PAYORD-PAYEXT-REMADV)

Oracle Process Manufacturing

Oracle Purchasing

      Inbound Price/Sales Catalog (CATI/832/PRICAT) Inbound Response to Request for Quotation (RRQI/843/QUOTES)

      Inbound Ship Notice/Manifest (ASNI/856/DESADV) Inbound Shipment and Billing Notice (SBNI/857/No EDIFACT)

      Outbound Application Advice (ADVO/824/APERAK)

      Outbound Purchase Order (POO/850/ORDERS)

      Outbound Purchase Order Change (POCO/860/ORDCHG)

Oracle Receivables

      Outbound Invoice (INO/810/INVOIC)

      Outbound Credit Memo/Debit Memo (CDMO/812/CREADV-DEBADV)

Oracle Release Management

      Planning/Material Release (SPSI/830/DELFOR/DELINS) Shipping Schedule (SSSI/862/DELJIT/DELINS/CALDEL/KANBAN)

      Production Sequence Schedule (PSQI/866/DELJIT/SYNCRO/SYNPAC)

Oracle Shipping Execution

      Outbound Shipment Notice/Manifest (DSNO/856/DESADV)

Oracle Supplier Scheduling

      Outbound Planning Schedule (SPSO/830/DELFOR)

      Outbound Shipping Schedule (SSSO/862/DELJIT)

Test Transactions

Testing Inbound Transactions

Testing Outbound Transactions

Printing and Extract of Documents

Troubleshooting

Troubleshooting

Error Messages

Inbound Transactions

Transaction Exception Summaries

Reports

Trading Partner

Trading Partner

Trading Partner Group

EDI Location Codes

Translator Codes

Translator Code and EDI Location Code Across Applications

Linking Trading Partner Data to the Oracle E-Business Suite Application Source

EDI Location Codes in the Transaction Interface Files

Multiple Organizations

Organizations in Oracle E-Business Suite Application Open Interface Tables

Trading Partner Windows

Code Conversion

Code Conversion

Concatenated Search Key for Inbound Transactions

Concatenated Search Key for Outbound Transactions

Extensible Architecture

Customizing EDI Transactions

Descriptive Flexfields

Steps for Extensible Architecture

Transaction Summary Layouts

Oracle Inventory Transaction Summaries

Oracle Order Management Transaction Summaries

Oracle Payables Transaction Summaries

Oracle Process Manufacturing Transaction Summaries

Oracle Purchasing Transaction Summaries

Oracle Receivables Transaction Summaries

Oracle Release Management Transaction Summaries

Oracle Shipping Execution Transaction Summaries

Oracle Supplier Scheduling Transaction Summaries