IJ40324: INVENTORY_ABC_TRANSACTION REPORT PRODUCES INCORRECT RESULTS WHEN THE DATABASE LOCALE IS CANADIAN FRENCH.

APAR status

• Closed as program error.

Error description

• With a database with the locale set to Canadian French, run the
  Inventory_ABC_Transaction report (and/or the
  Inventory_ABC_Transaction_Update report).
  A,B&C breakpoints enterews as .30, .30, .40 will be read as ,300
  , ,300 & ,400. This will cause the report to produce skewed
  results.
  
  
  The solution to this is to strip out the commas at run time.
  
  
  There are a couple SQL statements like this in the two
  reports.
  
  
  select a_abcafter, b_abcafter, c_abcafter from
   (select sum(cast((a_abcafter) as float)) as a_abcafter from (
  select(replace(maxvars.varvalue,',','.')) as a_abcafter from
  maxvars where maxvars.varname in ('A_BREAKPOINT') and
  maxvars.orgid = 'SFPPN' ) as a) atable,
   (select sum(cast((b_abcafter) as float)) as b_abcafter from (
  select(replace(maxvars.varvalue,',','.')) as b_abcafter from
  maxvars where maxvars.varname in ('A_BREAKPOINT',
  'B_BREAKPOINT') and maxvars.orgid = 'SFPPN' ) as b) btable,
   (select sum(cast((c_abcafter) as float)) as c_abcafter from (
  select(replace(maxvars.varvalue,',','.')) as c_abcafter from
  maxvars where maxvars.varname in ('A_BREAKPOINT',
  'B_BREAKPOINT', 'C_BREAKPOINT') and maxvars.orgid = 'SFPPN' ) as
  c) ctable;
  
  
  ENVIRONMENT: -
  PRODUCT VERSION:
  
  
  Maximo 7.6.1.2
  
  AFFECTED APPLICATION : Inventory ABC Reports
  Tivoli's process automation engine 7.6.1.2-IFIX20220330-1115
  Build 20200715-0100 DB Build V7612-284 HFDB Build HF7612-80
  

Local fix

Problem summary

Problem conclusion

• A fix for this APAR will be included in a future release.
  

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

  MAXIMO REPORTIN

• Fixed component ID

  TIVOREPTS

Applicable component levels