Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024093Openbravo ERP03. Procurement managementpublic2013-06-16 12:512013-06-24 19:59
Reporterpramakrishnan 
Assigned Topramakrishnan 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2011-07-27
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/fb50d884949b4e2905923aab7cc567ac3557b6be [^]
Triggers an Emergency PackNo
Summary0024093: Error when deleting exchange rate in sales invoice in Oracle
DescriptionWhen trying to delete the exchange rate in sales invoice->exchange rate tab, the systems throws the error "ORA-01403: no data found ORA-06512: at "INT_FULL_ORACLE.C_CONVERSION_RATE_DOCUMENT_TRG", line 97 ORA-04088: error during execution of trigger 'INT_FULL_ORACLE.C_CONVERSION_RATE_DOCUMENT_TRG'"
Steps To ReproduceNavigate to Price List window
Change the currency of "Tarifa de ventas" to USD
Navigate to Sales Invoice
Create header for the business partner "Alimentos y Supermercados, S.A"
Add exchange rate in the exchange rate tab
Now, try to delete the record in the exchange rate tab
Notice that the system throws the above error.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-06-16 12:51pramakrishnanNew Issue
2013-06-16 12:51pramakrishnanAssigned To => dmiguelez
2013-06-16 12:51pramakrishnanWeb browser => Google Chrome
2013-06-16 12:51pramakrishnanModules => Core
2013-06-16 12:51pramakrishnanTriggers an Emergency Pack => No
2013-06-17 11:41pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-06-17 11:42pramakrishnanStatusnew => scheduled
2013-06-17 11:42pramakrishnanfix_in_branch => pi
2013-06-17 12:59pramakrishnanWeb browserGoogle Chrome => Google Chrome
2013-06-17 12:59pramakrishnanRegression level => Production - Confirmed Stable
2013-06-17 12:59pramakrishnanRegression date => 2011-07-27
2013-06-17 12:59pramakrishnanRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/fb50d884949b4e2905923aab7cc567ac3557b6be [^]
2013-06-17 12:59pramakrishnanfix_in_branchpi =>
2013-06-20 08:13pramakrishnanWeb browserGoogle Chrome => Google Chrome
2013-06-20 11:27hgbotCheckin
2013-06-20 11:27hgbotNote Added: 0059606
2013-06-20 11:27hgbotStatusscheduled => resolved
2013-06-20 11:27hgbotResolutionopen => fixed
2013-06-20 11:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8c63fd2601b07f257f6675baec83478d839d4fdf [^]
2013-06-20 11:31SandrahuguetReview Assigned To => Sandrahuguet
2013-06-20 11:31SandrahuguetNote Added: 0059608
2013-06-20 11:31SandrahuguetStatusresolved => closed
2013-06-24 19:59hudsonbotCheckin
2013-06-24 19:59hudsonbotNote Added: 0059647

Notes
(0059606)
hgbot   
2013-06-20 11:27   
Repository: erp/devel/pi
Changeset: 8c63fd2601b07f257f6675baec83478d839d4fdf
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Jun 17 17:00:40 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/8c63fd2601b07f257f6675baec83478d839d4fdf [^]

Fixes Issue 24093: Error when deleting exchange rate in sales invoice in Oracle

---
M src-db/database/model/triggers/C_CONVERSION_RATE_DOCUMENT_TRG.xml
---
(0059608)
Sandrahuguet   
2013-06-20 11:31   
Code review + testing OK
(0059647)
hudsonbot   
2013-06-24 19:59   
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/ceea5be911f3 [^]

Maturity status: Test