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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008759
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2009-04-24 13:022009-05-28 00:00
ReportersureshbabuView Statuspublic 
Assigned Togmauleon 
PrioritynormalResolutionfixedFixed in Version2.50MP2
StatusclosedFix in branchFixed in SCM revisioneb0a9b10ea92
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008759: Not able to delete a Sales invoice line item, if the line item is attached with an price adjustments.

DescriptionIf i tried to delete a Sales invoice line item and if the line item is attached with an price adjustments System throws the below message.

ORA-04091: table TAD_250.C_INVOICELINE_OFFER is mutating, trigger/function may not see it ORA-06512: at "TAD_250.C_INVOICELINE_TRG2", line 49 ORA-04088: error during execution of trigger 'TAD_250.C_INVOICELINE_TRG2'

Steps To Reproducestep 1: Move to price adjustments and click new
Master Data Management || Pricing || Price Adjustments || Adjustments
and enter
Name : any valid name,
Starting date : today's date
Discount % : 10
and other filters are set to not selected.


Move to Sales Invoice (Sales Management || Transactions || Sales Invoice || Header) and click new.
Select any BP and move to line tab
Select any Product and save. Check a new line item is added in price adjustment tab.
Move back to lines tab and click Delete Icon.

System throws error message as "ORA-04091: table TAD_250.C_INVOICELINE_OFFER is mutating, trigger/function may not see it ORA-06512: at "TAD_250.C_INVOICELINE_TRG2", line 49 ORA-04088: error during execution of trigger 'TAD_250.C_INVOICELINE_TRG2'" instead of deleting the message.




TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0008683 closedgmauleon A sales order line with a price adjustment cannot be delete 

-  Notes
(0015720)
rafaroda (viewer)
2009-04-24 17:58

 Repository: erp/devel/pi
Changeset: eb0a9b10ea9289877f33830468c363d3a57e92c1
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Fri Apr 24 17:31:58 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/eb0a9b10ea9289877f33830468c363d3a57e92c1 [^] [^]

Fixes bug 8683 A sales order line with price adjustment cannot be deleted

---
M src-db/database/model/tables/C_ORDERLINE_OFFER.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG2.xml

- Issue History
Date Modified Username Field Change
2009-04-24 13:02 sureshbabu New Issue
2009-04-24 13:02 sureshbabu Assigned To => rafaroda
2009-04-24 13:02 sureshbabu OBNetwork customer => No
2009-04-24 13:02 sureshbabu Regression testing => No
2009-04-24 13:57 rafaroda Relationship added related to 0008683
2009-04-24 17:57 rafaroda Assigned To rafaroda => gmauleon
2009-04-24 17:57 rafaroda Status new => scheduled
2009-04-24 17:58 rafaroda Status scheduled => resolved
2009-04-24 17:58 rafaroda Fixed in SCM revision => eb0a9b10ea9289877f33830468c363d3a57e92c1
2009-04-24 17:58 rafaroda Resolution open => fixed
2009-04-24 17:58 rafaroda Note Added: 0015720
2009-05-27 19:28 psarobe Status resolved => closed
2009-05-27 19:31 psarobe Fixed in Version => 2.50MP2
2009-05-28 00:00 anonymous sf_bug_id 0 => 2797619

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker