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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013780
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2010-06-25 10:492010-07-23 00:00
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision9325816dbd05
ProjectionnoneETAnoneTarget Version2.50MP20
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP18SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013780: mrp_run_initialize does not filter by active products

Descriptionmrp_run_initialize does not filter by active products, in case you have a lot of deactivated products in your application the performance of this function is really slow.
Proposed Solutionin Cur_Product of mrp_run_initialize function, add clause
AND P.ISACTIVE = 'Y'



TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0029214)
hgbot (developer)
2010-07-12 06:30

 Repository: erp/devel/pi
Changeset: 9325816dbd05b2528564a4cccf7ced2d72d12c21
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Jul 12 09:58:36 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9325816dbd05b2528564a4cccf7ced2d72d12c21 [^]

Fixes Issue 13780: mrp_run_initialize does not filter by active products

---
M src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
---
(0029215)
harikrishnan (viewer)
2010-07-12 06:31

 Steps to test:
*Test the these windows by deactivating the product and check it.
    1)Manufacturing Plan
    2)Purchasing Plan
    
Root Cause:
*Before Product Isactive='Y' condition is not checked.

Impact:
The fix will impact in these procedure.
MRP_PRODUCTION_RUN.xml
MRP_PURCHASE_RUN.xml
MRP_RUN_EXPLODE.xml

And they are tested.
(0029282)
hudsonbot (viewer)
2010-07-14 04:43

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/9325816dbd05 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2a91111beef4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17878.obx [^]
(0029487)
sureshbabu (viewer)
2010-07-22 21:08

 verified

- Issue History
Date Modified Username Field Change
2010-06-25 10:49 networkb New Issue
2010-06-25 10:49 networkb Assigned To => adrianromero
2010-06-25 10:49 networkb OBNetwork customer => Yes
2010-07-05 13:31 adrianromero Status new => scheduled
2010-07-05 13:31 adrianromero fix_in_branch => pi
2010-07-12 06:30 harikrishnan Assigned To adrianromero => harikrishnan
2010-07-12 06:30 hgbot Checkin
2010-07-12 06:30 hgbot Note Added: 0029214
2010-07-12 06:30 hgbot Status scheduled => resolved
2010-07-12 06:30 hgbot Resolution open => fixed
2010-07-12 06:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9325816dbd05b2528564a4cccf7ced2d72d12c21 [^]
2010-07-12 06:31 harikrishnan Note Added: 0029215
2010-07-14 04:43 hudsonbot Checkin
2010-07-14 04:43 hudsonbot Note Added: 0029282
2010-07-22 21:08 sureshbabu Note Added: 0029487
2010-07-22 21:08 sureshbabu Status resolved => closed
2010-07-23 00:00 anonymous sf_bug_id 0 => 3033263

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker