Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004104Openbravo ERP06. Material requirement planning (MRP)public2008-06-20 16:562008-08-21 19:38
Reportercheli 
Assigned Togorkaion 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Versionpi 
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
Summary0004104: 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
depends on backport 0004105 closed gorkaion Error in MRP_WORKREQUIREMENT.xml function 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-20 16:56cheliNew Issue
2008-06-20 16:56cheliAssigned To => cromero
2008-06-20 16:56chelisf_bug_id0 => 1998832
2008-06-20 17:41cromeroAssigned Tocromero => gorkaion
2008-06-20 17:41cromeroStatusnew => scheduled
2008-06-20 17:50cromeroOBNetwork customer => No
2008-06-20 17:50cromeroPrioritynormal => urgent
2008-06-20 17:50cromeroSeveritycritical => major
2008-06-20 17:53svnbotCheckin
2008-06-20 17:53svnbotNote Added: 0007922
2008-06-20 17:53svnbotStatusscheduled => resolved
2008-06-20 17:53svnbotResolutionopen => fixed
2008-06-20 17:53svnbotsvn_revision => 5263
2008-08-21 19:38psarobeRegression testing => No
2008-08-21 19:38psarobeStatusresolved => closed
2008-08-21 19:38psarobeFixed in Version => trunk

Notes
(0007922)
svnbot   
2008-06-20 17:53   
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 [^]