My Oracle Support Banner

E1: DB: Special Characters in Column Name in EnterpriseOne Tables (Doc ID 1274020.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version S21 to 9.2 [Release S21 to 9.2]
Information in this document applies to any platform.


In Payroll module occasionally you may need to issue a query to update a certain column or to delete wrongly created data through pre-payroll process. However it may not be easy for you to update/delete those records through the standard application.

So may require you to issue a query from outside EnterpriseOne for your daily business.  The issue is that the column name that appears in UTB or Central Objects may be different from what your database understands when a column heading for a certain table contains a special character.

Questions and Answers

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
Questions and Answers
 What characters are not allowed for column prefix in creating table(s) through OMW?
 How to verify column prefix through the OMW tool?
 What happens to existing table(s) with a special character?
 Why do conversions take place?
 Will this conversion issue an error or problem?
 How to overcome the above error?
 Is there a list of tables which contain a special character @?

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