Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029251
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminorhave not tried2015-03-03 12:252015-03-12 11:02
ReporterSandrahuguetView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision74046f2ce82c
ProjectionnoneETAnoneTarget Version3.0PR14Q3.8
OSLinux 32 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0029251: 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'
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0029110 closedAtulOpenbravo It is not possible to change currency in header tab in G/L Journal 

-  Notes
(0075476)
hgbot (developer)
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 (developer)
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 (viewer)
2015-03-12 11:02

 Code review + Testing OK

- Issue History
Date Modified Username Field Change
2015-03-12 10:08 aferraz Type defect => backport
2015-03-12 10:08 aferraz Target Version => 3.0PR14Q3.8
2015-03-12 10:58 hgbot Checkin
2015-03-12 10:58 hgbot Note Added: 0075476
2015-03-12 10:59 hgbot Status scheduled => resolved
2015-03-12 10:59 hgbot Resolution open => fixed
2015-03-12 10:59 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/74046f2ce82c948cfaa4dc3659f5a7b5ee7963e4 [^]
2015-03-12 10:59 hgbot Checkin
2015-03-12 10:59 hgbot Note Added: 0075477
2015-03-12 11:02 aferraz Review Assigned To => aferraz
2015-03-12 11:02 aferraz Note Added: 0075479
2015-03-12 11:02 aferraz Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker