Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0013780 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 06. Material requirement planning (MRP) | major | always | 2010-06-25 10:49 | 2010-07-23 00:00 | |||
Reporter | networkb | View Status | public | |||||
Assigned To | harikrishnan | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 9325816dbd05 | |||
Projection | none | ETA | none | Target Version | 2.50MP20 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP18 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0013780: mrp_run_initialize does not filter by active products | |||||||
Description | mrp_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 Solution | in Cur_Product of mrp_run_initialize function, add clause AND P.ISACTIVE = 'Y' | |||||||
Tags | No 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 (reporter) 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 (developer) 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 (reporter) 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-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 |