My Oracle Support Banner

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.

Symptoms

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>

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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