Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004459 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 06. Material requirement planning (MRP) | minor | always | 2008-07-18 19:06 | 2008-07-22 11:04 | |||
| Reporter | mrp02000 | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | 8.2.9 | Ant version | |||||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004459: Error in function mrp_workrequirement? | |||||||
| Description | After processing a manufacturing plan and attempting to create the suggested work requirements, the process fails with the report: "null value in column "ma_workrequirement_id" violates not-null constraint" No work requirements are created. Line 79 of the function mrp_workrequirement reads: SELECT * INTO v_WR_ID FROM Ad_Sequence_Next('MRP_WorkRequirement', v_User_ID); seemingly passing the table mrp_workrequirement to the ad_sequence_next function. If the function is changed so that the table ma_workrequirement is passed instead, work requirements can be generated from the manufacturing plan, and show up in the appropriate transaction area. | |||||||
| Steps To Reproduce | Using the Openbravo online demo, create a planner and planning method for one of the products with a process plan. Create a sales order or forecast to generate demand, create a manufacturing plan, and process it. Verify that work requirements are suggested in the Lines tab. Attempt to create the material and work requirements. | |||||||
| Proposed Solution | For me, changing line 79 in the function as described fixed the problem. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008338) joan (viewer) 2008-07-19 10:16 |
From -> https://issues.openbravo.com/view.php?id=4104 [^] Repository: openbravo Revision: 5263 Author: gorkaion Date: 2008-06-20 17:53:41 +0200 (Fri, 20 Jun 2008) Fixed bug 4104. Changed the call to AS_Sequence_Next function to correctly generate the new id. --- U trunk/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=5263&sc=1 [^] [^] Isn't it fixed in last release? |
|
(0008362) cromero (viewer) 2008-07-22 11:04 |
You are right and indeed it has been reported and fixed. It will be included in next maintenance packs. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-18 19:06 | mrp02000 | New Issue | |
| 2008-07-18 19:06 | mrp02000 | Assigned To | => cromero |
| 2008-07-18 19:06 | mrp02000 | sf_bug_id | 0 => 2021650 |
| 2008-07-19 10:16 | joan | Note Added: 0008338 | |
| 2008-07-22 11:04 | cromero | Relationship added | duplicate of 0004105 |
| 2008-07-22 11:04 | cromero | Status | new => closed |
| 2008-07-22 11:04 | cromero | Note Added: 0008362 | |
| 2008-07-22 11:04 | cromero | Duplicate ID | 0 => 4105 |
| 2008-07-22 11:04 | cromero | Resolution | open => duplicate |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |