0055222: Price API - importing price for deactivated product

Description

When importing a price for a deativated product we get the error :
ERROR: duplicate key value violates unique constraint "m_productprice_pricelist_ve_un"

Steps To Reproduce

deactivate a product
import a price for this product with the API

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0163352) adrianromero (manager) 2024-04-18 10:37	This is the expected behaviour when trying to import any Openbravo entity with the same keys as another existing deactivated entity. Deactivated entities are maintanined in the database for reference and reporting purposes but cannot be used in new processes or selected, etc... and as consequence: * Deactivated records cannot be updated by the import API and kept deactivated * Deactivated records cannot be reactivated and updated as a result of an import API request * Openbravo cannot create a new activated record due the database constraints that can end in an inconsistent database with two records with the same keys, one activated and the other deactivated.

Issue History
Date Modified	Username	Field	Change
2024-04-17 14:30	azzeddine_meftoh	New Issue
2024-04-17 14:30	azzeddine_meftoh	Assigned To	=> Triage Platform Conn
2024-04-17 14:30	azzeddine_meftoh	Triggers an Emergency Pack	=> No
2024-04-17 14:49	victor_perez	Severity	minor => major
2024-04-18 10:29	jorgewederago	Assigned To	Triage Platform Conn => Retail
2024-04-18 10:29	jorgewederago	Status	new => acknowledged
2024-04-18 10:37	adrianromero	Note Added: 0163352
2024-04-18 10:37	adrianromero	Status	acknowledged => closed
2024-04-18 10:37	adrianromero	Resolution	open => no change required