Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029250Openbravo ERP09. Financial managementpublic2015-03-03 12:252015-04-01 08:31
ReporterSandrahuguet 
Assigned ToAtulOpenbravo 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version 
Target Version3.0PR15Q1.2Fixed 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
Summary0029250: 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.0PR15Q1.2
2015-03-12 10:57hgbotCheckin
2015-03-12 10:57hgbotNote Added: 0075474
2015-03-12 10:57hgbotStatusscheduled => resolved
2015-03-12 10:57hgbotResolutionopen => fixed
2015-03-12 10:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/103d52a584bb3857ac81e84feb6d9980d96bb015 [^]
2015-03-12 10:57hgbotCheckin
2015-03-12 10:57hgbotNote Added: 0075475
2015-03-12 11:02aferrazReview Assigned To => aferraz
2015-03-12 11:02aferrazNote Added: 0075478
2015-03-12 11:02aferrazStatusresolved => closed
2015-04-01 08:06hgbotCheckin
2015-04-01 08:06hgbotNote Added: 0076208
2015-04-01 08:06hgbotStatusclosed => resolved
2015-04-01 08:06hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/103d52a584bb3857ac81e84feb6d9980d96bb015 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/103d52a584bb3857ac81e84feb6d9980d96bb015 [^]
2015-04-01 08:06hgbotCheckin
2015-04-01 08:06hgbotNote Added: 0076209
2015-04-01 08:31priyamStatusresolved => closed
2015-04-01 08:31priyamNote Added: 0076267

Notes
(0075474)
hgbot   
2015-03-12 10:57   
Repository: erp/backports/3.0PR15Q1.2
Changeset: 103d52a584bb3857ac81e84feb6d9980d96bb015
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.0PR15Q1.2/rev/103d52a584bb3857ac81e84feb6d9980d96bb015 [^]

Fixes Issue 29250: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
---
(0075475)
hgbot   
2015-03-12 10:57   
Repository: erp/backports/3.0PR15Q1.2
Changeset: a2a63be75a1bab1c0a96d1c18ce62d1ae42ce93b
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.0PR15Q1.2/rev/a2a63be75a1bab1c0a96d1c18ce62d1ae42ce93b [^]

Related to issue 29250: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

---
M src/org/openbravo/event/GLJournalEventHandler.java
---
(0075478)
aferraz   
2015-03-12 11:02   
Code review + Testing OK
(0076208)
hgbot   
2015-04-01 08:06   
Repository: erp/backports/3.0PR15Q2
Changeset: 103d52a584bb3857ac81e84feb6d9980d96bb015
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.0PR15Q2/rev/103d52a584bb3857ac81e84feb6d9980d96bb015 [^]

Fixes Issue 29250: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
---
(0076209)
hgbot   
2015-04-01 08:06   
Repository: erp/backports/3.0PR15Q2
Changeset: a2a63be75a1bab1c0a96d1c18ce62d1ae42ce93b
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.0PR15Q2/rev/a2a63be75a1bab1c0a96d1c18ce62d1ae42ce93b [^]

Related to issue 29250: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

---
M src/org/openbravo/event/GLJournalEventHandler.java
---
(0076267)
priyam   
2015-04-01 08:31   
closed again, as the status changed due the merge tag of 3.0PR15Q1.2 to backports/3.0PR15Q2