Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023277Openbravo ERP07. Sales managementpublic2013-03-11 13:462013-03-28 01:39
Reportermalsasua 
Assigned ToSandrahuguet 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023277: c_invoice_post process does not work with business partner names longer than 60 chars
Description. error is returned to process a purchase invoice, when the business partner name is longer than 60 chars
. In standard, the max length of business partner name is 60 chars, but you can change it.
Steps To Reproduce. allow in aplication dictionary, business partner name with length higher than 60 chars.
. create a new business partner with name higher than 60 chars.
. create a new purchase invoice with the previous business partner
. process
error is returned:
Error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Proposed Solution. in PL C_INVOICE_POST:
line 171 v_bpartner_name VARCHAR2(60);
change to v_bpartner_name VARCHAR2(1000);
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-11 13:46malsasuaNew Issue
2013-03-11 13:46malsasuaAssigned To => dmiguelez
2013-03-11 13:46malsasuaWeb browser => Google Chrome
2013-03-11 13:46malsasuaModules => Core
2013-03-11 13:46malsasuaOBNetwork customer => No
2013-03-11 13:46malsasuaTriggers an Emergency Pack => No
2013-03-14 16:40SandrahuguetAssigned Todmiguelez => Sandrahuguet
2013-03-14 17:54SandrahuguetStatusnew => scheduled
2013-03-14 17:54Sandrahuguetfix_in_branch => pi
2013-03-26 09:01SandrahuguetNote Added: 0057453
2013-03-26 09:03hgbotCheckin
2013-03-26 09:03hgbotNote Added: 0057454
2013-03-26 09:03hgbotStatusscheduled => resolved
2013-03-26 09:03hgbotResolutionopen => fixed
2013-03-26 09:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3c9887b82ed431a6074ad73b57382d26f4bffb41 [^]
2013-03-26 09:19pramakrishnanReview Assigned To => pramakrishnan
2013-03-26 09:19pramakrishnanNote Added: 0057455
2013-03-26 09:19pramakrishnanStatusresolved => closed
2013-03-28 01:39hudsonbotCheckin
2013-03-28 01:39hudsonbotNote Added: 0057517

Notes
(0057453)
Sandrahuguet   
2013-03-26 09:01   
Test plan
. allow in aplication dictionary, business partner name with length higher than 60 chars.
. create a new business partner with name higher than 60 chars.
. create a new purchase invoice with the previous business partner
. process
(0057454)
hgbot   
2013-03-26 09:03   
Repository: erp/devel/pi
Changeset: 3c9887b82ed431a6074ad73b57382d26f4bffb41
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Mar 15 12:45:46 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3c9887b82ed431a6074ad73b57382d26f4bffb41 [^]

Fixed bug 23277 Change length to v_bpartner_name
Change length to v_bpartner_name in C_INVOICE_POST,
C_ORDER_POST1, M_INOUT_POST, M_REQUISITION_POST

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/M_INOUT_POST.xml
M src-db/database/model/functions/M_REQUISITION_POST.xml
---
(0057455)
pramakrishnan   
2013-03-26 09:19   
Code Review + Testing - OK.
(0057517)
hudsonbot   
2013-03-28 01:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6c4c5ed08030 [^]

Maturity status: Test