JR52305: After enabling Feature Pack 7, promotion codes cannot be removed from an order

APAR status

• Closed as program error.

Error description

• After upgrading to Feature Pack 7, a shopper cannot remove
  promotion codes from their order.
  

Local fix

• Manually update the PX_CDPOOL database table to fill in the new
  columns REFERENCE_ID, INTERNAL_ID, WORKGROUP, TASKGROUP) added
  in the schema change for promotion codes that were created prior
   to enabling Feature Pack 6 or later.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7 who have upgraded to Feature Pack
   6 or later and use promotion codes
  
  PROBLEM ABSTRACT:
  After enabling Feature Pack 7, promotion codes cannot be removed
   from an order
  
  BUSINESS IMPACT:
  Shoppers are unable to remove promotion codes from their orders.
  
  RECOMMENDATION:
  

Problem conclusion

• The root cause of this issue is the schema changes for columns
  in the PX_CDPOOL table, introduced in the Feature Pack 6 APAR
  JR52302. The schema changes added new columns to the PX_CDPOOL
  database table. These new columns are not populated for
  promotion code entries that were created prior to enabling
  Feature Pack 6 or later.
  
  Added a check to fall back to the original Feature Pack 1 to 5
  query that is used to update PX_CDUSAGE in the case that a
  promotion code does not have the new columns filled out.
  

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