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

Last updated on AUGUST 29, 2022

Applies to:

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

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

	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

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

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

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

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?

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