Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029110Openbravo ERP09. Financial managementpublic2015-03-03 12:252015-03-13 19:49
ReporterSandrahuguet 
Assigned ToAtulOpenbravo 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerNo
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
Summary0029110: 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
related to defect 00290923.0PR15Q2 closed AugustoMauch Data is not refreshed in form view after changing it with a trigger 
depends on backport 00292503.0PR15Q1.2 closed AtulOpenbravo It is not possible to change currency in header tab in G/L Journal 
depends on backport 00292513.0PR14Q3.8 closed AtulOpenbravo It is not possible to change currency in header tab in G/L Journal 
caused by defect 0025414 closed jecharri Wrong currency rate is applied when posting a GL Journal line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-03 12:25SandrahuguetNew Issue
2015-03-03 12:25SandrahuguetAssigned To => AtulOpenbravo
2015-03-03 12:25SandrahuguetOBNetwork customer => No
2015-03-03 12:25SandrahuguetModules => Core
2015-03-03 12:25SandrahuguetTriggers an Emergency Pack => No
2015-03-03 12:28SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=7824#r7824
2015-03-04 05:07AtulOpenbravoStatusnew => scheduled
2015-03-04 05:07AtulOpenbravofix_in_branch => pi
2015-03-06 10:07AtulOpenbravoNote Added: 0075230
2015-03-10 14:38aferrazRegression date => 2013-12-31
2015-03-10 14:38aferrazRegression introduced in release => 3.0MP31
2015-03-10 14:38aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/fcb87e990fcd [^]
2015-03-10 14:38aferrazfix_in_branchpi =>
2015-03-12 09:38aferrazRelationship addedrelated to 0029092
2015-03-12 10:08aferrazStatusscheduled => acknowledged
2015-03-12 10:08aferrazStatusacknowledged => scheduled
2015-03-12 10:30hgbotCheckin
2015-03-12 10:30hgbotNote Added: 0075469
2015-03-12 10:30hgbotStatusscheduled => resolved
2015-03-12 10:30hgbotResolutionopen => fixed
2015-03-12 10:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bb7b3752a14dcddad480dbbacb94fa64c3b31e63 [^]
2015-03-12 10:30hgbotCheckin
2015-03-12 10:30hgbotNote Added: 0075470
2015-03-12 10:31aferrazReview Assigned To => aferraz
2015-03-12 10:31aferrazNote Added: 0075471
2015-03-12 10:31aferrazStatusresolved => closed
2015-03-12 17:10hudsonbotCheckin
2015-03-12 17:10hudsonbotNote Added: 0075499
2015-03-12 17:10hudsonbotCheckin
2015-03-12 17:10hudsonbotNote Added: 0075500
2015-03-13 19:49dmitry_mezentsevRelationship addedcaused by 0025414

Notes
(0075230)
AtulOpenbravo   
2015-03-06 10:07   
Test Plan
- 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.
- Check that Journal Lines get updated properly as per conversion rate and there is no error as earlier.
(0075469)
hgbot   
2015-03-12 10:30   
Repository: erp/devel/pi
Changeset: bb7b3752a14dcddad480dbbacb94fa64c3b31e63
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 11 11:48:22 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/bb7b3752a14dcddad480dbbacb94fa64c3b31e63 [^]

Fixes Issue 29110: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
---
(0075470)
hgbot   
2015-03-12 10:30   
Repository: erp/devel/pi
Changeset: ac9670b7bfddfbe3831839948a7b70ce2d3e82e1
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Mar 11 13:23:31 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ac9670b7bfddfbe3831839948a7b70ce2d3e82e1 [^]

Related to issue 29110: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

---
M src/org/openbravo/event/GLJournalEventHandler.java
---
(0075471)
aferraz   
2015-03-12 10:31   
Code review + Testing ok
(0075499)
hudsonbot   
2015-03-12 17:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4f8a4e2f76d2 [^]
Maturity status: Test
(0075500)
hudsonbot   
2015-03-12 17:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4f8a4e2f76d2 [^]
Maturity status: Test