E1: TDA: Table Columns based on Data Dictionary Item Alias starting with special character @ or # or $
Last updated on MAY 30, 2017
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?
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