E1: DB: Is The "SYNONYM" Function In SQL Database Server Supported By EnterpriseOne?

(Doc ID 2314616.1)

Last updated on OCTOBER 05, 2017

Applies to:

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

Goal

Client wants information as to whether Enterprise One supports the "SYNONYM" function in SQL database server?
The client has configured the SYNONYM function for an archive data source (database).
When any user tries to access a table, which is pointed to a synonym table, using UTB, the UTB displays an error message that the table does not exist.

Question : Does E1 910 software recognize a synonym table in SQL database?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms