Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020880Openbravo ERP08. Project and service managementpublic2012-06-27 12:272012-07-10 11:48
Reporterjonalegriaesarte 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP40 
Target Version2.50MP44Fixed 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
Summary0020880: The organization in project phase and project task should change if the header org changes
DescriptionThe organization in project phase and project task should change if the header org changes
Steps To ReproduceThis code:
IF TG_OP = 'UPDATE' THEN
SELECT COUNT(*) INTO v_Count FROM C_PROJECTTASK WHERE C_PROJECTPHASE_ID =
NEW.C_PROJECTPHASE_ID;
IF(v_Count > 0) THEN
UPDATE C_PROJECTTASK
SET AD_ORG_ID = NEW.AD_ORG_ID
WHERE C_PROJECTPHASE_ID = NEW.C_PROJECTPHASE_ID;
END IF;
END IF;

should be executed if the org changes. It is reproducible in c_project_trg and c_projectphase_trg()
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 00205673.0MP12 closed jonalegriaesarte The organization in project phase and project task should change if the header org changes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-27 12:27jonalegriaesarteNew Issue
2012-06-27 12:27jonalegriaesarteAssigned To => jonalegriaesarte
2012-06-27 12:27jonalegriaesarteModules => Core
2012-06-27 12:27jonalegriaesarteOBNetwork customer => Yes
2012-07-03 12:26jonalegriaesarteRelationship addeddepends on 0020567
2012-07-03 12:27hgbotCheckin
2012-07-03 12:27hgbotNote Added: 0050330
2012-07-03 12:27hgbotStatusnew => resolved
2012-07-03 12:27hgbotResolutionopen => fixed
2012-07-03 12:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/c9b5c1ab5b1f9444b8ebc4a358c8702c18d054fd [^]
2012-07-10 11:48ioritzCiaNote Added: 0050436
2012-07-10 11:48ioritzCiaStatusresolved => closed

Notes
(0050330)
hgbot   
2012-07-03 12:27   
Repository: erp/stable/2.50
Changeset: c9b5c1ab5b1f9444b8ebc4a358c8702c18d054fd
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Jul 03 12:26:29 2012 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/c9b5c1ab5b1f9444b8ebc4a358c8702c18d054fd [^]

Fixes issue 0020880: The organization in project phase and project task should
change if the header org changes

---
M src-db/database/model/triggers/C_PROJECTPHASE_TRG.xml
M src-db/database/model/triggers/C_PROJECT_TRG.xml
---
(0050436)
ioritzCia   
2012-07-10 11:48   
Verified