E1: DD: Data Dictionary Application P92001 Allows Creation of Data Dictionary Items with Invalid Characters
(Doc ID 2608814.1)
Last updated on DECEMBER 30, 2019
Applies to:JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.
As per the error code 0038 - Characters Invalid, the data item name may not contain any characters other than '@', '#', '$', '0-9' or 'A-Z'. This validation can be overridden in P92001 and then it allows creation of Data Dictionary (DD) items containing invalid special characters (like *, _, / etc.).
Below steps explain how the validation in P92001 can be overridden:
- Open DD application P92001 and look for a DD item. Eg: INT01
- Select the record in the grid and click on Copy button
- For the Alias value, enter DK_INT and tab out. Error 'Characters Invalid' is displayed as expected
- Click inside the same alias value once again and tab out. Now the error message is cleared and can proceed with the creation of DD item with invalid character
Same can also be replicated with Add option instead of Copy. This can be replicated with other non-allowed characters as well.
These DD items can be then added to tables and table index. When running R9698713 on those tables, the PDF output will display error - Error in column name in table: <Table Column Name>
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