0034465: Initialize.bp.segmentation.tables does not take into account BPartners of gift card instances

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0034465

Retail Modules

StoreServer

public

2016-11-10 16:51

2017-06-07 00:40

Reporter

ioritzCia

Assigned To

AugustoMauch

Priority

normal

Severity

major

Reproducibility

sometimes

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 14.04

Product Version

Target Version

Fixed in Version

RR17Q3

Merge Request Status

Review Assigned To

mtaal

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0034465: Initialize.bp.segmentation.tables does not take into account BPartners of gift card instances

Description

Regarding: http://wiki.openbravo.com/wiki/Projects:Store_Server_BP_Data_Segmentation [^]

You might have Business Partners you want to export to a store that do not have an order but they have a gift card

To check if more entities require this

Steps To Reproduce

- Create a new Business Partner
- Create a Gift Card for a store and assign previous Business Partner
- Validate previous store

More precise steps can be detailed if required

Proposed Solution

Add the following insert query into the InitializeBusinessPartnerSegmentationTables.java process

insert into obstsyn_server_bpartner(obstsyn_server_bpartner_id, ad_client_id, ad_org_id, isactive,
                                   createdby, updatedby, obmobc_server_definition_id, c_bpartner_id)
select get_uuid(), min(gc.ad_client_id), min(gc.ad_org_id), 'Y',
       '100', '100', so.obmobc_server_definition_id, gc.c_bpartner_id
from gcnv_giftcard_inst gc
  inner join obmobc_server_orgs so on (gc.ad_org_id = so.server_org_id)
  left join obstsyn_server_bpartner sbp on (sbp.c_bpartner_id = gc.c_bpartner_id)
where sbp.c_bpartner_id is null
group by gc.c_bpartner_id, so.obmobc_server_definition_id;

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0033727		new	AugustoMauch	Improve the initialization of the tables related with business partner segmentation
related to	defect	0035645		closed	AugustoMauch	Prevent invoking a commitAndClose inside an event handler