Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013780Openbravo ERP06. Material requirement planning (MRP)public2010-06-25 10:492010-07-23 00:00
Reporternetworkb 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP18 
Target Version2.50MP20Fixed in Version 
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
Summary0013780: 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.
Steps To Reproduce
Proposed Solutionin Cur_Product of mrp_run_initialize function, add clause
AND P.ISACTIVE = 'Y'



Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-25 10:49networkbNew Issue
2010-06-25 10:49networkbAssigned To => adrianromero
2010-06-25 10:49networkbOBNetwork customer => Yes
2010-07-05 13:31adrianromeroStatusnew => scheduled
2010-07-05 13:31adrianromerofix_in_branch => pi
2010-07-12 06:30harikrishnanAssigned Toadrianromero => harikrishnan
2010-07-12 06:30hgbotCheckin
2010-07-12 06:30hgbotNote Added: 0029214
2010-07-12 06:30hgbotStatusscheduled => resolved
2010-07-12 06:30hgbotResolutionopen => fixed
2010-07-12 06:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9325816dbd05b2528564a4cccf7ced2d72d12c21 [^]
2010-07-12 06:31harikrishnanNote Added: 0029215
2010-07-14 04:43hudsonbotCheckin
2010-07-14 04:43hudsonbotNote Added: 0029282
2010-07-22 21:08sureshbabuNote Added: 0029487
2010-07-22 21:08sureshbabuStatusresolved => closed
2010-07-23 00:00anonymoussf_bug_id0 => 3033263

Notes
(0029214)
hgbot   
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   
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   
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   
2010-07-22 21:08   
verified