SE48270: CMVC 211628 - ASSIGN THE OWNERSHIP OF A CONTRACT ATTACHMENT TO AN ORGENTITY RATHER THAN A USER.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
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

• In Accelerator (for B2B store), when creating a new Contract (or
  editing an existing one) for an account, there is an
  'Attachment' tab that allows references to an external document
  for the contract details. Populating this field will insert a
  record in the ATTACHMENT table. However , the record is created
  with ATTACHMENT.MEMBER_ID set to the USER_ID of the user who is
  logged into Accelerator, rather than an organization id or
  store_id.  This problem could surface when running stagingprop
  utility, if the ATTACHMENT was first created on the staging
  server. Stagingprop may fail because the MEMBER_ID (user) does
  not necessarily exist on production database.
  

Local fix

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce users on v6.0 or v7.0 who create
  contracts and add an attachment to the contract record.
  
  PROBLEM ABSTRACT:
  This fix is to assign the ownership of a contract attachment to
  an ORGENTITY rather than a USER.
  
  BUSINESS IMPACT:
  This behaviour can cause stagingprop utility to fail, as the
  ATTACHMENT record is owned by a user rather than an
  organization, but user data is not propagated by stagingprop.
  This can cause a foreign key violation, and lead to failed
  propagation.
  
  RECOMMENDATION:
  

Problem conclusion

• The ATTACHMENT record created by the attachment section of the
  contract creation will now be owned by the organization who owns
  the store in which the contract was created, rather than by the
  user who created the contract.
  -------------------------------------------------------------
  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 EDIT AS4

• Fixed component ID

  5724I3803

Applicable component levels

• R600 PSY

     UP