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

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

Goal

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?

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