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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0002299
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementminoralways2007-11-22 18:512008-06-12 09:43
Reporteruser71View Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionfixedFixed in Version2.40alpha-r2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM 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

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0002702)
cromero (viewer)
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 (viewer)
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 [^]
(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 [^]

- Issue History
Date Modified Username Field Change

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker