Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020567Openbravo ERP08. Project and service managementpublic2012-05-21 18:262012-05-31 12:04
Reporterjonalegriaesarte 
Assigned Tojonalegriaesarte 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP12Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket15530
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020567: 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
related to design defect 0022314 new Triage Omni OMS In some windows the Organization can be changed and this change is not propagated to all its child records 
blocks backport 00208802.50MP44 closed jonalegriaesarte The organization in project phase and project task should change if the header org changes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-21 18:26jonalegriaesarteNew Issue
2012-05-21 18:26jonalegriaesarteAssigned To => jonalegriaesarte
2012-05-21 18:26jonalegriaesarteModules => Core
2012-05-21 18:26jonalegriaesarteOBNetwork customer => Yes
2012-05-21 18:26jonalegriaesarteSupport ticket => 15530
2012-05-23 18:09jonalegriaesarteStatusnew => scheduled
2012-05-23 18:09jonalegriaesartefix_in_branch => pi
2012-05-23 18:10jonalegriaesarteNote Added: 0048892
2012-05-23 18:10jonalegriaesarteStatusscheduled => resolved
2012-05-23 18:10jonalegriaesarteFixed in SCM revision => 12897abf99f7
2012-05-23 18:10jonalegriaesarteResolutionopen => fixed
2012-05-23 18:13jonalegriaesarteNote Added: 0048896
2012-05-23 18:13jonalegriaesartefix_in_branchpi =>
2012-05-31 12:04ioritzCiaNote Added: 0049533
2012-05-31 12:04ioritzCiaStatusresolved => closed
2012-07-03 12:26jonalegriaesarteRelationship addedblocks 0020880
2014-02-05 13:40ngarciaRelationship addedrelated to 0022314

Notes
(0048892)
jonalegriaesarte   
2012-05-23 18:10   
Solved in changeset: https://code.openbravo.com/erp/devel/pi/rev/12897abf99f7 [^]
(0048896)
jonalegriaesarte   
2012-05-23 18:13   
Check that the organization of tasks and phases, change when the organization changes.
- Create a new header.
- Create lines.
- Change the organization header. The lines changes.
- Create a new line with other organization.
- Change the header (not the org). The organization of lines does not change.

Same steps to tasks.
(0049533)
ioritzCia   
2012-05-31 12:04   
Verified, works correctly.