Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002831Openbravo ERP09. Financial managementpublic2008-04-08 21:012008-11-06 11:23
Reporterroklenardic 
Assigned ToHennadzi 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.40Fixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002831: M_PRODUCT_ACCT unique constraint
DescriptionTo enter accounting for several schemas of the Business Partner Customer accounting, there is a unique constraint on
C_BP_CUSTOMER_ACCT: the C_BPARTNER_ID+AD_ORG_ID+STATUS+C_ACCT_SCHEMA combination must be unique.

I believe there is a similar unique constraint missing on M_PRODUCT_ACCT.
This constraint should make the following combination unique: M_PRODUCT_ID+AD_ORG_ID+C_ACCT_SCHEMA

OB trunk rev 3118
Oracle XE10g
firefox 3b5
java 1.5
ubuntu 8.04b
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-13 17:07HennadziResolutionopen => fixed
2008-06-13 17:07HennadziFixed in Version => trunk
2008-06-13 17:07Hennadzisvn_revision => 5038
2008-06-13 17:07HennadziDescription Updated
2008-06-13 18:01cromeroStatusnew => scheduled
2008-06-13 19:59cromeroTarget Version => 2.40
2008-06-17 10:28PavelPonomarevStatusscheduled => resolved
2008-06-17 10:28PavelPonomarevResolutionopen => fixed
2008-06-17 10:28PavelPonomarevsvn_revision5038 => 5040
2008-11-06 11:23psarobeRegression testing => No
2008-11-06 11:23psarobeStatusresolved => closed

Notes
(0006420)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1938048 [^]
(0003487)
cromero   
2008-04-18 17:28   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

Fixed in the trunk in revision 3586
(0003488)
psarobe   
2008-06-09 20:54   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500703
Originator: NO

we should remove this constraint and also the one for business partner
(0003489)
cromero   
2008-06-10 11:49   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

Unique constraint m_prod_acct_prod_org_sche_uni (M_PRODUCT_ID+AD_ORG_ID+C_ACCT_SCHEMA) is not necessary since exist a primary key M_PRODUCT_ID+C_ACCT_SCHEMA, so it should be removed

In the Unique constraint bpcustacc_schema_org_bp_st_uni (C_BPARTNER_ID+AD_ORG_ID+STATUS+C_ACCT_SCHEMA), AD_ORG_ID field should be removed since is not implemented yet.