GST: Transact Sales order Error during back order ORA-20001: APP-20110: Encountered an error in JAI_WSH_TAX_DET_PKG.delete_line. ORA-04091:table WSH.WSH_DELIVERY_DETAILS is mutating, trigger/function may not see it. (Doc ID 2474339.1)

Last updated on OCTOBER 26, 2020

Applies to:

Symptoms

Reported Issue
-----------------

Error in back order sales order

ERROR
-----------------------
Move order Line could not be back ordered. Rolling back the changes.
Unexpected Error. Error in Routine
WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS, Oracle
Error--20001
ORA-20001: APP-20110: Encountered an error in JAI_WSH_TAX_DET_PKG.delete_line. ORA-04091:table WSH.WSH_DELIVERY_DETAILS is mutating, trigger/function may not see it.
ORA-06512: at "APPS.APP_EXCEPTION", line72
ORA-06512:at "APPS. JAI_OM_WDD_ARIUD_TRG",line535
ORA-04088:error during execution of trigger
'APPS.JAI_OM_WDD_ARIUD_TRG'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Back Order Sales order.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.