Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020745Openbravo ERP09. Financial managementpublic2012-06-13 12:142012-07-02 17:37
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2012-05-31
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/e1e23b382aa1e15d3c56bf96d3256265f2e22322 [^]
Triggers an Emergency PackNo
Summary0020745: GL Journal Post process failing due to wrong change which causes a regression
DescriptionFix for bug 020183: gl journal is checked like posted when there is not lines introduces a regression.
new select into introduced by this change set is causing a regression as GL Journal can not be completed in oracle.
Steps To Reproduce1) create a GL Journal
2) Process it
3) Mind the error

Remember to execute this script in oracle!!!!!!!
Proposed SolutionFix the sql adding the missing join
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020183 closed ioritzCia gl journal is checked like posted when there is not lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-13 12:14eduardo_ArgalNew Issue
2012-06-13 12:14eduardo_ArgalAssigned To => ioritzCia
2012-06-13 12:14eduardo_ArgalModules => Core
2012-06-13 12:14eduardo_ArgalOBNetwork customer => No
2012-06-13 12:21eduardo_ArgalRegression level => Pre packaging ( pi )
2012-06-13 12:21eduardo_ArgalRegression date => 2012-05-31
2012-06-13 12:21eduardo_ArgalRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/e1e23b382aa1e15d3c56bf96d3256265f2e22322 [^]
2012-06-13 12:22eduardo_ArgalStatusnew => scheduled
2012-06-13 12:22eduardo_Argalfix_in_branch => pi
2012-06-13 12:22eduardo_ArgalRelationship addedrelated to 0020183
2012-06-13 12:49hgbotCheckin
2012-06-13 12:49hgbotNote Added: 0049807
2012-06-13 12:49hgbotStatusscheduled => resolved
2012-06-13 12:49hgbotResolutionopen => fixed
2012-06-13 12:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c5725502022695884fc4d25486fe5057ec9933c2 [^]
2012-07-02 12:18shuehnerAssigned ToioritzCia => eduardo_Argal
2012-07-02 12:18shuehnerfix_in_branchpi =>
2012-07-02 17:35miruritaNote Added: 0050322
2012-07-02 17:35miruritaStatusresolved => closed
2012-07-02 17:35miruritaFixed in Version => 3.0MP13
2012-07-02 17:37vmromanosNote Added: 0050323

Notes
(0049807)
hgbot   
2012-06-13 12:49   
Repository: erp/devel/pi
Changeset: c5725502022695884fc4d25486fe5057ec9933c2
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Jun 13 12:24:01 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c5725502022695884fc4d25486fe5057ec9933c2 [^]

Fixes bug 20745: GL Journal Post process failing due to wrong change which causes a regression

---
M src-db/database/model/functions/GL_JOURNAL_POST.xml
---
(0050322)
mirurita   
2012-07-02 17:35   
The fix related to this issue does not work on oracle because SELECT INTO statement will fail because it can return more than one row.

The following issue 0020183 solves the problem.
(0050323)
vmromanos   
2012-07-02 17:37   
Tested in Oracle and PostgreSQL