Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0054613
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail APImajoralways2024-02-07 16:312024-04-23 10:50
Reporterdorian_robillardView Statuspublic 
Assigned ToRajesh_18 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0054613: In the POST assortment API, it is not possible to update the new object requisitionDefaults

DescriptionIn 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 ReproduceUse POST API assortment with requisitionDefaults
Change standardQuantity in JSON
Use again POST API assortment with requisitionDefaults
Proposed SolutionKey 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
TagsNo 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
Powered by Mantis Bugtracker