Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004105Openbravo ERP06. Material requirement planning (MRP)public2008-06-20 17:412008-10-08 18:24
Reportercheli 
Assigned Togorkaion 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.35MP7 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004105: Error in MRP_WORKREQUIREMENT.xml function
DescriptionIn function https://dev.openbravo.com/svn/openbravo/trunk/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml [^]
there is an error when ob tries to get the next id from MA_WORKREQUIREMENT

Ad_Sequence_Next('MRP_WorkRequirement', v_Client_ID, v_WR_ID);
      Ad_Sequence_Doc('DocumentNo_MA_WorkRequirement', v_Client_ID, 'Y', v_DocumentNo) ;
      INSERT INTO MA_WORKREQUIREMENT (

you have to change
Ad_Sequence_Next('MRP_WorkRequirement', v_Client_ID, v_WR_ID);

for

Ad_Sequence_Next('MA_WorkRequirement', v_Client_ID, v_WR_ID);

to work.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0004459 closed cromero Error in function mrp_workrequirement? 
blocks defect 0004104 closed gorkaion Error in MRP_WORKREQUIREMENT.xml function 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-20 17:41cromeroNew Issue
2008-06-20 17:41cromeroAssigned To => gorkaion
2008-06-20 17:41cromeroStatusnew => scheduled
2008-06-20 17:51cromeroOBNetwork customer => No
2008-06-20 17:51cromeroPrioritynormal => urgent
2008-06-20 17:51cromeroSeveritycritical => major
2008-06-20 17:52svnbotCheckin
2008-06-20 17:52svnbotNote Added: 0007920
2008-06-20 17:52svnbotStatusscheduled => resolved
2008-06-20 17:52svnbotResolutionopen => fixed
2008-06-20 17:52svnbotsvn_revision => 5261
2008-07-22 11:04cromeroRelationship addedhas duplicate 0004459
2008-10-08 18:24psarobeRegression testing => No
2008-10-08 18:24psarobeStatusresolved => closed

Notes
(0007920)
svnbot   
2008-06-20 17:52   
Repository: openbravo
Revision: 5261
Author: gorkaion
Date: 2008-06-20 17:52:06 +0200 (Fri, 20 Jun 2008)

Fixed bug 4105. Changed the AD_Sequence_Next call to correctly generate the new id.

---
U branches/r2.3x/database/model/functions/MRP_WORKREQUIREMENT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5261&sc=1 [^]