Oracle A75089-02 Manual de usuario

Oracle e-Commerce GatewayUser’s GuideRelease 11i.2August, 2000Part No. A75089-02

x About This User’s GuideThis guide contains overviews as well

Running the Shipping Schedule Inbound (SSSI) Program7-22 Oracle e-Commerce Gateway User’s GuideAutomating the Shipping Schedule Inbound ProgramThe ste

Outbound Transactions 8-18Outbound TransactionsThis chapter describes how to run the Oracle e-Commerce Gateway outbound transactions: Extensible Arc

Extensible Architecture8-2 Oracle e-Commerce Gateway User’s Guide Extensible ArchitectureThe Oracle e-Commerce Gateway provides two methods to add add

Running the Application Advice Outbound (ADVO) Extract Program Outbound Transactions 8-3Prerequisites❏ Create the outbound directory and update the IN

Running the INTRASTAT Movement Statistics (MVSTO) Extract Program8-4 Oracle e-Commerce Gateway User’s Guide Set the debug mode to report on debug in

Running the INTRASTAT Movement Statistics (MVSTO) Extract Program Outbound Transactions 8-5As data is extracted from e-Commerce Gateway, only movement

Running the INTRASTAT Movement Statistics (MVSTO) Extract Program8-6 Oracle e-Commerce Gateway User’s Guide Enter the legal entity. This must match

Running the Invoice Outbound (INO) Extract Program Outbound Transactions 8-7Running the Invoice Outbound (INO) Extract Program Use this transaction to

Running the Invoice Outbound (INO) Extract Program8-8 Oracle e-Commerce Gateway User’s Guide 3.Select the Invoice Outbound transaction.4. In the Param

Running the Credit Memo / Debit Memo (CDMO) Extract Program Outbound Transactions 8-9Running the Credit Memo / Debit Memo (CDMO) Extract Program Use t

xiDo Not Use Database Tools to Modify Oracle Applications DataB

Running the Payment Order / Remittance Advice Outbound (PYO) Extract Program8-10 Oracle e-Commerce Gateway User’s Guide Enter a document type and a

Running the Payment Order / Remittance Advice Outbound (PYO) Extract Program Outbound Transactions 8-11Payments made using electronic funds transfer (

Running the Planning and Shipping Schedule (SSSO and SPSO) Extract Program8-12 Oracle e-Commerce Gateway User’s Guide See AlsoOutbound Payment Order /

Running the Planning and Shipping Schedule (SSSO and SPSO) Extract Program Outbound Transactions 8-13Use Scheduler Workbench or enable AutoConfirm opt

Running the Planning and Shipping Schedule (SSSO and SPSO) Extract Program8-14 Oracle e-Commerce Gateway User’s Guide 3.Select the Planning or Shippin

Running the Purchase Order Outbound (POO) Extract Program Outbound Transactions 8-15Running the Purchase Order Outbound (POO) Extract Program Use this

Running the Purchase Order Outbound (POO) Extract Program8-16 Oracle e-Commerce Gateway User’s Guide ❏ Define code conversions. See: Defining Code Co

Running the Outbound Purchase Order Change Request (POCO) Extract Program Outbound Transactions 8-177.Enter completion options.8. Choose Submit and ma

Running the Outbound Purchase Order Change Request (POCO) Extract Program8-18 Oracle e-Commerce Gateway User’s Guide Procurement Card InformationThe O

Running the Outbound Purchase Order Change Request (POCO) Extract Program Outbound Transactions 8-19◗◗ To run the Purchase Order Change extract progra

xii Related User’s GuidesOracle e-Commerce Gateway shares busi

Attachments8-20 Oracle e-Commerce Gateway User’s Guide AttachmentsYou can attach text to the outbound Purchase Order and the Purchase Order Change Req

Oracle e-Commerce Gateway Reports 9-19Oracle e-Commerce Gateway ReportsThis chapter discusses Oracle e-Commerce Gateway reports: Reports on page 9-2

Reports9-2 Oracle e-Commerce Gateway User’s Guide ReportsReports are submitted using the Standard Request Submission window.In the Submit Requests win

Interface File Data Report Oracle e-Commerce Gateway Reports 9-3External ValueEnter an external (transaction interface data file) value or leave blank

Interface File Data Report9-4 Oracle e-Commerce Gateway User’s Guide ParametersYou must enter the following parameters:Transaction CodeEnter the e-Com

Trading Partner Report Oracle e-Commerce Gateway Reports 9-5Transaction Layout Definition ReportReports exact layout of a specified transaction interf

Transactions / Trading Partners Report9-6 Oracle e-Commerce Gateway User’s Guide Trading PartnerEnter a specific trading partner or leave blank to rep

Viewing the Status of Concurrent Programs Oracle e-Commerce Gateway Reports 9-7Test FlagSelect T (Test), P (Production), or leave blank to report on b

Viewing the Status of Concurrent Programs9-8 Oracle e-Commerce Gateway User’s Guide

Windows and Navigator Paths A-1AWindows and Navigator PathsThis appendix shows you the default Navigator path for each e-Commerce Gateway window. Re

xiiiOracle Inventory User’s GuideThis guide describes how to de

Windows and Navigator PathsA-2 Oracle e-Commerce Gateway User’s Guide Windows and Navigator PathsFor windows described in other manuals:Text in bracke

Seed Data Reconciliation B-1BSeed Data ReconciliationThis appendix describes what seed data is in Oracle e-Commerce Gateway and explains how to reconc

Seed Data ReconciliationB-2 Oracle e-Commerce Gateway User’s Guide Seed Data ReconciliationSeed data is generally defined as any data delivered with a

Seed Data Reconciliation Seed Data Reconciliation B-3 Identify new columns. Reapplies your customized preexisting record layout modifications (optio

Performing Seed Data ReconciliationB-4 Oracle e-Commerce Gateway User’s Guide See AlsoPerforming Seed Data Reconciliation: page 4Performing Seed Data

Performing Seed Data Reconciliation Seed Data Reconciliation B-5◗◗ To execute the Seed Data Reconciliation Request:1. Enter the Transaction Type from

Performing Seed Data ReconciliationB-6 Oracle e-Commerce Gateway User’s Guide 6.When finished, choose OK in the parameter window.7. Enter schedule opt

Performing Seed Data Reconciliation Seed Data Reconciliation B-7record layout and the record layout in the patch reference the same record/position nu

Performing Seed Data ReconciliationB-8 Oracle e-Commerce Gateway User’s Guide column rules. Use the Interface File Definition form to reapply these a

Glossary-1GlossaryAANSI American National Standards Institute which establishes national stan

xiv Oracle Receivables User’s GuideUse this manual to learn ho

Glossary-2 business application Software that performs a particular business

Glossary-3in the form of credit and debit transfers, related bank balance, banking transac

Glossary-4 transaction set line item area The line item area encompasses the

Index-1IndexAApplication Advice outboundextracting, 8 - 2ASC X12810, 7 - 2, 8 - 782

Index-2 OOverview, 1 - 2PPayment Order / Remittance Advice outboundextracting, 8 -

xvMultiple Organizations in Oracle ApplicationsIf you use the O

xvi Other SourcesTrainingWe offer a complete set of formal tra

xviianother EDI expert to the email distribution list, send you

xviii

Overview 1-11OverviewThis chapter provides a general overview of Oracle e-Commerce Gateway, including: Oracle e-Commerce Gateway Overview on page 1-

Oracle e-Commerce Gateway User’s Guide, Release 11i.2 (as a variable) for Platform (as a variable)Part No. A75089-02Copyright © 1996, 1999, Oracle Co

Oracle e-Commerce Gateway Overview1-2 Oracle e-Commerce Gateway User’s GuideOracle e-Commerce Gateway OverviewOracle Applications provides users with

How Oracle e-Commerce Gateway Works Overview 1-3How Oracle e-Commerce Gateway WorksOracle e-Commerce Gateway is designed with an open and flexible arc

How Oracle e-Commerce Gateway Works1-4 Oracle e-Commerce Gateway User’s Guiderules remain in the exception module where users can analyze the exceptio

EDI Transaction Support Overview 1-5EDI Transaction Support The following transactions are supported:Table 1–1 EDI Transaction SupportASC X12EDIFACTTr

EDI Transaction Support1-6 Oracle e-Commerce Gateway User’s GuideOther Transactions The following transactions are available through other products, s

Setting Up 2-12Setting UpThis chapter explains the Oracle e-Commerce Gateway profile options and how to set them up: Setting Up Oracle e-Commerce Gat

Setting Up Oracle e-Commerce Gateway2-2 Oracle e-Commerce Gateway User’s GuideSetting Up Oracle e-Commerce GatewayThis section briefly describes Oracl

Setting Up Oracle e-Commerce Gateway Setting Up 2-31.Define code conversion categories to specify a subset of codes within the code conversion table.

Oracle e-Commerce Gateway Profile Options2-4 Oracle e-Commerce Gateway User’s GuideOracle e-Commerce Gateway Profile OptionsThere are three system lev

Oracle e-Commerce Gateway Profile Options Setting Up 2-5ECE_OUT_FILE_PATH (ECE: Output File Path)Indicate the directory where outbound interface data

iiiContentsSend Us Your Comments ...

Oracle e-Commerce Gateway Profile Options2-6 Oracle e-Commerce Gateway User’s GuideWhen inbound EDI transactions are imported into Oracle Applications

Oracle e-Commerce Gateway Profile Options Setting Up 2-7ECE_<transaction_code>_HEAD_ATTEnables the header attachment for the transaction. The de

Setting Profile Options2-8 Oracle e-Commerce Gateway User’s GuideSetting Profile Options ◗◗ To set system-level profile options:1. Navigate to the Tra

Setting Profile Options Setting Up 2-9◗◗ To set profile options by transaction:1. Navigate to the Transaction Profiles window.2. Select the transactio

Setting Profile Options2-10 Oracle e-Commerce Gateway User’s Guide Enable or disable the header attachment. Enable or disable the line attachment.

Trading Partners 3-13Trading PartnersThis chapter discusses how to set up trading partners: Trading Partners on page 3-2. Defining Trading Partner D

Trading Partners3-2 Oracle e-Commerce Gateway User’s Guide Trading PartnersIn the Oracle e-Commerce Gateway, the term ”trading partner” refers to a pa

Trading Partners Trading Partners 3-3The relationship between Oracle e-Commerce Gateway trading partners and trading partner data on the inbound or ou

Defining Trading Partner Data3-4 Oracle e-Commerce Gateway User’s Guide Control Record (0010) section of the interface file. Location code is also in

Defining Trading Partner Data Trading Partners 3-53.Optionally, enter a description for the trading partner group.4. Do one of the following: To add

iv Oracle e-Commerce Gateway User’s Guide Assigning Column Rules ...

Defining Trading Partner Data3-6 Oracle e-Commerce Gateway User’s Guide 4.Optionally, access trading partner flexfields (also known as attributes) by

Defining Trading Partner Data Trading Partners 3-7◗◗ To define trading partner contact data: Optionally, open the Contact tabbed region and enter the

Defining Trading Partner Data3-8 Oracle e-Commerce Gateway User’s Guide

Code Conversion 4-14Code ConversionThis chapter describes the code conversion function of Oracle e-Commerce Gateway: Code Conversion on page 4-2. D

Code Conversion4-2 Oracle e-Commerce Gateway User’s Guide Code ConversionThe Oracle e-Commerce Gateway Code Conversion Module is a flexible and extrem

Code Conversion Code Conversion 4-3predefined categories are included in Oracle e-Commerce Gateway. You may choose to implement these predefined cate

Code Conversion4-4 Oracle e-Commerce Gateway User’s Guide Use of Keys in Code ConversionIn many situations, one set of code conversion rules will not

Code Conversion Code Conversion 4-5The use of keys can also be combined with direction-specific code conversion rules to provide maximum flexibility a

Code Conversion4-6 Oracle e-Commerce Gateway User’s Guide External Values (1-5) from the interface file.All of these values are used to find a recor

Code Conversion Code Conversion 4-7If no match is found, default Internal Value into the External Value 1 field.Processing Keys (1-5)In Oracle e-Comme

vViewing the Status of Concurrent Programs...

Defining Code Conversion Categories4-8 Oracle e-Commerce Gateway User’s Guide During outbound code conversion processing, any Code Conversion Values r

Defining Code Conversion Categories Code Conversion 4-9◗◗ To define additional code conversion categories:1. Navigate to the Code Conversion Categorie

Assigning Categories4-10 Oracle e-Commerce Gateway User’s Guide Assigning Categories For a given transaction, use the Assign Categories window to acti

Predefined Code Categories Code Conversion 4-115.Assign a code conversion category to activate code conversion for the view or application open interf

Predefined Code Categories4-12 Oracle e-Commerce Gateway User’s Guide BUYER_PRODUCT Buyer ProductCARRIER Freight CarrierCOMPANY_CODE CompanyCONTAINER_

Predefined Code Categories Code Conversion 4-13REGION2 Region 2 (for state in certain address tables)REGION3 Region 3SHIP_ORDER_STAT Shipment Order St

Predefined Code Categories4-14 Oracle e-Commerce Gateway User’s Guide See Also Code Conversion on page 4-2. Defining Code Conversion Categories on p

Defining Code Conversion Values Code Conversion 4-15Defining Code Conversion Values Depending upon the EDI standard, user requirements, and the applic

Defining Code Conversion Values4-16 Oracle e-Commerce Gateway User’s Guide The following validation is performed on your entries: External values mus

Interface Data File 5-15Interface Data FileThis chapter discusses how to modify the interface data file and add process or column rules: Changing th

vi Oracle e-Commerce Gateway User’s Guide

Changing the Interface Data File Record Layout5-2 Oracle e-Commerce Gateway User’s Guide Changing the Interface Data File Record Layout Both inbound a

Changing the Interface Data File Record Layout Interface Data File 5-3◗◗ To change the interface data file:1. Navigate to the Interface File Definitio

Changing the Interface Data File Record Layout5-4 Oracle e-Commerce Gateway User’s Guide record number indicates the relative position of a group on t

Assigning Process Rules Interface Data File 5-5Only the record layout code and record layout qualifier from the lowest numbered record position is use

Assigning Process Rules5-6 Oracle e-Commerce Gateway User’s Guide The Assign Process Rules window shows the current transaction and all associated pro

Assigning Column Rules Interface Data File 5-7See AlsoInbound Exception Processing on page 6-2Changing the Interface Data File Record Layout on page 5

Assigning Column Rules5-8 Oracle e-Commerce Gateway User’s Guide Null Dependency Checks if the incoming data for a given column has a null or not null

Assigning Column Rules Interface Data File 5-9Whenever a column rule is violated, the transaction is marked with a violation. These are displayed in

Assigning Column Rules5-10 Oracle e-Commerce Gateway User’s Guide

Inbound Exception Processing 6-16Inbound Exception ProcessingThis chapter discusses how failed inbound transactions are processed and viewed, includi

viiSend Us Your CommentsOracle e-Commerce Gateway User’s Guide, Releas

Inbound Exception Processing6-2 Oracle e-Commerce Gateway User’s GuideInbound Exception ProcessingInbound staged documents are either those that have

Viewing Staged Documents Inbound Exception Processing 6-3Log Only: Places a message in the log file, treats the document as successful, and continues

Viewing Staged Documents6-4 Oracle e-Commerce Gateway User’s GuideThe Status tab displays a hierarchical tree of each failed transaction:The following

Viewing Staged Documents Inbound Exception Processing 6-5Summary information is dynamic. When you select nodes in your tree, summary information for t

Viewing Staged Documents6-6 Oracle e-Commerce Gateway User’s GuideView Staged Documents window, Transaction Tab:2. Select the view, All or Errors Only

Viewing Process Violations Inbound Exception Processing 6-77.Choose Resubmit.8. If you want to delete the document, choose Delete.Deletion occurs for

Viewing Column Violations6-8 Oracle e-Commerce Gateway User’s Guide3.When finished, choose Done. The Process Violations window closes. If you made any

Viewing Column Violations Inbound Exception Processing 6-94.When finished, choose Done. The window closes. See AlsoInbound Exception Processing on pag

Viewing Column Violations6-10 Oracle e-Commerce Gateway User’s Guide

Inbound Transactions 7-17Inbound TransactionsThis chapter describes how to run the Oracle e-Commerce Gateway inbound transactions: Running the Invoic

viii Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of t

Running the Invoice Inbound (INI) Program7-2 Oracle e-Commerce Gateway User’s GuideRunning the Invoice Inbound (INI) Program Use this transaction to i

Running the Invoice Inbound (INI) Program Inbound Transactions 7-3Select Yes to initiate the Payables Open Interface Import program using the default

Running the Price / Sales Catalog Inbound (CATI) Program7-4 Oracle e-Commerce Gateway User’s GuideSubmitting a Request, Oracle Applications User’s Gui

Running the Price / Sales Catalog Inbound (CATI) Program Inbound Transactions 7-54.Open the Parameters window.5. Enter the inbound data file name or a

Running the Response to Request for Quote Inbound (RRQI) Program7-6 Oracle e-Commerce Gateway User’s Guide Release using Autocreate: allows you to u

Running the Response to Request for Quote Inbound (RRQI) Program Inbound Transactions 7-7Prerequisites❏ Create the inbound directory and update the IN

Running the Response to Request for Quote Inbound (RRQI) Program7-8 Oracle e-Commerce Gateway User’s GuideCreate or Update Items: Used with the Price

Running the Ship Notice / Manifest Inbound (ASNI) Program Inbound Transactions 7-9See AlsoInbound Response to Request for Quote, Oracle e-Commerce Gat

Running the Ship Notice / Manifest Inbound (ASNI) Program7-10 Oracle e-Commerce Gateway User’s Guide3.Select the Ship Notice Inbound request.4. Open t

Running the Shipping and Billing Notice Inbound (SBNI) Program Inbound Transactions 7-11Running the Shipping and Billing Notice Inbound (SBNI) Program

ixPrefaceWelcome 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

Running the Shipping and Billing Notice Inbound (SBNI) Program7-12 Oracle e-Commerce Gateway User’s Guide3.Select Shipment and Billing Notice request.

Running the Planning Schedule Inbound (SPSI) Program Inbound Transactions 7-13Running the Planning Schedule Inbound (SPSI) Program Use this transactio

Running the Planning Schedule Inbound (SPSI) Program7-14 Oracle e-Commerce Gateway User’s Guide3.Select the IN: Inbound Planning Schedule (830/DELFOR)

Running the Planning Schedule Inbound (SPSI) Program Inbound Transactions 7-157.In the Execute DSP flag field:Select Yes to initiate the Demand Proces

Running the Production Sequence Schedule Inbound (PSQI) Program7-16 Oracle e-Commerce Gateway User’s GuidePlanning/Material Release Schedule Inbound,

Running the Production Sequence Schedule Inbound (PSQI) Program Inbound Transactions 7-17◗◗ To run the Production Sequence Schedule Inbound Program:Th

Running the Production Sequence Schedule Inbound (PSQI) Program7-18 Oracle e-Commerce Gateway User’s GuideFrom the Release Management Responsibility:1

Running the Shipping Schedule Inbound (SSSI) Program Inbound Transactions 7-19For details on how to automate the process, see: Process Automation, Usi

Running the Shipping Schedule Inbound (SSSI) Program7-20 Oracle e-Commerce Gateway User’s Guide❏ Define trading partner relationships and enable EDI t

Running the Shipping Schedule Inbound (SSSI) Program Inbound Transactions 7-213 = HIGH: High level debug information is written to the concurrent mana