JR43987: CMVC 224278 - RECOGNIZE THE ADDITIONAL ORDER STATES WHEN PROCESSING AN PURCHASE HISTORY MARKETING CONDITION

APAR status

• Closed as program error.

Error description

• The Purchase History marketing condition looks at orders based
  on the following state:
  
  ORDERS.TYPE = ('ORD') and ORDERS.STATUS in
  ('B','M','R','I','C','S','D') and ORDERITEMS.STATUS not in
  ('P','X','I','J','Q')
  
  This does not cover all orders that should be part of the order
  history.  The correct condition should be:
  
  ORDERS.TYPE = ('ORD') and ORDERS.STATUS in
  ('B','M','R','I','C','S','D','G','F','H') and ORDERITEMS.STATUS
  not in ('P','X','I','J','Q')
  
  Order states 'G', 'F', and 'H' are missing.  These relate to
  orders that are being processed by remote fulfillment.
  
  The list of order states can be found in the Info Center:
  http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com
  .ibm.commerce.user.doc/concepts/cossostat.htm
  

Local fix

Problem summary

• USERS AFFECTED:
  Systems which process orders using remove fulfillment and where
  orders are in the states 'G', 'F', or 'H', which need to be
  calculated for a Management Center Marketing Purchase History
  target
  
  PROBLEM ABSTRACT:
  Marketing Activities that use a Purchase History target may
  sometimes be evaluated incorrectly as the Purchase History
  target does not account for order states that relate to remote
  fulfillment.
  
  BUSINESS IMPACT:
  The issue may prevent marketing from calculating a correct
  result when a Purchase History condition is required and where
  remote fulfillment is used.
  
  RECOMMENDATION:
  This issue has been resolved in WebSphere Commerce Fixpack 6 and
  above (7.0.0.6)
  

Problem conclusion

• The SQL query that looks up the orders relevant to the Purchase
  History has been updated to include the missing states 'G', 'F',
  and 'H'.
  -------------------------------------------------------------
  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