JR58889: Cannot submit order with a shared public promotion code

APAR status

• Closed as program error.

Error description

• The problem only occurs under a specific configuration:
  
  1. Use FinalizeDiscountCalculationUsageNoPromoargCmdImpl
  https://www.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm
  .commerce.admin.doc/tasks/tprconfigpromoargument.htm
  
  2. Set TrackPublicPromotionCodeUsage to true
  https://www.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.ibm
  .commerce.management-center_customization.doc/concepts/cprwcadmi
  ncom.htm#fntarg_1
  
  3. Have multiple promotions that share the same code.
  
  4. Some of these promotions in 'active' status, others in
  'inactive', 'archived' or other status.
  
  5. Apply the promotion code and order process would throw the
  error:
  
  Caused by: java.sql.SQLException: ORA-01427: single-row subquery
   returns more than one row
  
  	at
  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  	...
  	at
  com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean.execute
  ParameterizedQuery(ServerJDBCHelperAccessBean.java:310)
  	at
  com.ibm.commerce.order.calculation.FinalizeDiscountCalculationUs
  ageNoPromoargCmdImpl.handlePromotionCodes(FinalizeDiscountCalcul
  ationUsageNoPromoargCmdImpl.java:458)
  	at
  com.ibm.commerce.order.calculation.FinalizeDiscountCalculationUs
  ageNoPromoargCmdImpl.performExecute(FinalizeDiscountCalculationU
  sageNoPromoargCmdImpl.java:138)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 8 Mod Pack 4.
  
  PROBLEM ABSTRACT:
  Cannot submit order with a shared public promotion code
  
  BUSINESS IMPACT:
  Shopper cannot use the promotion code.
  
  RECOMMENDATION:
  

Problem conclusion

• Enhance the sql to filter out the promotion codes with
  promotions disabled.
  

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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R800 PSY

     UP