Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020131
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 05. Production managementmajoralways2012-03-06 13:072012-04-12 10:24
ReportermalsasuaView Statuspublic 
Assigned Tojecharri 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision2f9f33f0b923
ProjectionnoneETAnoneTarget Version2.50MP41
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP40SCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020131: wrong code in mrp_run_initialize process

DescriptionWhen a purchase order line, the schedule delivery date is null , error is returned:
null value in column "qty" violates not-null constraint

It is generated because in mrp_run_initialize process, in cursor Cur_OrderLine, in the cursor query, the call to the process Mrp_Check_Planningmethod in the zone "select" is distinct to call in the zone "where":
in the zone "where", the third parameter of Mrp_Check_Planningmethod process is
 TO_NUMBER(COALESCE(ol.DatePromised, ol.DateOrdered, o.DateOrdered) - p_PlanningDate)
and in the zone "select" the third parameter is
TO_NUMBER(ol.DatePromised - p_PlanningDate)
this should be equal to previous:
 TO_NUMBER(COALESCE(ol.DatePromised, ol.DateOrdered, o.DateOrdered) - p_PlanningDate)
Steps To Reproduce. create purchase order line without schedule delivery date
. run process purchase plan
Proposed Solutionchange in zone "select", in call to process Mrp_Check_Planningmethod, the third parameter from
TO_NUMBER(ol.DatePromised - p_PlanningDate)
to
TO_NUMBER(COALESCE(ol.DatePromised, ol.DateOrdered, o.DateOrdered) - p_PlanningDate)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00199573.0MP10 closedjecharri wrong code in mrp_run_initialize process 

-  Notes
(0046797)
hgbot (developer)
2012-03-28 09:42

 Repository: erp/stable/2.50
Changeset: 2f9f33f0b923c1098e985858d98ead6a474b5f54
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 28 09:41:47 2012 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/2f9f33f0b923c1098e985858d98ead6a474b5f54 [^]

Fixes issue 20131: wrong code in mrp_run_initialize process

---
M src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
---
(0047497)
malsasua (developer)
2012-04-12 10:24

 revision: 2.50.19850
functionality: OK
code: OK

- Issue History
Date Modified Username Field Change
2012-03-28 09:25 jecharri Type defect => backport
2012-03-28 09:25 jecharri fix_in_branch => 2.50
2012-03-28 09:26 jecharri Web browser Google Chrome => Google Chrome
2012-03-28 09:26 jecharri version pi => 2.50MP40
2012-03-28 09:26 jecharri Target Version 3.0MP10 => 2.50MP41
2012-03-28 09:42 hgbot Checkin
2012-03-28 09:42 hgbot Note Added: 0046797
2012-03-28 09:42 hgbot Status scheduled => resolved
2012-03-28 09:42 hgbot Resolution open => fixed
2012-03-28 09:42 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/09e5d0020049826d1bc97b7a042d462e37f82179 [^] => http://code.openbravo.com/erp/stable/2.50/rev/2f9f33f0b923c1098e985858d98ead6a474b5f54 [^]
2012-04-12 10:24 malsasua Note Added: 0047497
2012-04-12 10:24 malsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker