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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019957
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2012-03-06 13:072012-04-02 06:12
ReportermalsasuaView Statuspublic 
Assigned Tojecharri 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision09e5d0020049
ProjectionnoneETAnoneTarget Version3.0MP10
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket14594
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019957: 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 ]
depends on backport 00201312.50MP41 closedjecharri wrong code in mrp_run_initialize process 

-  Notes
(0046793)
hgbot (developer)
2012-03-28 09:22

 Repository: erp/devel/pi
Changeset: 09e5d0020049826d1bc97b7a042d462e37f82179
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 28 09:21:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/09e5d0020049826d1bc97b7a042d462e37f82179 [^]

Fixes issue 19957: wrong code in mrp_run_initialize process

---
M src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
---
(0046965)
malsasua (viewer)
2012-03-30 11:22

 rev: 3.0.15680
test plan:
. steps -> ok

code review-> ok
(0047250)
hudsonbot (viewer)
2012-04-02 06:12

 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/7814864461ac [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-03-06 13:07 malsasua New Issue
2012-03-06 13:07 malsasua Assigned To => vmromanos
2012-03-06 13:07 malsasua Web browser => Google Chrome
2012-03-06 13:07 malsasua Modules => Core
2012-03-06 13:07 malsasua OBNetwork customer => Yes
2012-03-06 13:07 malsasua Support ticket => 14594
2012-03-06 13:07 malsasua Resolution time => 1337551200
2012-03-12 12:26 vmromanos Assigned To vmromanos => jonalegriaesarte
2012-03-27 17:26 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2012-03-27 17:26 jonalegriaesarte Web browser Google Chrome => Google Chrome
2012-03-27 17:26 jonalegriaesarte version => pi
2012-03-27 17:26 jonalegriaesarte Target Version => 3.0MP10
2012-03-28 09:22 hgbot Checkin
2012-03-28 09:22 hgbot Note Added: 0046793
2012-03-28 09:22 hgbot Status new => resolved
2012-03-28 09:22 hgbot Resolution open => fixed
2012-03-28 09:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/09e5d0020049826d1bc97b7a042d462e37f82179 [^]
2012-03-28 09:25 jecharri Status resolved => new
2012-03-28 09:25 jecharri Resolution fixed => open
2012-03-28 09:25 jecharri Status new => scheduled
2012-03-28 09:25 jecharri fix_in_branch => pi
2012-03-28 09:25 jecharri Status scheduled => resolved
2012-03-28 09:25 jecharri Resolution open => fixed
2012-03-30 11:22 malsasua Note Added: 0046965
2012-03-30 11:22 malsasua Status resolved => closed
2012-04-02 06:12 hudsonbot Checkin
2012-04-02 06:12 hudsonbot Note Added: 0047250

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker