Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027442Openbravo ERP07. Sales managementpublic2014-08-23 17:222014-10-16 10:35
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toeduardo_Argal
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027442: pl-function m_copy_product_template has uuid bug
DescriptionFunction reads from c_order.billto_id which is uuid varchar32 but stores into v_BillTo variable which is numeric.

Note: no regression just forgotten to be changed to varchar2 in uuid project start of 2.50 so broken since.

Note: that pl is used in some buttons but looks like all hidden by default.

Should just be fixed as fix is trivial to avoid the error
Steps To ReproduceReview pl body
Proposed Solutionchange v_billto variable to varchar2(32)
Additional Information
TagsNo tags attached.
Relationships
blocks design defect 0050984 new shuehner Tracking issue: Remove obsolete old-flow / pre-aprm related code 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-23 17:22shuehnerNew Issue
2014-08-23 17:22shuehnerAssigned To => dmiguelez
2014-08-23 17:22shuehnerOBNetwork customer => No
2014-08-23 17:22shuehnerModules => Core
2014-08-23 17:22shuehnerTriggers an Emergency Pack => No
2014-09-03 13:56eduardo_ArgalAssigned Todmiguelez => shuehner
2014-10-08 12:45hgbotCheckin
2014-10-08 12:45hgbotNote Added: 0070806
2014-10-08 12:45hgbotStatusnew => resolved
2014-10-08 12:45hgbotResolutionopen => fixed
2014-10-08 12:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/18d447125911dfbf9802c66c03dee3bd63b79b87 [^]
2014-10-08 12:48shuehnerReview Assigned To => eduardo_Argal
2014-10-16 10:35eduardo_ArgalNote Added: 0070983
2014-10-16 10:35eduardo_ArgalStatusresolved => closed
2022-12-13 15:53shuehnerRelationship addedblocks 0050984

Notes
(0070806)
hgbot   
2014-10-08 12:45   
Repository: erp/devel/pi
Changeset: 18d447125911dfbf9802c66c03dee3bd63b79b87
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Oct 07 18:31:19 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/18d447125911dfbf9802c66c03dee3bd63b79b87 [^]

Fixed 27442. Fix uuid bug. redefine v_billto variable as varchar2(32).
The variable v_billto is used to store a uuid (value of c_order.billto_id)
so define it as such and not as a number type.

---
M src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml
---
(0070983)
eduardo_Argal   
2014-10-16 10:35   
Reviewed and closed