Ready to Download and Run

by arcesb | September 30, 2019

EDI 850 (Purchase Order) to Oracle

Receive 850s from your trading partner and integrate the data into a Oracle back-end.

Download Flow
logo background logo logo

The EDI 850 (Purchase Order) to Oracle sample flow has pre-configured connectors for mapping & integrating the 850 Purchase Order transaction set into a Oracle back-end.

The following connectors make up the core elements of the flow:

  • X12 Connector: Generates EDI files from XML or converts EDI files into XML for further processing.
  • XML Map Connector: Transforms data from one XML format to another, mapping data from the preceeding data format/model into a format/model appropriate for the next connector.
  • Oracle Connector: Allows you to insert or retrieve the data in these documents to or from an Oracle database.

These connectors are configured to automatically move files from one connector to the next until the incoming 850 Purchase Order files are transformed and inserted into Oracle. You can modify the automation settings for each connector in its Automation tab, or you can manually process each step in the workflow using the Send button in the connector's Input tab.

In addition to the pre configured connectors, the sample flow also provides a setup.sql file that contains the SQL commands required to create a generic database schema for these transactions. You can either run this file in your database management system or, copy its contents into the system's query editor to create the tables in your SQLite database

If you would like to use this sample flow in your workspace, please follow these instructions:

Importing Workspace

Create Workspace

First, navigate to the Flows tab and click on the cogwheel icon in the top right corner. Choose the Create Workspace option to create a new Workspace for this sample flow.

Import Workspace

Then, from the same cogwheel dropdown, click Import Workspace. In the resulting dialog, choose the downloaded sample flow 850_to_oracle.arcflow to import the relevant connectors and settings. You can choose to import the flow into any Workspace you like, but we recommend using separate Workspaces for distinct workflows.

Once you have successfully imported the sample flow, you can begin configuring the connectors to best suit your specific use case.

Oracle Connector

Connect to Oracle Database & Test the Connection

Navigate to the Settings tab of the Oracle Connector. In order to establish a connection with your Oracle database, you must enter your Server, Database, User, and Password. Click the Test Connection button to verify that you can connect to your Oracle from CData Arc.

Set up your Output Mapping

After successfully setting up and testing a connection, you can choose to query Oracle for information that will then be used to generate EDI documents. Exactly what data is queried is controlled by the Output Mapping configured in the Oracle Connector's settings. If you would like to execute all output mappings, navigate to the Output tab and click Receive to start retrieving Invoice, Items and Advance Shipment Notice data from the database.

X12 Connectors

Review Interchange Settings for Incoming Documents

Navigate to the Settings tab of the X12 Connector. Review the Interchange Settings and ensure that the following segments contain the correct information:

  1. ISA05 - Sender ID Qualifier
  2. ISA06 - Sender Identifier
  3. ISA07 - Receiver ID Qualifier
  4. ISA08 - Receiver Identifier

Review the Functional Group Settings for Outgoing Documents

Ensure the following segments contain the correct information:

  1. GS02 - Sender Identifier
  2. GS03 - Receiver Identifier

Since incoming documents are received by you, the value X12 is pre configured as the Sender Identifier, and VENDOR as the Receiver Identifier.

The project comes with a sample 850 Purchase Order file, built in templates for Excel, and completely configued XML Map connector that will tranform the XML structure of EDI files into simple human readable XML. If you send this sample file from the pre-configured X12 connector, you can find the 850 Purchase Order file in XLSX format in the Output tab of the Excel connector. You can click on the file to download it and visualize the 850 Purchase Order data in Excel form.

Once you configure the Oracle and X12 Connectors, the sample flow is ready for use!

Tracking Each Document

850 Purchase Order

To test the functionality of this segment of the workflow, you can process a sample 850. Navigate to the Input tab of the X12_X12_In Connector. Select the sample file and click Send to trigger the workflow. The file is then processed and subsequently sent to the XMLMap_850_SalesOrder Connector, the Copy Connector, and finally to the Oracle Connector.

EDI 850 (Purchase Order) to Oracle

Are You Up & Running?

If the answer is yes, congratulations for successfully configuring the EDI 850 (Purchase Order) to Oracle sample flow! However, if you are confronted by any issues or have any further questions, please do not hesitate to contact us.