JR47127: CMVC 229006 - When uploading inventory data, the ITEMSPC_ID is not always resolved against the catentry.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When uploading Receipt data and not using the catentry_id
  associated with the ITEMSPC records, some ITEMSPC records may
  appear to be missing.  This is due to the fact that the
  PARTNUMBER column in ITEMSPC may be out of sync with the
  PARTNUMBER in CATENTRY.
  

Local fix

• Update the ITEMSPC.PARTNUMBER column to match the
  CATENTRY.PARTNUMBER for catentries that have an ITEMSPC_ID value
   specified.
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users uploading inventory data using the
  partnumber instead of the catentry_id
  
   PROBLEM ABSTRACT:
   When uploading inventory data, the ITEMSPC_ID is not always
  resolved against the catentry.
  
   BUSINESS IMPACT:
   Users will be unable to update inventory information.
  
   RECOMMENDATION:
   Update the ITEMSPC.PARTNUMBER column to match the
  CATENTRY.PARTNUMBER for catentries that have an ITEMSPC_ID value
  specified.
  

Problem conclusion

• This fix forces the mediator to always resolve ITEMSPC_ID
  against the catentry table.
   -------------------------------------------------------------
   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