Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049744POS2POSpublic2022-07-06 14:212022-07-08 13:57
Reportermigueldejuana 
Assigned Tomigueldejuana 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049744: Fix few issues caused by Product Price with Exceptions project
Description- We cannot login in POS using Oracle because some queries are doinf left join to pppe when it is not needed.

- We have a reference in ProductPriceProperties.java and in LoadedProduct.java but it is not present in the query
Steps To Reproducen/a
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0049556 closed yogaskarnik Retail Modules Product Prices with Exceptions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-07-06 14:21migueldejuanaNew Issue
2022-07-06 14:21migueldejuanaAssigned To => migueldejuana
2022-07-06 14:21migueldejuanaOBNetwork customer => No
2022-07-06 14:21migueldejuanaTriggers an Emergency Pack => No
2022-07-06 14:46hgbotMerge Request Status => open
2022-07-06 14:46hgbotNote Added: 0139127
2022-07-07 09:32hgbotNote Added: 0139145
2022-07-08 07:47hgbotNote Added: 0139172
2022-07-08 13:37hgbotMerge Request Statusopen => approved
2022-07-08 13:57hgbotResolutionopen => fixed
2022-07-08 13:57hgbotStatusnew => closed
2022-07-08 13:57hgbotNote Added: 0139199
2022-07-08 13:57hgbotFixed in Version => RR22Q4
2022-07-08 13:57hgbotNote Added: 0139200
2022-07-08 13:57hgbotNote Added: 0139201
2022-07-08 13:57hgbotNote Added: 0139202
2022-07-08 13:57hgbotNote Added: 0139203
2022-07-08 13:57hgbotNote Added: 0139204
2023-09-06 10:09guillermogilRelationship addedrelated to 0049556

Notes
(0139127)
hgbot   
2022-07-06 14:46   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/849 [^]
(0139145)
hgbot   
2022-07-07 09:32   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/20 [^]
(0139172)
hgbot   
2022-07-08 07:47   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.productcost/-/merge_requests/4 [^]
(0139199)
hgbot   
2022-07-08 13:57   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/849 [^]
(0139200)
hgbot   
2022-07-08 13:57   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: be1eb7c320cc83fbc5c752e028e764342e00193f
Author: Miguel de Juana <miguel.dejuana@openbravo.com>
Date: 08-07-2022 11:57:29
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/be1eb7c320cc83fbc5c752e028e764342e00193f [^]

Fixed ISSUE-49744: Fix few issues caused by Product Price with Exceptions project

---
M src/org/openbravo/retail/posterminal/master/CrossStoreFilter.java
M src/org/openbravo/retail/posterminal/master/LoadedProduct.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/master/ProductPrice.java
M src/org/openbravo/retail/posterminal/master/ProductPriceProperties.java
M src/org/openbravo/retail/posterminal/master/ProductServiceLinked.java
M src/org/openbravo/retail/posterminal/master/ProductStock.java
---
(0139201)
hgbot   
2022-07-08 13:57   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom [^]
Changeset: 7f5b4b7fb83a8b4f2f12a35effef2fc611f33738
Author: Miguel de Juana <miguel.dejuana@openbravo.com>
Date: 08-07-2022 11:57:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/commit/7f5b4b7fb83a8b4f2f12a35effef2fc611f33738 [^]

Related ISSUE-49744: Use simplified method to avoid unneded join

---
M src/org/openbravo/retail/autobom/master/BillofMaterialsProduct.java
M src/org/openbravo/retail/autobom/master/ProductBOMVersion.java
---
(0139202)
hgbot   
2022-07-08 13:57   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/20 [^]
(0139203)
hgbot   
2022-07-08 13:57   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.productcost [^]
Changeset: fec613ad3ab9978d8014599bd45f9eeba81a6bba
Author: miguel.dejuana <miguel.dejuana@openbravo.com>
Date: 08-07-2022 07:46:13
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.productcost/-/commit/fec613ad3ab9978d8014599bd45f9eeba81a6bba [^]

Related ISSUE-49744: Use simplified method to avoid unneded join

---
M src/org/openbravo/retail/productcost/StockValuationValues.java
---
(0139204)
hgbot   
2022-07-08 13:57   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.productcost/-/merge_requests/4 [^]