Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006210Openbravo ERP03. Procurement managementpublic2008-11-26 13:182008-12-11 10:08
AinhoaPagola 
AinhoaPagola 
normalmajoralways
closedfixed 
20Ubuntu 8.4
 
 
Core
No
0006210: Requisition to order does not work
Requisition 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

Create 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.
In RequisitionToOrder_Data.xql, swap the line
CALL M_RequisitionLine_Status(null, TO_NUMBER(?), ?)
for
CALL M_RequisitionLine_Status(null, ?, ?)
No tags attached.
Issue History
2008-11-26 13:18AinhoaPagolaNew Issue
2008-11-26 13:18AinhoaPagolaAssigned To => rafaroda
2008-11-26 13:18AinhoaPagolasf_bug_id0 => 2350621
2008-11-26 13:18AinhoaPagolaRegression testing => No
2008-11-26 13:20AinhoaPagolaAssigned Torafaroda => AinhoaPagola
2008-11-26 13:23svnbotCheckin
2008-11-26 13:23svnbotNote Added: 0010712
2008-11-26 13:23svnbotStatusnew => resolved
2008-11-26 13:23svnbotResolutionopen => fixed
2008-11-26 13:23svnbotsvn_revision => 10609
2008-12-11 10:08krishnaStatusresolved => closed

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