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