JR50524: Price calculation fails on a pre-defined configuration when the price mode is 0 (Oracle database)

APAR status

• Closed as program error.

Error description

• When using an Oracle database and displaying the price of a
  pre-defined configuration of a dynamic kit with the price mode
  set to '0', a price is not returned.
  
   Procedure to reproduce this problem:
   1. Set the price mode to 0.
   2. Create a pre-defined configuration for a dynamic kit in
  Management Center.
   3. Browse to a category page to display the dynamic kit and its
  price.
  
   Observed Results:
   The price of the pre-defined configuration of the dynamic kit
  is "price pending".
  
   Expected Results:
   The actual price of the pre-defined configuration of the
  dynamic kit should be shown.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 using the Sterling
  Configurator Integration with an Oracle database.
  
   PROBLEM ABSTRACT:
   Price calculation fails on a pre-defined configuration when the
  price mode is 0 (Oracle database)
  
   BUSINESS IMPACT:
   Users leveraging the Sterling Configurator Integration cannot
  sell pre-defined configurations when the price mode is set to 0.
  
   RECOMMENDATION:
  

Problem conclusion

• With this fix, the syntax of an Oracle SQL statement is fixed:
  
   Changed from:
   SELECT CONF.DKPREDEFCONF_ID, INF.CONFIGURATION FROM
  DKPDCCATENTREL as REL, DKPREDEFCONF as CONF, CATCONFINF as INF
  WHERE REL.CATENTRY_ID =? and INF.CATENTRY_ID=REL.CATENTRY_ID and
  REL.DKPREDEFCONF_ID=CONF.DKPREDEFCONF_ID and CONF.COMPLETE = 1
  
   To:
   SELECT CONF.DKPREDEFCONF_ID, INF.CONFIGURATION FROM
  DKPDCCATENTREL REL, DKPREDEFCONF CONF, CATCONFINF INF WHERE
  REL.CATENTRY_ID =? and INF.CATENTRY_ID=REL.CATENTRY_ID and
  REL.DKPREDEFCONF_ID=CONF.DKPREDEFCONF_ID and CONF.COMPLETE = 1
  
  
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP