Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002541Openbravo ERP06. Material requirement planning (MRP)public2008-01-22 13:052008-07-08 11:16
Reportergorkaion 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002541: MRP_Run_Initialize function doesn't work in PostgreSQL
DescriptionOpenbravo trunk build.

The execution of the Process button of Manufacturing Plan window doesn't work.

for further details see https://sourceforge.net/forum/message.php?msg_id=4735098 [^]

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003604 closed gorkaion MRP_Run_Initialize function doesn't work in Postgr 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-08 11:16psarobeStatusresolved => closed
2008-07-08 11:16psarobeFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006130)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1877210 [^]
(0003079)
gorkaion   
2008-01-22 13:26   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500690
Originator: YES

The call to MRP_Check_Planningmethod is wrong for postgresql. The 3rd parameter should be numeric instead an interval.

A cast using to_number() has been used.