Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002790Openbravo ERP07. Sales managementpublic2008-04-01 12:382008-07-03 17:44
Reporterroklenardic 
Assigned Topheenan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
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
Summary0002790: Commision field length
DescriptionIn 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
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003690 closed pheenan Commision field length 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-03 17:44plujanStatusresolved => closed
2008-07-03 17:44plujanFixed in Version2.40alpha-r2 => 2.40beta

Notes
(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 [^]
(0003408)
pheenan   
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   
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.