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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006210
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2008-11-26 13:182008-12-11 10:08
ReporterAinhoaPagolaView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10609
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseAnyJava version1.5
OS VersionUbuntu 8.4Database versionAnt version1.7
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006210: Requisition to order does not work

DescriptionRequisition to order always fails with the message:
"Process failed during execution".
The log says:
ERROR org.openbravo.erpCommon.ad_forms.RequisitionToOrderData - SQL error in query: CALL M_RequisitionLine_Status(null, TO_NUMBER(?), ?)Exception:java.sql.SQLException: ORA-01722: invalid number

Steps To ReproduceCreate a new requisition with a line on it.
Go to Requisition to order process.
Add the line and press the create button.
In the popup window press OK.
Proposed SolutionIn RequisitionToOrder_Data.xql, swap the line
CALL M_RequisitionLine_Status(null, TO_NUMBER(?), ?)
for
CALL M_RequisitionLine_Status(null, ?, ?)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0010712)
svnbot (reporter)
2008-11-26 13:23

Repository: openbravo
Revision: 10609
Author: AinhoaPagola
Date: 2008-11-26 13:23:33 +0100 (Wed, 26 Nov 2008)

Fixes bug 0006210. Requisition to order. TO_NUMBER was used for an ID parameter.

---
U trunk/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---

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

- Issue History
Date Modified Username Field Change
2008-11-26 13:18 AinhoaPagola New Issue
2008-11-26 13:18 AinhoaPagola Assigned To => rafaroda
2008-11-26 13:18 AinhoaPagola sf_bug_id 0 => 2350621
2008-11-26 13:18 AinhoaPagola Regression testing => No
2008-11-26 13:20 AinhoaPagola Assigned To rafaroda => AinhoaPagola
2008-11-26 13:23 svnbot Checkin
2008-11-26 13:23 svnbot Note Added: 0010712
2008-11-26 13:23 svnbot Status new => resolved
2008-11-26 13:23 svnbot Resolution open => fixed
2008-11-26 13:23 svnbot svn_revision => 10609
2008-12-11 10:08 krishna Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker