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 number
JR53532
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-06-05
Closed date
2015-10-19
Last modified date
2015-10-19
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
11 December 2021