Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014849Openbravo ERP09. Financial managementpublic2010-10-11 11:202010-12-21 00:00
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target Version2.40MP13Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014849: Error when modifying element value which is referenced from more than one accounting combination, in Oracle
DescriptionError when modifying element value which is referenced from more than one accounting combination, in Oracle
Steps To Reproduce1. Financial Management || Accounting || Setup || Account Combination || Combination : create record with details
Alias=%
Organization=B
Account=435
2. Navigate to Account 435 and try to modify it, for example, dis-active it.
You will obtain the following error message:
      
The search gives back more than one row.You may check the data

Error is given by C_ELEMENTVALUE_TRG because when trying to execute this clause:

SELECT name INTO v_orgName FROM ad_org WHERE ad_org_id in (SELECT ad_org_id FROM c_validcombination WHERE account_id=:new.C_ElementValue_ID);

when it returns more than one organization.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00149542.40MP13 closed adrianromero Error when modifying element value which is referenced from more than one accounting combination, in Oracle 
related to backport 00151302.50MP26 closed dalsasua Bad behaviour in the Account Tree || Element >> Element Value if you change data in the Account Combination 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-11 11:20networkbNew Issue
2010-10-11 11:20networkbAssigned To => dalsasua
2010-10-11 11:20networkbOBNetwork customer => Yes
2010-10-21 12:25adrianromeroIssue cloned0014954
2010-10-21 12:25adrianromeroRelationship addedblocks 0014954
2010-10-21 12:25adrianromeroRelationship replaceddepends on 0014954
2010-10-21 12:26adrianromeroAssigned Todalsasua => adrianromero
2010-11-10 09:37hgbotCheckin
2010-11-10 09:37hgbotNote Added: 0032527
2010-11-10 09:37hgbotStatusnew => resolved
2010-11-10 09:37hgbotResolutionopen => fixed
2010-11-10 09:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f339093e1da96cfcbe4307c35e9ae6e5c7838d29 [^]
2010-11-10 11:16adrianromeroNote Added: 0032532
2010-11-10 16:55adrianromeroRelationship addedrelated to 0015130
2010-11-10 20:06hudsonbotCheckin
2010-11-10 20:06hudsonbotNote Added: 0032543
2010-12-20 13:07psarobeNote Added: 0033287
2010-12-20 13:07psarobeStatusresolved => closed
2010-12-21 00:00anonymoussf_bug_id0 => 3140990

Notes
(0032527)
hgbot   
2010-11-10 09:37   
Repository: erp/devel/pi
Changeset: f339093e1da96cfcbe4307c35e9ae6e5c7838d29
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Nov 05 09:08:56 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f339093e1da96cfcbe4307c35e9ae6e5c7838d29 [^]

Fixes issue 0014849: Error when modifying element value which is referenced from more than one accounting combination, in Oracle
It has been modified the sentence that updates the C_VALIDCOMBINATION table in the trigger of the table C_ELEMENTVALUE to not to throw a mutating tables error

---
M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
---
(0032532)
adrianromero   
2010-11-10 11:16   
* Testing the issue

** Follow the steps to test and verify that any error is thrown.
** Verify also that it is possible to modify the Element record modifying other fields in the window and that also if only account combination is related to the Element modified.
** Check this issue in both database engines Postgres and Oracle.

* Other areas affected

** It only has been modified the sentence that updates account combinations in trigger of table Element values. So the only windows affected are: Element Values and Account Combinations.
(0032543)
hudsonbot   
2010-11-10 20:06   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f339093e1da9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/9c2b09096a6d [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18851.obx [^]
(0033287)
psarobe   
2010-12-20 13:07   
Due to lack of infrastructure only tested in postgres. Works fine