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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023277
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2013-03-11 13:462013-03-28 01:39
ReportermalsasuaView Statuspublic 
Assigned ToSandrahuguet 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision3c9887b82ed4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Topramakrishnan
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023277: 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);
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0057453)
Sandrahuguet (developer)
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 (developer)
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 (developer)
2013-03-26 09:19

Code Review + Testing - OK.
(0057517)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2013-03-11 13:46 malsasua New Issue
2013-03-11 13:46 malsasua Assigned To => dmiguelez
2013-03-11 13:46 malsasua Web browser => Google Chrome
2013-03-11 13:46 malsasua Modules => Core
2013-03-11 13:46 malsasua Triggers an Emergency Pack => No
2013-03-14 16:40 Sandrahuguet Assigned To dmiguelez => Sandrahuguet
2013-03-14 17:54 Sandrahuguet Status new => scheduled
2013-03-14 17:54 Sandrahuguet fix_in_branch => pi
2013-03-26 09:01 Sandrahuguet Note Added: 0057453
2013-03-26 09:03 hgbot Checkin
2013-03-26 09:03 hgbot Note Added: 0057454
2013-03-26 09:03 hgbot Status scheduled => resolved
2013-03-26 09:03 hgbot Resolution open => fixed
2013-03-26 09:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3c9887b82ed431a6074ad73b57382d26f4bffb41 [^]
2013-03-26 09:19 pramakrishnan Review Assigned To => pramakrishnan
2013-03-26 09:19 pramakrishnan Note Added: 0057455
2013-03-26 09:19 pramakrishnan Status resolved => closed
2013-03-28 01:39 hudsonbot Checkin
2013-03-28 01:39 hudsonbot Note Added: 0057517


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker