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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    JR43987

  • 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

    2012-09-06

  • Closed date

    2012-10-27

  • Last modified date

    2012-10-27

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Reference #:

JR43987

Modified date:

2012-10-27

Translate my page

Machine Translation

Content navigation