Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004104
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2008-06-20 16:562008-08-21 19:38
ReportercheliView Statuspublic 
Assigned Togorkaion 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision5263
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version1.5
OS VersionDatabase version8.2.6Ant version1.7
Product VersionpiSCM revision 
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
Summary

0004104: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0004105 closedgorkaion Error in MRP_WORKREQUIREMENT.xml function 

-  Notes
(0007922)
svnbot (viewer)
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 [^]

- Issue History
Date Modified Username Field Change
2008-06-20 16:56 cheli New Issue
2008-06-20 16:56 cheli Assigned To => cromero
2008-06-20 16:56 cheli sf_bug_id 0 => 1998832
2008-06-20 17:41 cromero Assigned To cromero => gorkaion
2008-06-20 17:41 cromero Status new => scheduled
2008-06-20 17:50 cromero OBNetwork customer => No
2008-06-20 17:50 cromero Priority normal => urgent
2008-06-20 17:50 cromero Severity critical => major
2008-06-20 17:53 svnbot Checkin
2008-06-20 17:53 svnbot Note Added: 0007922
2008-06-20 17:53 svnbot Status scheduled => resolved
2008-06-20 17:53 svnbot Resolution open => fixed
2008-06-20 17:53 svnbot svn_revision => 5263
2008-08-21 19:38 psarobe Regression testing => No
2008-08-21 19:38 psarobe Status resolved => closed
2008-08-21 19:38 psarobe Fixed in Version => trunk


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker