My Oracle Support Banner

E1: TDA: Table Columns based on Data Dictionary Item Alias starting with special character @ or # or $ (Doc ID 648795.1)

Last updated on FEBRUARY 06, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Check for relevance April-22-2015


In Table Design Aid, columns are added based on Data Dictionary (DD) Items that have Aliases starting with @ or # or $ to a custom table. When custom table is generated in the SQL/Oracle database, the table columns with the @ or $ character is replaced by _1 for @, _2 for # and _3 for $.

For example, QZ@RT is changed to QZ_1RT, QZ$ABC to QZ_3ABC. Will it cause problem accessing the data in EnterpriseOne?


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

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