Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007081Openbravo ERP05. Production managementpublic2009-01-22 19:582009-03-02 09:40
Reportergorkaion 
Assigned Togorkaion 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Versionpi 
Target VersionFixed in Version2.50beta 
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
Summary0007081: Generate standard cost does not work
DescriptionThe process to generate standard costs does not work. It fails with several oracle errors.
Steps To ReproduceSet up a simple process plan.

Run the generate standard costs in Production Management module
Proposed Solution
Additional Information
Tagscommsup_sprint6
Relationships
has duplicate defect 0007112 closed gorkaion Calculate Standard Costs process does not work 
related to defect 0010536 closed rafaroda The calculate standard costs process does not work using oracle 10g 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-22 19:58gorkaionNew Issue
2009-01-22 19:58gorkaionAssigned To => rafaroda
2009-01-22 19:58gorkaionsf_bug_id0 => 2529167
2009-01-22 19:58gorkaionRegression testing => No
2009-01-22 20:01gorkaionNote Added: 0012545
2009-01-22 20:02gorkaionNote Edited: 0012545
2009-01-23 16:04plujanRelationship addedhas duplicate 0007112
2009-01-28 08:46rafarodaversion => trunk
2009-01-30 15:20rafarodaAssigned Torafaroda => gorkaion
2009-01-30 15:20rafarodaPrioritynormal => high
2009-01-30 15:20rafarodaStatusnew => scheduled
2009-02-13 14:11svnbotCheckin
2009-02-13 14:11svnbotNote Added: 0013470
2009-02-13 14:11svnbotStatusscheduled => resolved
2009-02-13 14:11svnbotResolutionopen => fixed
2009-02-13 14:11svnbotsvn_revision => 13171
2009-02-19 12:52gorkaionTag Attached: commsup_sprint6
2009-03-02 09:40sureshbabuStatusresolved => closed
2009-03-02 09:40sureshbabuNote Added: 0014203
2009-03-02 09:40sureshbabuFixed in Version => trunk
2009-09-18 11:17rafarodaRelationship addedrelated to 0010536

Notes
(0012545)
gorkaion   
2009-01-22 20:01   
(edited on: 2009-01-22 20:02)
Two issues found at the moment:

1) Variables v_CostCenter_Version and v_ProcessPlan_Version must be VARCHAR2(32)

2) The select to calculate the price of the raw materials is wrong. (lines ~ 153-157)
(0013470)
svnbot   
2009-02-13 14:11   
Repository: openbravo
Revision: 13171
Author: gorkaion
Date: 2009-02-13 14:11:26 +0100 (Fri, 13 Feb 2009)

Fixed bug 7081. Set two variables to nvarchar2(32), fixed a query to retrieve the cost of raw materials.

---
U trunk/src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13171&sc=1 [^]
(0014203)
sureshbabu   
2009-03-02 09:40   
Retested in context 79.125.56.185/openbravotrunk