Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0054613 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Retail API | major | always | 2024-02-07 16:31 | 2024-04-23 10:50 | |||
Reporter | dorian_robillard | View Status | public | |||||
Assigned To | Rajesh_18 | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0054613: In the POST assortment API, it is not possible to update the new object requisitionDefaults | |||||||
Description | In the POST assortment API, it is not possible to update the new object requisitionDefaults Here a json used to import. { "client": "CLIENT", "organization": "*", "name": "ASS France", "description": "ASS France", "active": true, "products": [ { "product": "182496", "bestseller": false, "active": true, "requisitionDefaults": [ { "organization": "*", "active": true, "defaultAction": "PO", "businessPartner": "V/001", "priceList": "LISTE DE PRIX D'ACHAT", "minQuantity": 5, "standardQuantity": 15, "quantityType": "Multiple" } ] } ] } If I import it a second time changin standardQuantity, I have this error in EDL request : ERROR: duplicate key value violates unique constraint "obdo_prol_product_unique" Detail: Key (obretco_prol_product_id, ad_org_id)=(8F576B1A76E241F399B47A370EEA1CDB, 0) already exists. | |||||||
Steps To Reproduce | Use POST API assortment with requisitionDefaults Change standardQuantity in JSON Use again POST API assortment with requisitionDefaults | |||||||
Proposed Solution | Key Key (obretco_prol_product_id, ad_org_id) should not be a unicity contrainst for API but allow to update requisitionDefault. Maybe add organisation in the key | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0163085) hgbot (developer) 2024-04-11 09:55 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/30 [^] |
(0163294) hgbot (developer) 2024-04-16 16:08 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^] Changeset: 203a8c6c188b052ed9c86e2421901a79add33395 Author: Rajesh Senthilkumar <rajesh@qualiantech.com> Date: 16-04-2024 14:08:07 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/203a8c6c188b052ed9c86e2421901a79add33395 [^] Fixed ISSUE-54613: Added identifier for requisition defaults in assortment api --- M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml --- |
(0163295) hgbot (developer) 2024-04-16 16:08 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/30 [^] |
(0163579) AgatheBertin (developer) 2024-04-23 09:56 |
Hello We still have the database constraint, failing in the EDL ERROR: duplicate key value violates unique constraint "obdo_prol_product_unique" Detail: Key (obretco_prol_product_id, ad_org_id)=(5DA0A48749F8434F945F7AE3D513959B, 0) already exists. |
Issue History | |||
Date Modified | Username | Field | Change |
2024-02-07 16:31 | dorian_robillard | New Issue | |
2024-02-07 16:31 | dorian_robillard | Assigned To | => Triage Platform Conn |
2024-02-07 16:31 | dorian_robillard | Triggers an Emergency Pack | => No |
2024-03-01 13:54 | adrianromero | Assigned To | Triage Platform Conn => Retail |
2024-04-08 07:15 | marvintm | Type | design defect => defect |
2024-04-08 09:44 | jorgewederago | Status | new => acknowledged |
2024-04-10 11:42 | Rajesh_18 | Assigned To | Retail => Rajesh_18 |
2024-04-10 11:42 | Rajesh_18 | Status | acknowledged => scheduled |
2024-04-11 09:55 | hgbot | Note Added: 0163085 | |
2024-04-16 16:08 | hgbot | Resolution | open => fixed |
2024-04-16 16:08 | hgbot | Status | scheduled => closed |
2024-04-16 16:08 | hgbot | Note Added: 0163294 | |
2024-04-16 16:08 | hgbot | Note Added: 0163295 | |
2024-04-23 09:56 | AgatheBertin | Note Added: 0163579 | |
2024-04-23 09:56 | AgatheBertin | Status | closed => new |
2024-04-23 09:56 | AgatheBertin | Resolution | fixed => open |
2024-04-23 10:50 | Rajesh_18 | Status | new => scheduled |
2024-04-23 10:50 | Rajesh_18 | Status | scheduled => resolved |
2024-04-23 10:50 | Rajesh_18 | Resolution | open => fixed |
2024-04-23 10:50 | Rajesh_18 | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |