Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029251Openbravo ERP09. Financial managementpublic2015-03-03 12:252015-03-12 11:02
ReporterSandrahuguet 
Assigned ToAtulOpenbravo 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version 
Target Version3.0PR14Q3.8Fixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date2013-12-31
Regression introduced in release3.0MP31
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/fcb87e990fcd [^]
Triggers an Emergency PackNo
Summary0029251: It is not possible to change currency in header tab in G/L Journal
DescriptionIt is not possible to change currency in header tab in G/L Journal working in oracle.
Steps To Reproduce-Go to G/L Journal and create new record to "F&B España" Organization
-Navigate to header and create new record:
  ·Organization: F&B España
  ·Currency: EUR
-Navigate to lines and create a new line
-Return to the header and try to change currency to USD, the following error is shown:

Error
Saving failed. ORA-04091: table ERP_PI_ORACLE.GL_JOURNAL is mutating, trigger/function may not see it ORA-06512: at "ERP_PI_ORACLE.GL_JOURNALLINE2_TRG", line 41 ORA-04088: error during execution of trigger 'ERP_PI_ORACLE.GL_JOURNALLINE2_TRG' ORA-06512: at "ERP_PI_ORACLE.GL_JOURNAL_TRG", line 35 ORA-04088: error during execution of trigger 'ERP_PI_ORACLE.GL_JOURNAL_TRG'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0029110 closed AtulOpenbravo It is not possible to change currency in header tab in G/L Journal 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-12 10:08aferrazTypedefect => backport
2015-03-12 10:08aferrazTarget Version => 3.0PR14Q3.8
2015-03-12 10:58hgbotCheckin
2015-03-12 10:58hgbotNote Added: 0075476
2015-03-12 10:59hgbotStatusscheduled => resolved
2015-03-12 10:59hgbotResolutionopen => fixed
2015-03-12 10:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/74046f2ce82c948cfaa4dc3659f5a7b5ee7963e4 [^]
2015-03-12 10:59hgbotCheckin
2015-03-12 10:59hgbotNote Added: 0075477
2015-03-12 11:02aferrazReview Assigned To => aferraz
2015-03-12 11:02aferrazNote Added: 0075479
2015-03-12 11:02aferrazStatusresolved => closed

Notes
(0075476)
hgbot   
2015-03-12 10:58   
Repository: erp/backports/3.0PR14Q3.8
Changeset: 74046f2ce82c948cfaa4dc3659f5a7b5ee7963e4
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 11 11:48:22 2015 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/74046f2ce82c948cfaa4dc3659f5a7b5ee7963e4 [^]

Fixes Issue 29251:It is not possible to change currency in header tab in G/L Journal

As there is trigger mutating error, updation of gl journal line currency and
currency rate is moved to a event handler from gl_journal_trg trigger.

---
M src-db/database/model/triggers/GL_JOURNAL_TRG.xml
A src/org/openbravo/event/GLJournalEventHandler.java
---
(0075477)
hgbot   
2015-03-12 10:59   
Repository: erp/backports/3.0PR14Q3.8
Changeset: 21bece4bf36da3049408f04fc83e79b0ef05f1cb
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Mar 11 13:23:31 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/21bece4bf36da3049408f04fc83e79b0ef05f1cb [^]

Related to issue 29251: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

---
M src/org/openbravo/event/GLJournalEventHandler.java
---
(0075479)
aferraz   
2015-03-12 11:02   
Code review + Testing OK