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!

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0003090) rafaroda (developer) 2008-01-25 10:58 edited on: 2008-06-12 09:24	Logged In: YES user_id=1892190 Originator: NO Duplicated in https://sourceforge.net/tracker/index.php?func=detail&aid=1879538&group_id=162271&atid=823129 [^]

(0006141) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1879534 [^]

Issue History
Date Modified	Username	Field	Change