IJ06721: DATE PARAMETERS GET CORRUPTED WHEN CUSTOM DATE DISPLAYDATE UTILIZED FOR NON BASE LANGUAGE

APAR status

• Closed as program error.

Error description

• When date format is defined using Setting.DISPLAYDATE_<lang>,
  Maximo uses language from the locale to find the date format,
  where as for the date parameter BIRT Report integration uses
  language of the user to decide date format. When user's
  language and language in locale of the user does not match the
  date parameter may not be converted correctly. This effects
  only the date parameters.
  
   STEPS TO REPRODUCE:
  find an environment that has multiple languages
  log in as English user and ensure the user profile has language
  either blank or EN, locale can be blank or en_CA
  set system properties for setting.displaydate as follows
  setting.DISPLAYDATE = dd/MM/yy
  setting.DISPLAYDATE_FR = yy-MM-dd  (_FR can be a difference
  language if you wish)
  
  go to report administration application and run the report
  usage report. Enter report_usage.rptdesign as the report file
  name, other parms leave blank
  
  you may, or may not get any results this time, depends if the
  report has ever been run on the environment you are using
  
  Now, run it again, with same values as before and you should
  have at least one entry - for the report you ran a minute ago.
  (Now you know there is some data. There will be at least 2
  results the next time you ran it because you have just run it
  twice.)
  
  Run it again
  this time, use the same report file name, but enter a date
  range that at least covers today/ Use the calendar, you should
  see the dates appear in the dd/MM/yy format
  
  submit the report. You should see data.
  
  Now, change the user profile, to
  language = FR (Again, _FR can be your language of choice)
  locale = en_CA  (this is the important part, en_CA is correct)
  log out of maximo, set language to your chosen language and log
  in again - you should now be using your chosen language
  
  run the report usage report again
  report file name the same = report_usage.rptdesign
  enter the same date range you did the last test - this time the
  dates should appear as yy/MM/dd (this is fine, and expected)
  Submit the report
  
  
  RESULTS: no records are selected because the date value is not
  in the expected format
  EXPECTED RESULTS: should utilize the correct date as entered on
  the request page
  
  PRODUCT VERSION:  7.6.06
  

Local fix

• don't use the EN locale when using non English language
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Reporting users in a multi-language environment              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the user's display language does not match that user's  *
  * locale's display language, reporting dates may not be        *
  * formatted correctly.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is included in the following package:
                           | Release 7.6.1.1 of Base Services.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BIRT INTEG-SYST

• Fixed component ID

  5724R46B2

Applicable component levels