My Oracle Support Banner

E1: ODA: Frequently Asked Questions on Open Data Access (ODA) Known Issues (Doc ID 626125.1)

Last updated on MARCH 12, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information in this document applies to any platform.

Purpose

This document contains questions and answers on issues with Open Data Access (ODA).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Frequently Asked Questions on Open Data Access (ODA) Known Issues
 Joining Tables and Data
 Question 1:  MS Access table join criteria concerning more than 2 fields does not work
 Question 2:  Using table join with same Data Item Names in ODA does not work
 Question 3:  Joining more than 3 tables is difficult
 
 Converting Dates and Numbers
 Question 1:  ODA tries to convert Julian date
 Question 2:  Convert numbers with DB2/400
 Question 3:  ODA does not convert UDC values on import
 
 Configuration Issues
 Question 1:  Driver is installed in the wrong location
 Question 2:  Unable to run a session of E1 if data source is created when E1 is closed
 Question 3:  Is there a way to install/use ODA without installing a full FAT client? 
 Question 4:  How to permanently remove JDEOWODA.DLL from installing on new clients workstations?
 Question 5:  When trying to add ODA ODBC Data Source error code 126 comes up
 
 Miscellaneous Questions On Working with ODA
 Question 1:  Table descriptions with double quotes are not supported
 Question 2:  File link does not work with primary index fields
 Question 3:  Business views with multiple table joins may cause ODA and/or MS Query to fail
 Question 4:  Unable to use MS Project with ODA
 Question 5:  User has wrong version of ODA driver
 Question 6:  Connection pooling is not supported
 Question 7:  Excel does not force a logon when opening an existing ODA spreadsheet
 Question 8:  Non-selected columns are being returned
 Question 9:  Crystal Reports generates incorrect SQL query for tables with quoted names
 Question 10:  Is ODA included in EnterpriseOne 8.12 and above?
 Question 11:  Is ODA being replaced by the Crystal/Oracle connector or will ODA with Crystal reports still be available?
 Question 12:  Importing from Excel Adds Zeros to Numeric Values for All Tables
 Question 13:  Unable to Import Data to Excel on E1 9.1 Fat Client
 Question 14: Does Open Data Access (ODA) check for Security Address Book Data Privacy?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.