My Oracle Support Banner

E1: XMLP: Is the Usage of Calculated Fields in SQL Queries Supported By the EnterpriseOne JDBC driver? (Doc ID 843894.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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

Symptoms

Most databases will allow calculations to be performed directly in SQL queries. For example:

However such query will not execute through Data Access Driver (DAD) but will execute as expected if ran using the native database driver. DAD returns an error indicating it cannot parse the query.

Cause

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
Symptoms
Cause
Solution
References


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