Go to main content
1/32
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Tools Interoperability
1.1
JD Edwards EnterpriseOne Tools Interoperability Overview
1.2
JD Edwards EnterpriseOne Tools Interoperability Implementation
2
Understanding Interoperability
2.1
Interoperability
2.2
Interoperability Features
2.2.1
Benefits
2.3
Interoperability Models and Capabilities
2.3.1
Auditing for Interoperability Transactions
2.3.2
JD Edwards EnterpriseOne Interoperability
2.3.3
Interoperability Capabilities
2.3.3.1
Web Services
2.3.3.2
J2EE Connectivity
2.3.3.3
Business Function Calls
2.3.3.4
XML
2.3.3.5
Z Transactions
2.3.3.6
Flat Files
2.3.3.7
Events
2.3.4
Interoperability Models
2.3.4.1
Business Services Server
2.3.4.2
JMS Queue and JMS Topic
2.3.4.3
Connectors
2.3.4.4
Messaging Adapters
2.3.4.5
Batch Interfaces
2.3.4.6
Interface Tables
2.3.4.7
EDI
2.3.4.8
Table Conversion
2.3.4.9
OSA
2.3.4.10
ODA
2.4
Interoperability Model Selection
2.5
Other Industry Standard Support
3
Understanding Integrations in a SOA Environment
3.1
JD Edwards Enterprise Integrations in a SOA Environment
3.1.1
Web Service Provider
3.1.2
Web Service Consumer
3.1.3
Event Notification
3.2
Business Services Architecture
3.3
Environments
3.4
Integration Patterns
3.4.1
JD Edwards EnterpriseOne as a Web Service Provider - Synchronous Request/Reply
3.4.2
JD Edwards EnterpriseOne as a Web Service Provider - Asynchronous Notification
3.4.3
JD Edwards EnterpriseOne as a Web Service Provider - Asynchronous Request/Reply
3.4.4
JD Edwards EnterpriseOne as a Web Service Consumer - Notification
3.4.5
JD Edwards EnterpriseOne as a Web Service Consumer – Synchronous Web Service Request/Reply
3.4.6
JD Edwards EnterpriseOne as a Service Consumer – Asynchronous HTTP Request/Response
3.4.7
JD Edwards EnterpriseOne as a Service Consumer – Synchronous HTTP Request/Response
3.4.8
JD Edwards EnterpriseOne as a Web Service Consumer – Asynchronous Web Service
4
Using Business Function Calls
4.1
Understanding Business Functions
4.2
Reviewing API and Business Function Documentation
4.3
Creating Business Function Documentation
4.4
Finding Business Functions
4.4.1
Using the Object Management Workbench
4.4.2
Using the Cross Reference Facility
4.4.3
Using the Debug Application
5
Understanding XML
5.1
XML and JD Edwards EnterpriseOne
5.2
XML JAR Files
5.3
XML Document Format
5.3.1
Formatting XML Documents
5.3.2
Type Element
5.3.3
Establish Session
5.3.4
Expire Session
5.3.5
Explicit Transaction
5.3.6
Implicit Transaction
5.3.7
Prepare/Commit/Rollback
5.3.8
Terminate Session
5.4
XML Standards
5.4.1
Decimal and Comma Separators
5.4.2
Date Usage
5.4.3
Industry Standards for Special Characters
5.5
System Environment Configuration
5.5.1
UNIX
5.5.1.1
AIX
5.5.1.2
Solaris
5.5.1.3
Linux
5.5.1.4
HP-UX
5.5.2
IBM i
5.5.3
Microsoft Windows
5.6
XML Kernel Troubleshooting
6
Understanding XML Dispatch
6.1
XML Dispatch
6.2
XML Dispatch Processing
6.3
XML Dispatch Recognizers
6.4
XML Dispatch Transports
6.5
XML Dispatch jde.ini File Configuration
6.5.1
[JDENET_KERNEL_DEF22]
6.5.2
[XMLLookupInfo]
6.6
XML Dispatch Error Handling
6.7
Submit a UBE from XML
6.7.1
Prerequisites
7
Understanding XML Transformation Service
7.1
XML Transformation Service
7.2
XTS Process
7.2.1
Example: JD Edwards EnterpriseOne Native XML Format
7.2.2
Example: JD Edwards EnterpriseOne Version 1 XML Format
7.3
Custom Selectors
7.3.1
XTS APIs
7.3.2
Example: Creating a Selector
7.4
XTS jde.ini File Configuration
7.4.1
[JDENET_KERNEL_DEF23]
7.4.2
[JDENET]
7.4.3
[XTSRepository]
7.4.4
[XTS]
8
Understanding XML CallObject
8.1
XML CallObject
8.2
XML CallObject Templates
8.3
XML CallObject Process
8.4
XML CallObject Document Format
8.4.1
XML CallObject Formatting Documents
8.4.2
Call Object
8.4.3
OnError Handling
8.4.4
Call Object Error Handling
8.4.5
Error Text
8.4.6
Multiple Requests per Document
8.4.7
ID/IDREF Support
8.4.8
Return NULL Values
8.5
XML CallObject jde.ini File Configuration
8.5.1
[JDENET_KERNEL_DEF6]
8.5.2
Example: CallObject Request
8.5.3
Example: CallObject Response
8.6
XML CallObject Return Codes
9
Understanding XML Transaction
9.1
XML Transaction
9.2
XML Transaction Update Process
9.3
XML Transaction Data Request
9.4
XML Transaction jde.ini File Configuration
9.4.1
[JDENET_KERNEL_DEF15]
9.4.2
Example: Outbound Order Status XML Request and Response Format
9.4.3
Example: Inbound XML Transaction Request and Response Sample Code
10
Understanding XML List
10.1
XML List
10.2
List-Retrieval Engine Table Conversion Wrapper
10.3
XML List Process
10.4
XML List Requests
10.4.1
Creating a List
10.4.2
Retrieving Data from a List
10.4.3
Deleting a List
10.4.4
Getting Column Information for a List
10.5
List-Retrieval Engine jde.ini File Configuration
10.6
XML List jde.ini File Configuration
10.6.1
[JDENET_KERNEL_DEF16]
11
Processing Z Transactions
11.1
Understanding Z Transactions
11.2
Naming the Transaction
11.3
Adding Records to the Inbound Interface Table
11.4
Running an Update Process
11.4.1
Running an Input Batch Process
11.4.2
Running a Subsystem Job
11.5
Checking for Errors
11.6
Confirming the Update
11.7
Purging Data from the Interface Table
12
Using Flat Files
12.1
Understanding Flat Files
12.2
Formatting Flat Files
12.3
Setting Up Flat Files
12.4
Converting Flat Files Using the Flat File Conversion Program
12.4.1
Forms Used to Convert Flat File Information
12.4.2
Defining the Flat File Cross Reference Table
12.4.2.1
Flat File Cross Reference
12.5
Importing Flat Files Using a Business Function
12.5.1
Map the F98713 table in the System Data Source
12.5.2
Ensure the F98713 table Exists in the Business Data Source
12.5.3
Flat File Conversion Error Messages
12.6
Converting Flat Files Using APIs
12.6.1
Forms Used to Convert Flat File Information
12.6.2
Setting Up Flat File Encoding
12.6.2.1
Flat File Encoding Configuration
13
Understanding Messaging Queue Adapters
13.1
JD Edwards EnterpriseOne and Messaging Queue Systems
13.2
Data Exchange Between JD Edwards EnterpriseOne and a Messaging Queue Adapter
13.2.1
Sending Information to JD Edwards EnterpriseOne
13.2.1.1
Inbound Process Flow
13.2.2
Retrieving Information from JD Edwards EnterpriseOne
13.2.2.1
Z Event Processing
13.2.2.2
Enabling Z Events Interface Table Processes
13.2.2.3
Outbound Table Adapter Function
13.2.2.4
Outbound Notification
13.2.3
XML Interface Table Inquiry API
13.3
Management of the Messaging Queue Adapter Queues
13.3.1
Inbound Queue
13.3.2
Outbound Queue
13.3.3
Success Queue
13.3.4
Error Queue
13.3.5
Default Response Queue
13.4
Configuration of the jde.ini File to Support Messaging Queue Adapters
14
Using Guaranteed Events
14.1
Understanding Guaranteed Events
14.2
Processing Guaranteed Events
14.2.1
Understanding Guaranteed Events Processing
14.2.2
Aggregating Events
14.2.3
Logging Events
14.2.4
Configuring the Transaction Server
14.3
Setting Up OCM for Guaranteed Events
14.3.1
Understanding OCM Setup for Guaranteed Event Delivery
14.3.2
Forms Used to Set Up OCM for Guaranteed Event Delivery
14.3.3
Setting Up the OCM for Guaranteed Event Delivery
14.4
Defining Events
14.4.1
Understanding Events Definition
14.4.2
Forms Used to Enter Events
14.4.3
Adding a Single or Container Event
14.4.3.1
Event Definition Detail
14.4.3.2
Activating an Event
14.4.3.3
Refreshing the Transaction Server Cache of Active Events
14.5
Establishing Subscriber and Subscription Information
14.5.1
Understanding Subscribers and Subscriptions
14.5.2
Forms Used to Add a Subscriber and Subscription Information
14.5.3
Setting Up Processing Options for Adding JMS Queue as a Subscriber
14.5.4
Adding a Subscriber
14.5.5
Adding a Subscription
14.5.6
Associating a Subscription with Subscribed Events
14.5.7
Associating a Subscription with Subscribed Environments
14.6
Creating MSMQ Queues
14.6.1
Prerequisites
14.6.2
Understanding MSMQ
14.6.3
Creating an MSMQ Real-Time Event Queue
14.6.4
Verifying Event Delivery
14.7
Creating WebSphere MQ Queues
14.7.1
Prerequisites
14.7.2
Understanding WebSphere MQ
14.7.3
Creating a WebSphere MQ Real-Time Event Queue
14.7.4
Configuring WebSphere
14.7.5
Verifying Event Delivery
14.8
Creating WebLogic Message Queues
14.8.1
Prerequisites
14.8.2
Understanding WebLogic Message Queue
14.8.3
Creating a JMS Server in the WebLogic Server
14.8.4
Creating a JMS Module in the WebLogic Server
14.8.5
Creating a Connection Factory
14.8.6
Creating a Destination
14.8.7
Verifying Event Delivery
14.9
Creating Custom Real-Time Events
14.9.1
Creating a Custom Real-Time Event
14.10
Generating Schemas for Event XML Documents
14.10.1
Understanding the Schema Generation Utility
14.10.1.1
Prerequisite
14.10.2
Configuring the Schema Generation Utility
14.10.3
Using the Schema Generation Utility
14.10.3.1
Prerequisites
14.10.3.2
Logging In to the Schema Generation Utility
14.10.3.3
Event Schema Generator Screen
14.10.3.4
Displaying Event Schema
14.10.3.5
Generating Event Schema for Single and Multiple Events
14.10.3.6
Generating Event Schema for All the Events of a Selected Event Category
14.10.3.7
Generating Header Schema
14.10.4
Troubleshooting the Schema Generation Utility
14.11
Versioning Real-Time Events
14.11.1
Understanding Why a Version Is Required
14.11.2
Determining if a Version is Required
14.11.2.1
Changing the Event Type
14.11.2.2
Changing the Event Data
14.11.3
Naming Conventions for Real-Time Event Versions
14.11.4
References to Other Documentation
15
Using Guaranteed Real-Time Events
15.1
Understanding Guaranteed Real-Time Events
15.2
Generating Real-Time Events
15.2.1
Understanding Real-Time Event Generation
15.2.2
Using Real-Time Event APIs
15.2.3
Interoperability Event Interface Calls Sample Code
16
Using Guaranteed XAPI Events
16.1
Understanding Guaranteed XAPI Events
16.1.1
JD Edwards EnterpriseOne to Third-Party
16.1.2
Third-Party to JD Edwards EnterpriseOne
16.1.3
JD Edwards EnterpriseOne-to-EnterpriseOne
16.2
Using JD Edwards EnterpriseOne as a XAPI Originator
16.3
Using JD Edwards EnterpriseOne as a XAPI Executor
16.4
Working with JD Edwards EnterpriseOne and Third-Party Systems
16.4.1
Understanding XAPI Processing between JD Edwards EnterpriseOne and Third-Party Systems
16.4.2
XAPI Outbound Request APIs
16.4.3
XAPI Outbound Request API Usage Code Sample
16.4.4
XAPI Inbound Response APIs
16.4.5
XAPI Inbound Response API Usage Code Sample
16.5
Using JD Edwards EnterpriseOne-to-EnterpriseOne Connectivity
16.5.1
Understanding JD Edwards EnterpriseOne-to-EnterpriseOne Connectivity
16.5.1.1
Modify Element Name for XML Documents
16.5.1.2
Security for Originator and Executor
16.5.1.3
Error Processing for Originator and Executor
16.5.2
XAPI Outbound Request Handling APIs
16.5.3
XAPI Outbound Request Parsing API Usage Sample Code
16.5.4
XAPI Inbound Response Generation APIs
16.5.5
XAPI Inbound Response Parsing API Usage Sample Code
16.5.6
XAPI Error Handling APIs
16.6
Mapping a Business Function
16.6.1
Understanding how to Map a Business Function
16.6.2
Forms Used to Add Mapping Information
16.6.3
Adding Mapping Information
17
Using Guaranteed Z Events
17.1
Understanding Guaranteed Z Events
17.2
Z Event Process Flow
17.3
Vendor-Specific Outbound Functions
17.4
Working With Z Events
17.4.1
Configuring Z Events
17.4.2
Enabling Z Event Processing
17.4.3
Updating Flat File Cross-Reference
17.4.4
Updating the Processing Log Table
17.4.5
Verifying that the Subsystem Job is Running
17.4.6
Purging Data from the Interface Table
17.4.7
Synchronizing F47002 Records with F90701 Records
17.5
Setting Up Data Export Controls
17.5.1
Understanding Data Export Controls Records
17.5.2
Forms Used to Add a Data Export Controls Record
17.5.3
Adding a Data Export Control Record
18
Using Batch Interfaces
18.1
JD Edwards EnterpriseOne Interface Tables
18.1.1
Structuring Interface Tables
18.1.2
Updating JD Edwards EnterpriseOne Records
18.1.3
Retrieving JD Edwards EnterpriseOne Records
18.1.3.1
Running an Extraction Batch Process
18.1.3.2
Subsystem Business Function
18.1.4
Using the Revision Application
18.1.5
Purging Interface Table Information
18.2
Electronic Data Interface
18.3
Table Conversion
18.4
Output Stream Access UBEs
19
Using Open Data Access
19.1
Understanding Open Data Access
19.2
Installing ODA
19.2.1
Hardware Requirements
19.2.2
Software Requirements
19.2.3
ODBC Component Files
19.2.4
ODA Driver Architecture
19.3
Working with Data Sources
19.3.1
Adding a Data Source
19.3.2
Modifying a Data Source
19.3.3
Deleting a Data Source
19.3.4
Configuring a Data Source
19.3.5
Connecting a Data Source
19.4
Working with ODA
19.4.1
Manipulating Data
19.4.2
Using Keywords in the Connection String
19.4.3
Running a Query Using Microsoft Excel
19.5
Managing ODA Error Messages
20
Using the Java Database Connectivity Driver
20.1
Using the JDBC Driver
20.1.1
When to Use a JDBC Driver
20.1.1.1
Prerequisites
20.1.1.2
Using the Type 3 JDBC Driver
20.1.1.3
Using the Type 4 JDBC Driver
20.1.2
Connection Mode
20.2
JDBC Driver Configuration
20.3
JDBC Driver Connection Details
20.3.1
Driver Class Name
20.3.2
Connection URL
20.3.3
Connection Properties
20.3.3.1
Example Showing How to Use Connection Properties
20.4
JDBC Driver Security Considerations
20.5
SQL Grammar
20.5.1
SQL Grammar for JD Edwards EnterpriseOne Connection Modes
20.6
JDBC Driver Features
20.6.1
JDBC Features for the Connection Mode
20.7
JDBC Driver Troubleshooting
20.7.1
No Suitable Driver
20.7.2
Data Source for F0010, TBLE Not Found
20.7.3
Table Specifications Do Not Exist (Type 3 JDBC only)
21
Setting Up Orchestration Cross-References
21.1
Understanding Orchestration Cross-References
21.1.1
Cross-Reference Categorization
21.2
Adding Cross-Reference Object Types
21.3
Adding Orchestration Cross-References
21.4
Reviewing or Modifying Orchestration Cross-References
21.5
Deleting Orchestration Cross-References
A
Interoperability Interface Table Information
A.1
Interoperability Interface Table Information
B
XML Format Examples (All Parameters)
B.1
Inbound Sales Order XML Format (All Parameters)
B.2
Inbound XML Transaction Request and Response Format
B.2.1
Request
B.2.2
Response
B.3
Outbound XML Request and Response Format (All Parameters)
B.3.1
Request
B.3.2
Response
C
Minimum Required Values Sample Code
C.1
Sales Order Minimum Required Values
D
XML Format Examples (Events)
D.1
Example: Z Events XML Format
D.2
Real-Time Events Template
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.