Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049882ModulesFrench Eco Tax Managementpublic2022-07-27 10:222022-07-28 12:31
Reportergorkaion 
Assigned Toigor_trebol 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0049882: Unique index PHIECO_TAXCATEGORY_NAME is missing ad_client_id
DescriptionThe table PHIECO_TAXCATEGORY has the following unique index PHIECO_TAXCATEGORY_NAME

      <unique name="PHIECO_TAXCATEGORY_NAME">
        <unique-column name="NAME"/>
        <unique-column name="AD_ORG_ID"/>
      </unique>


The index should include the ad_client_id column as well to allow having the same name in different clients when the taxcategory is stored in * organization.
Steps To ReproduceOn a instance with 2 clients try to create a taxcategory in both clients using * organization and the same name.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff fix-49882.diff (678) 2022-07-27 12:07
https://issues.openbravo.com/file_download.php?file_id=17340&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-07-27 10:22gorkaionNew Issue
2022-07-27 10:22gorkaionAssigned To => Triage Omni OMS
2022-07-27 10:31aferrazAssigned ToTriage Omni OMS => igor_trebol
2022-07-27 12:07gorkaionFile Added: fix-49882.diff
2022-07-28 09:01hgbotNote Added: 0139658
2022-07-28 12:31hgbotResolutionopen => fixed
2022-07-28 12:31hgbotStatusnew => closed
2022-07-28 12:31hgbotNote Added: 0139666
2022-07-28 12:31hgbotNote Added: 0139667

Notes
(0139658)
hgbot   
2022-07-28 09:01   
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/merge_requests/4 [^]
(0139666)
hgbot   
2022-07-28 12:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax [^]
Changeset: 43e645d6d8196b0a25d33d6a1dd98ce1faf8fe5b
Author: Igor Trebol <igor.trebol@openbravo.com>
Date: 28-07-2022 10:31:54
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/commit/43e645d6d8196b0a25d33d6a1dd98ce1faf8fe5b [^]

Fixes ISSUE-49882: Applied patch to improve PHIECO_TAXCATEGORY_NAME index

---
M src-db/database/model/tables/PHIECO_TAXCATEGORY.xml
---
(0139667)
hgbot   
2022-07-28 12:31   
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.france.ecotax/-/merge_requests/4 [^]