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.
Purpose
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!