Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008519Openbravo ERP02. Master data managementpublic2009-04-08 18:252009-05-05 00:00
Reporterstalker 
Assigned Torajagopal 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version2.6.27-11-generic
Product Version2.50beta 
Target VersionFixed in Version2.50MP1 
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
Summary0008519: Create price list function fails
DescriptionHere: Master Data Management || Pricing || Price List || Price List >> Price List Version

Create Price List function fails to create prices for a new price list.

Please note, that is you're trying to reproduce this bug with Openbravo account (or whatever with user_id=0), the bug doesn't discloses itself. You need to use any account with get_uuid() generated user_id....
Steps To Reproduce1. create due pricelist shcema
2. create pricelist
3. fill it with prices
4. create pricelist version
5. Push "Create Price List" button
Proposed SolutionHere: 250beta/src-db/database/model/functions/M_PRICELIST_CREATE.xml
change type of var v_UpdatedBy from NUMBER to VARCHAR(32)



There are several same mistypes in DB model repository, by the way..
I think, it worth fixing all of them:

root@LinSrv:/opt/250beta/src-db/database/model/functions# grep "edBy.*NUM" *
C_ELEMENTVALUE_COPY.xml: v_xUpdatedBy NUMBER;
MA_COPY_VERSION.xml: v_UpdatedBy NUMBER;
MA_GLOBALUSE_DISTRIBUTE.xml: v_UpdatedBy NUMBER;
M_PRICELIST_CREATE.xml: v_UpdatedBy NUMBER;


Additional Information
Tags250MP1
Relationships
has duplicate defect 0008712 closed rajagopal Error when creating a new pricelist from a pricelist version and a pricelist schema 
blocks defect 0008668 closed rajagopal pl-function ./C_VALIDCOMBINATION_GET.xml: has uuid issue 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 18:25stalkerNew Issue
2009-04-08 18:25stalkerAssigned To => rafaroda
2009-04-09 10:28rafarodaOBNetwork customer => No
2009-04-09 10:28rafarodaAssigned Torafaroda => sathiyan
2009-04-09 10:28rafarodaPrioritynormal => high
2009-04-09 10:28rafarodaStatusnew => scheduled
2009-04-09 10:28rafarodaDescription Updated
2009-04-15 08:33sathiyanAssigned Tosathiyan => rajagopal
2009-04-18 09:49rajagopalNote Added: 0015410
2009-04-18 09:53rajagopalNote Edited: 0015410
2009-04-18 09:54rajagopalFile Added: 8519.png
2009-04-18 11:05rajagopalFile Deleted: 8519.png
2009-04-18 11:05rajagopalNote Edited: 0015410
2009-04-18 14:33rajagopalNote Edited: 0015410
2009-04-22 13:49stalkerNote Added: 0015533
2009-04-22 13:49stalkerNote Edited: 0015533
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-23 16:53rafarodaRelationship addedrelated to 0008712
2009-04-23 16:58psarobeRelationship replacedhas duplicate 0008712
2009-04-24 09:02hgbotCheckin
2009-04-24 09:02hgbotNote Added: 0015655
2009-04-24 09:02hgbotStatusscheduled => resolved
2009-04-24 09:02hgbotResolutionopen => fixed
2009-04-24 09:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/deb017144310bace5c90845d50200c400291a9d0 [^]
2009-04-24 09:07rajagopalRelationship addedblocks 0008668
2009-05-04 18:55psarobeRegression testing => No
2009-05-04 18:55psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786895

Notes
(0015410)
rajagopal   
2009-04-18 09:49   
(edited on: 2009-04-18 14:33)
Hello Mr.Stalker,

Apart from the xml which you have specified for modification above, I have notice that one xml file (C_VALIDCOMBINATION_GET.xml) also requires the modification for CreatedBy column. Kindly correct me if I am wrong.

Thanks,
B.Rajagopal
(0015533)
stalker   
2009-04-22 13:49   
Hello! please have a look at this issue: https://issues.openbravo.com/view.php?id=8169 [^]

I think, that it has a relation to your inquiery

Stas
(0015655)
hgbot   
2009-04-24 09:02   
Repository: erp/devel/pi
Changeset: deb017144310bace5c90845d50200c400291a9d0
Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
Date: Fri Apr 24 12:27:06 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/deb017144310bace5c90845d50200c400291a9d0 [^]

Fixes bug 8519: Create price list function fails has been fixed.

---
M src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml
M src-db/database/model/functions/MA_COPY_VERSION.xml
M src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml
M src-db/database/model/functions/M_PRICELIST_CREATE.xml
---