Getting Started with JD Edwards EnterpriseOne Interoperability

  Overview

Every enterprise holds a forest of branched system spread across a number of business units deployed over time. Moreover these systems bring a natural challenge for data migration at the time of system migration towards any ERP suite such as Oracle JD Edwards. Fortunately these data migration challenges is well covered inside JDE through multiple mechanisms. In the series of blogs posts I am going to cover some of the possibilities of data migration with Oracle JD Edwards

Definition of interoperability

According to Wikipedia

"Interoperability is the ability of diverse systems and organizations to work together (inter-operate)."

As any ERP system needs-together in a heterogeneous environment, Oracle JD Edwards are also not far off, and Provid ES number of mechanism to interoperate with and other legacy system with not only the ability to import the data from other SY Stems but also provide communication mechanism to export the data out through number of different mediums.

Available Models for Interoperability

Following diagram outlines the number of interoperability options available with JD Edwards Enterprise one

As can see a number of different in/out communication options is available ranging from exposed Web Services, COM or Java based connectors, but also-to-standard EDI based flat file imports.

Interoperability Scenario

In this article we is going to cover a typical interoperability scenario as follows

We is going to is receiving inventory records from our legacy system using a flat file to populate our Item Master table (F4101). In the first stage, we'll be a using table Conversion (TC) to import our incoming flat file in to our intermediary Z Table (F4101Z1) and in the second stage we'll be using a batch application (r4101z1i) to transfer these imported records from Our Z table safely to our Item Master Table (F4101).

Important terminologies

You must is wondering about some of the terminologies in the given scenario so it best to explain them first

• Batch Applications, these applications allows the execution of large variety of business related functions and CA N be scheduled with the power of CNC (configurable Network Computing) and can share their process load through the use of different application servers.
• Table Conversion, A batch application that allows multiple modes of mechanism to transfer data from one source to another. A source/destination can be internal JDE table or a flat file etc. It provides multitude of features for connectivity & filtration of data stream.
• Z Table, In a Nutshell,these hosts of internal tables provides a safe mechanism to review & audit input data before the final m Igration in live environment.

Now with these definitions on place, let ' s begin

Stage-1: Import from Flat File to Z table through table Conversionprerequisite

Ensure a properly formatted file format with all of the required fields to being populated in the z-table. It is highly recommended to review and understand the target table structure

Execution

2. From the Object Management Workbench (OMW) Create a new batch application.
4. On the ' Add object ' screen, provide an ' object Name ' & ' Description ' for your object & Select the ' Table Conversio n "checkbox. Provide other information & Save your entry.
6. On the "Batch application Design" screens, switch to "Design Tools" tab and press the "Start Table Design Aid" button. This would launch the "Table Conversion Director". At the this point a Wizard would be launched to the guide of a step by step formation to create your table conversion.
8. On the ' Introduction ' screen, select the ' Data Conversion ' option (selected by default) and press the "Next" button.
10. on the "Select Environment" screens, select "<login env>" for both input and output environment and press the "Ne XT "button.
12.  on the "Select Input" screen, switch to "Text File" tab. Provide the complete path to your source flat File in T The He top TextBox and press the "Use" button. As your file is in a custom format, now you need to define it. Check the "User Defined format" checkbox and press the "Define format (s)" button.
    • on the ' User Defined format-type ' screen, select the ' delimited ' option in Format Type and select ' Single Forma T "in row formats. Press the "Next" button.
    • on the ' column Delimiter ' screen, select the ' Comma ' in the ' column Delimiter ' and ' Double quotation ' for ' textual Qua Lifier ". Press the "Next" button.
    • on the ' Column Layout ' screen, define the format of your source file. Use the ' Add ' button to ADD entries as shown in the following diagram. Press "Next" when you were done.
    •  press "Next" on the Summary screen.
14. On the ' Select Outputs ' screen, select the ' Table ' tab and filter out for ' f4101z1 ' Table. Double Click to select it. Press the "Next" button to proceed.
16. On the "Table Options", uncheck the "Run Currency Trigger" checkbox as we is not doing any Currency conversions. Press the "Next" button to proceed.
18. On the ' Mapping ' screen, we are now having to defined the Mapping for our transfer from our source file format to our Z table. Follow the steps below
    • From the ' Events ' drop down, select the ' Row fetched ' event and check the ' Issue a Write for this event? '.
    • Next, from the ' Events ' drop down, select the ' TextLine1 Format fetched ' event and press the ' Advanced ER ' button.
    • In the ' Event Rules Design ', you now need to provide your mapping from input to output. Use the ' x= ' option to provide these mappings as shown below.
    • Save your entries and Exit from "Events Rules Design". Press "Next" button to proceed.
20. On the ' Logging Options ' screen, select ' Log all Errors ' and press the ' Next ' button to proceed.
22. On the final screens, select the "Yes, create a version of this table conversion" and provide name for your table Conversio N version. Press "Finish" to close.
24. Exit from "Table Conversion Director".
26. On the "Batch application Design" screens, on "Design Tools" tab, select the "Version List" button. This launches the (P98305) "Working with Batch versions–available Versions" application.
28. At the should is able to see your Table Conversion created version, double click to select it.
30. On the "Table Conversion prompting" screens, leave all the values to default and press the "Submit" button.
32. At the this point, your table conversion is submitted for processing.
34. Once Do you can review your Z table (F4101Z1) using Universal table Browser (UTB) to confirm your entries.

Stage-2: Import from Z Table to Master tableprerequisite

At this point, your entries has been transferred from the flat file to the target Z Table. Review your entries using the UTB and ensure appropriate transfer of the entries. Once satisfied, you is now a ready-to-transfer these entries from your Z table to your Master table.

Execution

1. From the FAT client, type "BV" on the FAST Path to launch the (P98305) "Working with Batch versions–available Versions".
2. In the "Batch Application" field type "r4101z1i" (without quotes) and press TAB key. Your version list should now is populated.
3. Select the "ZJDE001" version by double clicking on it.
4. At this point, if you want to filter your specific records, you can check the "Data Selection" checkbox, otherwise press T He submit button to submit your batch version.
5. On the ' Processing Options ' screen, press OK to proceed.
6. On the ' report Output Destination ', select the ' On screen ' entry press ' OK '.
7. Upon completion of the execution, your PDF report would be displayed that specifies the entries processed. If the entries were successfully transferred, the "Processed (y/n)" column would say "Y" for those entries.

Troubleshooting

In case of issues, the first thing your should do are review the "work Center" which can accessed from the FAT client (to OLS > Message Management > Work Center) is a reported errors in your data/import process. Review this information very closely as provides relative guideline for corrective actions as well. If that doesn ' t resolute to a solution, JDE Logs along with debugging your table conversion and batch application is the Best available option for troubleshooting the entire process.

Finale

As you can see this Oracle JD Edwards provide a huge variety of solution for managing your data migration, in the Subseque NT Post we'll discuss other forms of methods available.

Getting Started with JD Edwards EnterpriseOne Interoperability