background image

                                                                                

vii

Send Us Your Comments

Oracle e-Commerce Gateway User’s Guide, Release 11

i

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.

Summary of Contents for e-Commerce Gateway 11i.2

Page 1: ...Oracle e Commerce Gateway User s Guide Release 11i 2 August 2000 Part No A75089 02...

Page 2: ...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 Pr...

Page 3: ...acle 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...

Page 4: ...cture 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 Runn...

Page 5: ...ing 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...

Page 6: ...vi Oracle e Commerce Gateway User s Guide...

Page 7: ...amples 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 s...

Page 8: ...me Title 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 inf...

Page 9: ...ork 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...

Page 10: ...structions 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 upgrad...

Page 11: ...sequently 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...

Page 12: ...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 bidirectio...

Page 13: ...e 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...

Page 14: ...acturing 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 documentati...

Page 15: ...escribed 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 Appl...

Page 16: ...vides 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...

Page 17: ...allowing organizations to integrate different computers different operating systems different networks and even different database management systems into a single unified computing and information re...

Page 18: ...xviii...

Page 19: ...view 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 s...

Page 20: ...tion 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...

Page 21: ...s 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...

Page 22: ...e 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 O...

Page 23: ...DV ASNI Inbound Ship Notice Manifest 857 No equivalent SBNI Inbound Shipping and Billing Notice Outbound Transactions 824 APERAK ADVO Outbound Application Advice 810 INVOIC INO Outbound Invoice This i...

Page 24: ...ASNO OPM Outbound Ship Notice Manifest Note The following transactions will be supported in a future release that includes the Oracle Order Management and Oracle Shipping Execution products ASC X12 ED...

Page 25: ...his 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...

Page 26: ...ess 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 tra...

Page 27: ...rs 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 Over...

Page 28: ...ttachment segment size Enabling header level attachments Enabling line level attachments Enabling inventory line attachments Enabling master item attachments System Level Profile Options ECE_IN_FILE_P...

Page 29: ...ransactions 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 Commerc...

Page 30: ...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...

Page 31: ...transaction_code _IITEM_ATT Enables the inventory item attachment for the transaction The default is Yes ECE_ transaction_code _SHIP_ATT Enables the shipment attachment for the transaction The default...

Page 32: ...o the Transaction Profiles window 2 Enter the outbound directory where your outbound interface data files will be stored For example sqlcom outbound 3 Enter the inbound directory where your inbound in...

Page 33: ...lect the address precedence code Refer to the profile option description for the meaning of each address precedence codes See Oracle e Commerce Gateway Profile Options page 4 5 For the Purchase Order...

Page 34: ...he master item attachment Enable or disable the shipment attachment 7 Repeat these steps above for each transaction you use See Also Oracle e Commerce Gateway Profile Options page 4 Setting Your Perso...

Page 35: ...Trading Partners 3 1 3 Trading Partners This chapter discusses how to set up trading partners Trading Partners on page 3 2 Defining Trading Partner Data on page 3 4...

Page 36: ...pplications as location codes Locations codes are used to define any address referenced in an inbound outbound document including trading partners Therefore all e Commerce Gateway trading partners als...

Page 37: ...efine data contained in the X12 N104 segment or EDIFACT NAD segment of a document There are four areas within Oracle Applications where location code can be defined Receivables Customer Addresses Navi...

Page 38: ...e communication medium such as network or direct connection Enable specific transactions by trading partner See Trading Partners on page 3 2 Trading partner groups are used to associate one or more tr...

Page 39: ...ading partner group enter the trading partner location code Then choose the Open button to open the Trading Partners window To define a trading partner within a trading partner group 1 Enter a unique...

Page 40: ...If you are defining the trading partner as a bank select a bank branch address This value is defined in Payables If you are defining internal locations such as your ship from location select the Huma...

Page 41: ...n and enter the EDI contact name title basic address data electronic mail address phone fax number and so on This data is useful for EDI coordinators in case issues arise regarding transmission of EDI...

Page 42: ...Defining Trading Partner Data 3 8 Oracle e Commerce Gateway User s Guide...

Page 43: ...bes the code conversion function of Oracle e Commerce Gateway Code Conversion on page 4 2 Defining Code Conversion Categories on page 4 8 Assigning Categories on page 4 10 Predefined Code Categories o...

Page 44: ...ion integration relationships Code conversion rules in Oracle e Commerce Gateway are defined as a set of to and from values plus additional attributes to determine specific code conversion processing...

Page 45: ...e an additional setup step to enter document standard in the Trading Partner Details form is required See Trading Partner Details section for additional details Code Conversion Based on Direction Dire...

Page 46: ...vel and apply any code conversion rules that apply to the entire category Keys and key hierarchies are user defined and apply to a specific code conversion category Any data element that appears on th...

Page 47: ...rive Internal Value For outbound code conversion values for each of these data elements except External Value 1 5 are used to derive External Value 1 5 Inbound Code Conversion Processing During inboun...

Page 48: ...tegory form determine which fields require outbound code conversion processing Key values are also derived from data in this form Outbound code conversion processing uses Code Conversion Category base...

Page 49: ...l in the hierarchy of key attributes For example trading partner and trading partner location may be defined as two key attributes The logical hierarchy structure will look like this Code Conversion C...

Page 50: ...ories on page 4 8 Assigning Categories on page 4 10 Predefined Code Categories on page 4 11 Defining Code Conversion Values on page 4 15 Defining Code Conversion Categories A category is a label assig...

Page 51: ...keys For example if you want to set the first search key to X12 you must enable Search Key 1 The actual search criteria are entered in the Assign Categories window The actual code conversion values a...

Page 52: ...ach key Prerequisites Define code conversion categories See Defining Code Conversion Categories on page 4 8 To assign code conversion categories 1 Navigate to the Assign Categories window 2 Select a t...

Page 53: ...e Conversion on page 4 2 Defining Code Conversion Categories on page 4 8 Predefined Code Categories on page 4 11 Defining Code Conversion Values on page 4 15 Predefined Code Categories The following a...

Page 54: ...ument Type EQUIPMENT Equipment FOB FOB FOB_PAYMENT FOB Payment FREIGHT_TERMS Freight Terms HAZ_CLASS Hazardous Class HAZ_MAT Hazard Material INVOICE_SITE Invoice Site INVOICE_TYPE Invoice Type ITEM_CA...

Page 55: ...SUPPLIER_SITE Supplier Site TAX_CODE Tax Code TAX_EX Tax Exempt Flag TAX_EXRSN Tax Exemption Reason TAX_JURS Tax Jurisdiction TRANS_TERM Transportation Terms TRX_HANDL Transaction Handling TRX_PURP Tr...

Page 56: ...ategories 4 14 Oracle e Commerce Gateway User s Guide See Also Code Conversion on page 4 2 Defining Code Conversion Categories on page 4 8 Assigning Categories on page 4 10 Defining Code Conversion Va...

Page 57: ...ites Define code conversion categories See Defining Code Conversion Categories on page 4 8 Assign Code Conversion Categories See Assigning Categories on page 4 10 To define code conversion values 1 Na...

Page 58: ...want to perform code conversion based on document standard enter that document standard in Search Key 1 Use this only if search keys are enabled in the Code Conversion Categories window and columns a...

Page 59: ...e Data File This chapter discusses how to modify the interface data file and add process or column rules Changing the Interface Data File Record Layout on page 5 2 Assigning Process Rules on page 5 5...

Page 60: ...nge sequence of the five external fields resulting from code conversion Change the record layout code Change the record layout qualifier By making the interface data file formats table driven your for...

Page 61: ...on open interface tables for inbound transactions The levels may differ when compared to the base application tables as data is denormalized All the records for the data level are displayed The data f...

Page 62: ...values table is moved to the external 1 code in the interface table external code 2 in the code conversion values table is moved to the external 2 code in the interface table and so on For example pl...

Page 63: ...he lowest numbered record position is used in the interface data file 10 If you want to define process rules choose Process Rules If you want to define column rules choose Column Rules The number of r...

Page 64: ...5 1 Process Rules and Descriptions Process Rule Description Invalid Document Address Any address referenced in an inbound interface data file ship to bill to remit to must correspond to an address or...

Page 65: ...shows a column in the selected transaction and all associated column rules These fields are read only For each of the column rules select the appropriate action Certain column rules require additional...

Page 66: ...qual to a value in a predefined list in the e Commerce Gateway Check must be either Must Equal or Not Equal to indicate the comparison condition The incoming value must match one of the values in the...

Page 67: ...bort Run stops the processing of the document and sets status to Error Disabled Prevents the rule from being enforced Log Only Places a message in the log file and continues processing Skip Document S...

Page 68: ...Assigning Column Rules 5 10 Oracle e Commerce Gateway User s Guide...

Page 69: ...his chapter discusses how failed inbound transactions are processed and viewed including the following topics Inbound Exception Processing on page 6 2 Viewing Staged Documents on page 6 3 Viewing Proc...

Page 70: ...valid trading partner based on data in the control record 0010 Invalid document address such as ship to bill to and so on based on addresses in the detail of the transaction Test production flag discr...

Page 71: ...iolations for inbound transactions or on all inbound transactions that have been loaded into the staging tables but not yet processed The left side of the window has two tabs Transaction and Status Th...

Page 72: ...Summary tab on right side of the window displays read only summary information that corresponds to the level selected on the left side of the window For example if you drill down on the Transaction Ty...

Page 73: ...ional Set up column rules and actions for data elements in each transaction using the Interface File Definition window The e Commerce Gateway may have seeded rules and actions for the validation of so...

Page 74: ...e Process Violations or Column Violations to drill down on the details 6 After you complete the appropriate setup or have decided to ignore rule violations position your cursor within the navigation t...

Page 75: ...racle application To view process violations 1 Navigate to the Process Violations window Do this by choosing Process Violations from the View Staged Documents window The Process Violations window disp...

Page 76: ...ed with a violation All violations appear in the Column Violation window You can choose to override the violation in that particular transaction by selecting Ignore Doing so means the column rule is i...

Page 77: ...Violations Inbound Exception Processing 6 9 4 When finished choose Done The window closes See Also Inbound Exception Processing on page 6 2 Viewing Staged Documents on page 6 3 Viewing Process Violati...

Page 78: ...Viewing Column Violations 6 10 Oracle e Commerce Gateway User s Guide...

Page 79: ...ram on page 7 4 Running the Response to Request for Quote Inbound RRQI Program on page 7 6 Running the Ship Notice Manifest Inbound ASNI Program on page 7 9 Running the Shipping and Billing Notice Inb...

Page 80: ...eason use the Invoice Approvals window Prerequisites Create the inbound directory and update the INIT ORA file See Defining Data File Directories Oracle e Commerce Gateway Implementation Manual Releas...

Page 81: ...e optional Enter Yes if you wish to delete the invoice data from the Payables Open Interface tables after the data has been imported into Oracle Payables Debug Mode Set the debug mode to report on deb...

Page 82: ...des at the site level Set the INV Default Item Status profile to Active Prerequisites Create the inbound directory and update the INIT ORA file See Defining Data File Directories Oracle e Commerce Gat...

Page 83: ...s Catalog or Response to RFQ to be imported The document sub type of Bid Quotation is invalid for the transaction Create or Update Items Used with the Price Sales Catalog or Response to RFQ to indicat...

Page 84: ...option generates much information 8 When finished choose OK in the Parameters window 9 Enter schedule options to schedule the request 10 Enter completion options 11 Choose Submit and make a note of t...

Page 85: ...inbound program 1 Navigate to the Import Program window 2 Select Request to submit an individual request 3 Select the Response to RFQ request 4 Open the Parameters window 5 Enter the inbound data fil...

Page 86: ...matic Release allows Purchasing to automatically generate approved blanket releases for items that are autosourced to a single supplier Automatic Release with Review allows Purchasing to automatically...

Page 87: ...No A value of Yes indicates the original Purchase Order shipment line is displayed in the Find Expected Receipts in addition to the ASN Shipment line Prerequisites Create the inbound directory and upd...

Page 88: ...written to the concurrent manager log file OFF No debug information is generated LOW Summary debug information is written to the concurrent manager log file MEDIUM Medium level debug information is w...

Page 89: ...ine is displayed in the Find Expected Receipts in addition to the ASN Shipment line Prerequisite Setup in Oracle Payables Supplier site must be defined as a Pay on Receipt site Prerequisites Create th...

Page 90: ...is written to the concurrent manager log file OFF No debug information is generated LOW Summary debug information is written to the concurrent manager log file MEDIUM Medium level debug information is...

Page 91: ...ce Gateway Create the inbound directory and update the INIT ORA file See Defining Data File Directories Oracle e Commerce Gateway Implementation Manual Release 11i Define the ECE Inbound file path pro...

Page 92: ...en to the concurrent manager log file The Debug Mode is set using a number 0 OFF No debug information is generated 1 LOW Summary debug information is written to the concurrent manager log file 2 MEDIU...

Page 93: ...ion is written to the concurrent manager log file 3 HIGH High level debug information is written to the concurrent manager log file This option generates an abundance of information 11 When finished c...

Page 94: ...ce Gateway Trading Partner Setup in conjunction with Oracle Release Management Processing Rules For more details on Oracle Release Management Setup steps refer to Oracle Release Management Implementat...

Page 95: ...Processor Select No if you do not want to initiate the Demand Processor 8 Enter the Transaction Type PSQI defaulted 9 Enter the Map Code for this file RLM_PSQI_FF 10 Select the Debug Mode 0 1 2 or 3 S...

Page 96: ...et the Debug Mode to report on debug information for troubleshooting Debug information is written to the concurrent manager log file The Debug Mode is set using a number 0 OFF No debug information is...

Page 97: ...g schedules into your Oracle Release Management system Using the Release Management Demand Processor you can import customer shipping schedules into your Oracle Order Management and Oracle Planning sy...

Page 98: ...om the EC Gateway Responsibility 1 Select the Process Import Program 2 Select Request to submit an individual request 3 Select the IN Inbound Shipping Schedule 862 DELJIT request 4 Open the Parameters...

Page 99: ...o initiate the Demand Processor Select No if you do not want to initiate the Demand Processor 7 Enter the Transaction Type SSSI 8 Enter the Map Code for this file RLM_SSSI_FF 9 Select the Debug Mode 0...

Page 100: ...how to automate the process see Process Automation Using e Commerce Gateway for Inbound Demand Oracle Release Management Implementation Manual Release 11i See Also Viewing the Status of Concurrent Pr...

Page 101: ...ce Outbound INO Extract Program on page 8 7 Running the Credit Memo Debit Memo CDMO Extract Program on page 8 9 Running the Payment Order Remittance Advice Outbound PYO Extract Program on page 8 10 Ru...

Page 102: ...lication must be merged with Oracle Applications data to create a single outbound transaction For complete information see Extensible e Commerce Gateway Architecture Oracle e Commerce Gateway Implemen...

Page 103: ...the Interface Data File Record Layout on page 5 2 To run the Application Advice outbound extract program 1 Navigate to the Extract Program window 2 Select Request to submit an individual request 3 Sel...

Page 104: ...Manual Release 11i Submitting a Request Oracle Applications User s Guide Viewing the Status of Concurrent Programs on page 9 7 Running the INTRASTAT Movement Statistics MVSTO Extract Program Intrastat...

Page 105: ...Release 11i Define trading partner relationships and enable EDI transactions for the trading partner See Defining Trading Partner Data on page 3 4 Define code conversions See Defining Code Conversion...

Page 106: ...ormation is written to the concurrent manager log file OFF No debug information is generated LOW Summary debug information is written to the concurrent manager log file MEDIUM Medium level debug infor...

Page 107: ...nsaction Prerequisites Create the outbound directory and update the INIT ORA file See Defining Data File Directories Oracle e Commerce Gateway Implementation Manual Release 11i Define the ECE Output f...

Page 108: ...ager log file OFF No debug information is generated LOW Summary debug information is written to the concurrent manager log file MEDIUM Medium level debug information is written to the concurrent manag...

Page 109: ...profile option See e Commerce Gateway Profile Options Oracle e Commerce Gateway Implementation Manual Release 11i Define trading partner relationships and enable EDI transactions for the trading part...

Page 110: ...t 7 Enter completion options 8 Choose Submit and make a note of the Request ID returned See Also Outbound Credit Memo Debit Memo Oracle e Commerce Gateway Implementation Manual Release 11i Submitting...

Page 111: ...action Prerequisites Create the outbound directory and update the INIT ORA file See Defining Data File Directories Oracle e Commerce Gateway Implementation Manual Release 11i Define the ECE Output fil...

Page 112: ...chedule to communicate short term firm requirements and shipping schedules to your suppliers Shipping schedules are usually stated in daily buckets and are used to refine planning schedules in support...

Page 113: ...is replenished for a given organization This includes the ability to identify multiple supplier sources their percentage splits and priority ranking Information related to unimplemented planned order...

Page 114: ...is written to the concurrent manager log file MEDIUM Medium level debug information is written to the concurrent manager log file HIGH High level debug information is written to the concurrent manager...

Page 115: ...d orders blanket purchase agreements or blanket releases Use Purchasing to approve POs before transmitting them to your supplier You can attach text to the outbound Purchase Order and the Purchase Ord...

Page 116: ...an output data file name if you are not using the default Enter PO numbers From and To Enter PO creation dates From and To Enter the PO type Enter the supplier name and supplier site Set the debug mod...

Page 117: ...d purchase order PO You may include changes for approved POs of the type standard POs planned POs planned releases blanket purchase agreements and blanket releases Supported changes by this transactio...

Page 118: ...ne and shipment levels See Attachments on page 8 20 If your Purchasing system option is set to Archive on Approval you must reapprove changed POs before transmitting them to your supplier Prerequisite...

Page 119: ...tion Debug information is written to the concurrent manager log file OFF No debug information is generated LOW Summary debug information is written to the concurrent manager log file MEDIUM Medium lev...

Page 120: ...shipment levels Attachments can be stored as short text up to 2 Kilobytes or long text up to 2 Gigabytes of data Each attachment can be split into segments or records Segment size is set using the POO...

Page 121: ...merce Gateway reports Reports on page 9 2 Code Conversion Values Report on page 9 2 Interface File Data Report on page 9 3 Transaction Layout Definition Report on page 9 5 Trading Partner Report on pa...

Page 122: ...ion Values Report Reports all defined code conversion values This data can be used for troubleshooting purposes You can report on all or specific code categories internal values and external values Pr...

Page 123: ...characters Number is numeric Date for date format YYYYMMDD HHMMSS where for the date portion YYYY indicates the four digit year 1997 not 97 MM is month and DD is day The time portion HHMMSS where HH i...

Page 124: ...ions application column is the source column of the Oracle data within the Application Table For inbound transactions the application column is the column within the interim Application Table of the O...

Page 125: ...ral blocks of 1000 Parameters Transaction Code Enter the e Commerce Gateway transaction code or leave blank to report on all transactions See EDI Transaction Support on page 1 5 Include Data Not Mappe...

Page 126: ...e Last Update From To Enter the date the trading partner was last updated From and or To Both are optional If the From date is blank all trading partners are listed until the To date If the To date is...

Page 127: ...g the Status of Concurrent Programs To view the status of your concurrent programs Choose View My Requests from the Help menu of the Submit Requests window and identify your request for inbound or out...

Page 128: ...Viewing the Status of Concurrent Programs 9 8 Oracle e Commerce Gateway User s Guide...

Page 129: ...ths A 1 A Windows and Navigator Paths This appendix shows you the default Navigator path for each e Commerce Gateway window Refer to this appendix when you do not already know the Navigator path for a...

Page 130: ...ories Setup Code Conversion Define Code Conversion Categories Assign Categories Setup Code Conversion Assign Code Conversion Categories Code Conversion Values Setup Code Conversion Define Code Convers...

Page 131: ...Data Reconciliation This appendix describes what seed data is in Oracle e Commerce Gateway and explains how to reconcile your seed data when upgrading Seed Data Reconciliation on page B 2 Performing S...

Page 132: ...saction record layout if a patch updated the transaction record layout or accept the new transaction record layout Retaining the preexisting transaction record layout gives you a record layout that mi...

Page 133: ...de record position length record layout and qualifier Table B 1 Seed Data Reconciliation Example Data Element Record Layout Attributes Notes Before Patch In the Patch ABC 1000 100 30 RF REF 1000 100 5...

Page 134: ...ntify transactions that may have potential transaction record layout changes Select the Run Reports under Reports in the e Commerce Gateway menu Submit the Transaction Layout Definition Report to obta...

Page 135: ...ode Any new record layout definitions defined in the patch will be automatically merged into your preexisting record layout unless a discrepancy is found Selecting No means that the transaction record...

Page 136: ...on page 9 2 Review Seed Data Reconciliation Request Log If you select no for the Preserve the Transaction Layout parameter above this log will provide summary information about the Seed Data Reconcili...

Page 137: ...el 1 unchanged Conversion Sequence for Column ASN_TYPE at Output Level 1 unchanged Record Layout Code for Column ASN_TYPE at Output Level 1 unchanged Record Layout Qualifier for Column ASN_TYPE at Out...

Page 138: ...form to reapply these assignments and definitions Review and Modify for Post Processes if necessary Notify trading partners if there are interface file changes that affect their process If the new tr...

Page 139: ...by ANSI and maintains and develops the EDI standards for the United States and Canada ASCII American Standard Code for Information Interchange A standard file format used for transmission and storage...

Page 140: ...business information electronically such as Electronic Data Interchange EDI FAX email and eforms Electronic Data Interchange EDI Exchanging business documents electronically between trading partners...

Page 141: ...ping and maintaining the rules and guidelines for using the ACH network P payment batch A group of invoices selected for automatic payment processing via Oracle Payables AutoSelect function payment do...

Page 142: ...work Supplier W wire A payment method where you pay invoices by notifying your bank to debit your account and credit your suppliers account WP4 Working Party 4 on the facilitation of international tra...

Page 143: ...e Conversion Values Report 9 2 Column rules 5 7 Column violations 6 8 D Data file 5 2 Defining Code Conversion Categories 4 8 Defining Code Conversion Values 4 15 Defining Trading Partner Data 3 4 E E...

Page 144: ...onse to Request for Quote inbound importing 7 6 S Seed data reconciliation B 4 Setting Profile Options 2 8 Setup 2 2 Ship Notice Manifest inbound importing 7 9 Shipping and Billing Notice inbound impo...

Reviews: