Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021601Openbravo ERP08. Project and service managementpublic2012-09-11 10:242012-09-26 17:19
Reporternaiaramartinez 
Assigned Tonaiaramartinez 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021601: In service project window, can't change the project status (Oracle database)
DescriptionWhen you are in service project window, you can't change the project status.
Steps To ReproduceGo to Service project window and create a record.
Create one line.
Press button 'Change project status' to order. Notice that you get the following error: 'The project has no phases'
Proposed SolutionChange the following validation:
    IF Cur_SO.PROJECTCATEGORY<>'S' THEN
to the following one:
    IF (Cur_SO.PROJECTCATEGORY is null OR Cur_SO.PROJECTCATEGORY<>'S') THEN
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-11 10:24naiaramartinezNew Issue
2012-09-11 10:24naiaramartinezAssigned To => naiaramartinez
2012-09-11 10:24naiaramartinezModules => Core
2012-09-11 10:26naiaramartinezSummaryIn service project window, can't change the project status => In service project window, can't change the project status (Oracle database)
2012-09-11 17:51naiaramartinezStatusnew => scheduled
2012-09-11 17:51naiaramartinezfix_in_branch => pi
2012-09-11 17:56naiaramartinezNote Added: 0052002
2012-09-12 10:49naiaramartinezfix_in_branchpi =>
2012-09-12 10:49naiaramartinezSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3829#r3829
2012-09-12 10:50naiaramartinezNote Edited: 0052002bug_revision_view_page.php?bugnote_id=0052002#r3831
2012-09-13 18:25hgbotCheckin
2012-09-13 18:25hgbotNote Added: 0052087
2012-09-13 18:25hgbotStatusscheduled => resolved
2012-09-13 18:25hgbotResolutionopen => fixed
2012-09-13 18:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/113cc988cb72ff56a22187c4480bfb15252fd20c [^]
2012-09-13 18:25dmiguelezClosed by => dmiguelez
2012-09-13 18:25dmiguelezNote Added: 0052088
2012-09-13 18:25dmiguelezStatusresolved => closed
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052750

Notes
(0052002)
naiaramartinez   
2012-09-11 17:56   
(edited on: 2012-09-12 10:50)
Test PLan (database oracle):
  Go to Service project window and create a record.
  Create one line.
  Press button 'Change project status' to order. Notice that the status is changed correctly.
(0052087)
hgbot   
2012-09-13 18:25   
Repository: erp/devel/pi
Changeset: 113cc988cb72ff56a22187c4480bfb15252fd20c
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Sep 10 17:55:14 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/113cc988cb72ff56a22187c4480bfb15252fd20c [^]

fixed bug 21601 Change validation with null values in order to work in oracle

---
M src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
---
(0052088)
dmiguelez   
2012-09-13 18:25   
Code Review + Testing OK
(0052750)
hudsonbot   
2012-09-26 17:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test