Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002299Openbravo ERP08. Project and service managementpublic2007-11-22 18:512008-06-12 09:43
Reporteruser71 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
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
Summary0002299: Generate Order from project phase fails
DescriptionDescription:
When generating a sales order from a project phase by using the "Generate order" button, the following error occurs: "ORA-06502: PL/SQL: error : error de conversión de carácter a número numérico o de valor".

Enviroment:
OS: Windows XP SP2
DB: Oracle XE
Browser: FF2
Openbravo: 2.35
Language: English

Steps:
1.- Go to Project & Service Management > Transactions > Multiphase Project
2.- Create a new project
3.- Select a project type
4.- Fill in the business partner, pricelist, partner address, form of payment, payment term, service point and currency.
5.- Save
6.- Go to one of the project phases
7.- Select a product
8.- Save
9.- Press Generate Order button
10.- The error "ORA-06502: PL/SQL: error : error de conversión de carácter a número numérico o de valor" appears.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005888)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1836592 [^]
(0002702)
cromero   
2008-02-20 19:12   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500614
Originator: NO

I have tried to reproduce the bug but I have not been able to.
Could you please post the parameters you have choosen in order to reproduce the bug?

Thank you

Carlos Romero
(0002703)
user71   
2008-04-01 09:15   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1810954
Originator: YES

The error only happens when the sales order document number contains a character that is not a number. Thus, when the sales order is automatically generated and the document number calculated, the process fail because it stores the document number in a numeric variable instead of an alphanumeric variable.

I hope it helps.

Regards.
(0002704)
rafaroda   
2008-04-08 15:54   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: NO

Now 'Document No' variable is 'NVARCHAR2(30)' in 'GenerateSOFromProjecPhase' procedure.

https://dev.openbravo.com/websvn/openbravo/?op=comp&compare[]=%2F@3343&compare[]=%2F@3344 [^]