My Oracle Support Banner

E1: DD: Error Description is Not Displayed on R12855 for Language User - BSFN B9200002 GetDDAlphaDescription Does Not Fetch Domestic Language Record When There is No Record Found in F9203 for User's Language (Doc ID 2678102.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


DISCLAIMER: In the images, examples, video and/or the attached document,  user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.  Any similarity  to actual companies or actual persons, living or dead, is purely  coincidental and is in no way intentional on the part of Oracle.

If language record does not exist in F9203 table, Business Function GetDDAlphaDescription (B9200002) does not return any value for the language profile users.

Before Bug 27294750 was introduced, if there is no language record found in Data Item Alpha Descriptions table (F9203), system will retrieve the corresponding description for Domestic (Blank) Language for Language profile users.


The following shows an example scenario in R12855 Report which uses business function B9200002 to retrieve Error Description.

The description for Error Number '070R' is not retrieved in the report R12855 after setting user profile language to 'DU'.

Previously in 9.1 application release, if the language record was not available in the table F9203, the description of the Domestic (blank) language will be retrieved instead. This is no longer the case in 9.2 application release after Bug 27294750 was introduced.

Note: For this example, in Data Dictionary, there is no description defined for DU - Dutch Language for Data item 070R.

Expected behavior:
If language record is not available in F9203, business function B9200002 should fetch domestic (blank) language record and return the description in domestic language.


Issue is introduced by ESU for Bug 27294750.


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

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