JR53532: Unique promotion codes can be redeemed multiple times using diff erent orders.

APAR status

• Closed as program error.

Error description

• After installing APAR JR45153, when a unique promotion code
  created using feature pack 5 or prior is applied to an order,
  the same code can be redeemed in different orders.
  
  When a unique promotion code is applied to an order, the code is
   associated with the current order and owner in the PX_CDUSAGE
  table. When the same promotion code is applied to a different
  order, the ownership of the PX_CDUSAGE entry is changed to
  reflect the latest order and ownership information. When the
  previous order is submitted, no PX_CDUSAGE entries are found
  that are associated with the previous order, which in turn
  prevents the unique promotion code from properly marked as
  redeemed.
  

Local fix

• Manually populate the columns REFERENCE_ID, INTERNAL_ID,
  WORKSPACE, and TASKGROUP for those promotion code entries that
  are created prior to the schema change in PX_CDPOOL table.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce V7 business users who have created and
  activated promotions with unique codes using feature pack 5 or
  prior and have installed APAR JR45153.
  
  PROBLEM ABSTRACT:
  Unique promotion codes can be redeemed multiple times using
  different orders.
  
  BUSINESS IMPACT:
  Unique promotion codes that are created using feature pack 5 or
  prior can be redeemed multiple times using different orders
  which defeats the purpose of the uniqueness of the code.
  
  RECOMMENDATION:
  

Problem conclusion

• The code fix is to ensure all unique promotion codes that have
  been already applied on submitted orders are marked as redeemed
  in PX_CDUSAGE table.
  
  When using promotion arguments, the engine will try to find
  PX_CDUSAGE entries using promotion code and WORKSPACE column in
  the PX_CDPOOL. If it cannot find any entries, it will fall back
  to a query that can retrieve the PX_CDUSAGE entries without
  using the WORKSPACE column in PX_CDPOOL.
  
  When NOT using promotion arguments, the code is fixed to
  retrieve applied promotion code's PX_CDUSAGE entries. This query
   is based on the PX_CDPOOL_ID of the codes that were applied to
  the order. The old method was to use ORDERS_ID on the PX_CDUSAGE
   table, but it will no longer be used since the orders_id may
  change for the unique promotion code if the promotion code is
  applied to a different order.
  

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