Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002790 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | minor | always | 2008-04-01 12:38 | 2008-07-03 17:44 | |||
Reporter | roklenardic | View Status | public | |||||
Assigned To | pheenan | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | 2.40beta | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002790: Commision field length | |||||||
Description | In Sales Management || Setup || Commission || Header I created a new commission named "Sales Commission for Mcgiver on today's date from Rok". When I click the Generate commision button, i get the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small So field length of the name of the commision here should be restricted or the process fixed. source: demo2.openbravo.com | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0003408) pheenan (viewer) 2008-04-25 17:55 edited on: 2008-06-12 09:25 |
Logged In: YES user_id=1883435 Originator: NO Issue is in the C_Commission_Process procedure. Field length for the name variable is 60 characters. The maximum length for the value being passed into this variable is 60 characters. During the process extra values are appended to the variable adding an extra 30 characters. Change the variable length to 90 characters. Following the addition of the appended characters the only inserts involving this variable are to a description field of length 255 characters. |
(0003409) pheenan (viewer) 2008-04-28 10:27 edited on: 2008-06-12 09:25 |
Logged In: YES user_id=1883435 Originator: NO Fixed in revision 3850. Updated v_name variable length to 90 characters to allow for additional characters added to the name value during the process. |
(0006379) 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=1931088 [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2008-07-03 17:44 | plujan | Status | resolved => closed |
2008-07-03 17:44 | plujan | Fixed in Version | 2.40alpha-r2 => 2.40beta |
Copyright © 2000 - 2009 MantisBT Group |