0002552: OBNETWORK: error fillign order ref. after copy lines on PO)

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0002552	Openbravo ERP	03. Procurement management	public	2008-01-25 10:50	2008-06-12 09:43

Reporter	egoitz
Assigned To	rafaroda
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	duplicate
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
Modules	Core
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0002552: OBNETWORK: error fillign order ref. after copy lines on PO)
Description	STEPS: an order reference after copy lines from on PO Procurement Managemente>Transactions>Purchase Order When we enter an order and do not fill-in an order reference, create lines for the order and then afterwards try to fill in the order reference, we get the following error: ORA-04091: table TAD.C_ORDER is mutating, trigger/function may not see it ORA-06512: at "TAD.C_ORDLINE_CHK_RESTRICTIONS_TRG", line 27 ORA-04088: error during execution of trigger 'TAD.C_ORDLINE_CHK_RESTRICTIONS_TRG' ORA-06512: at "TAD.C_ORDER_TRG", line 48 ORA-04088: error during execution of trigger 'TAD.C_ORDER_TRG' This error is explained by the following webpage: http://www.techonthenet.com/oracle/errors/ora04091.php [^] The reason is that the trigger C_ORDER_TRG updates the C_ORDERLINES table which triggers the C_ORDLINE_CHK_RESTRICTIONS_TRG trigger. The C_ORDLINE_CHK_RESTRICTIONS_TRG trigger makes a select to the C_ORDER table which is not allowed in this case because this table is being updated!
Steps To Reproduce
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change

Notes