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:
Oracle Financials for India - Version 12.2 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |