APAR status
Closed as program error.
Error description
The SQL in wc-dataimport-preprocess-offerprice.xml does not account the OFFER.PUBLISHED column, and as a result you end up having prices in the index which are not published (i.e. OFFER.PUBLISHED <> 1).
Local fix
Problem summary
USERS AFFECTED: FEP6, FEP7,FEP8 PROBLEM ABSTRACT: Preprocess does not filter offer price by OFFER.PUBLISHED column BUSINESS IMPACT: When there are multiple offers with same precedence and different published status, the old script may choose the unpublished offer, which cause error. RECOMMENDATION:
Problem conclusion
To only select the published offer
Temporary fix
Comments
APAR Information
APAR number
JR53944
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-07-27
Closed date
2015-09-03
Last modified date
2015-09-03
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