Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010536Openbravo ERP05. Production managementpublic2009-09-09 18:152009-10-06 11:36
Reporteregoitz 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.50MP3 
Target VersionFixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010536: The calculate standard costs process does not work using oracle 10g
DescriptionThe calculate standard costs process does not work using oracle 10g.
Steps To Reproduce-Create a new process plan. completly.
-Execute calculate standard costs process selecting the processplan but withou a budget
-Go to standard costs report
-See that the costs of the P- product are not filled
Proposed Solutionon MA_STANDARD_COST_SEQUENCE
there is a select with condition
 C_BudgetLine.C_Budget_ID = NULL
and should be
 C_BudgetLine.C_Budget_ID is NULL
Additional Information
TagsNo tags attached.
Relationships
related to defect 0007081 closed gorkaion Generate standard cost does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-09 18:15egoitzNew Issue
2009-09-09 18:15egoitzAssigned To => rafaroda
2009-09-14 16:37roklenardicNote Added: 0019912
2009-09-18 11:10hgbotCheckin
2009-09-18 11:10hgbotNote Added: 0020189
2009-09-18 11:10hgbotStatusnew => resolved
2009-09-18 11:10hgbotResolutionopen => fixed
2009-09-18 11:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]
2009-09-18 11:17rafarodaRelationship addedrelated to 0007081
2009-09-18 11:18rafarodaNote Added: 0020190
2009-09-18 13:34psarobeStatusresolved => closed
2009-09-18 13:34psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861733
2009-09-29 14:13hgbotCheckin
2009-09-29 14:13hgbotNote Added: 0020483
2009-09-29 14:13hgbotStatusclosed => resolved
2009-09-29 14:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]
2009-10-06 11:36psarobeStatusresolved => closed
2009-10-06 11:36psarobeNote Added: 0020765

Notes
(0019912)
roklenardic   
2009-09-14 16:37   
i think it does not work in postgres either since the standard cost i calculated do not include the cost of raw materials...
(0020189)
hgbot   
2009-09-18 11:10   
Repository: erp/devel/pi
Changeset: 2024fe4641884c64eb5ce03b9eb2c0185b66dc97
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Sep 14 18:30:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]

Fixes issue 0010536 MA_STANDARD_COST_SEQUENCE procedure fixed for Oracle 10g

---
M src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
---
(0020190)
rafaroda   
2009-09-18 11:18   
Caused by the resolution of 0007081 https://code.openbravo.com/erp/devel/pi/rev/458354ef7fa9 [^]
(0020483)
hgbot   
2009-09-29 14:13   
Repository: erp/devel/pi-pageddatagrid
Changeset: 2024fe4641884c64eb5ce03b9eb2c0185b66dc97
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Sep 14 18:30:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]

Fixes issue 0010536 MA_STANDARD_COST_SEQUENCE procedure fixed for Oracle 10g

---
M src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
---
(0020765)
psarobe   
2009-10-06 11:36   
Closed again because hudson has reopened without no reason