Oracle Transportation Management (MOSC)

MOSC Banner

ASSIGN ORDER GENERAL LEDGER CODES Action is causing DB deadlocks

edited Jun 30, 2015 3:38PM in Oracle Transportation Management (MOSC) Question

Hi!

It appears that this action is trying to update Order Release Line's update time stamp and Order Release at the same time generating database deadlock.

We tried to use this action on an agent that fires when order release is created, we tried it on a shipment Secure Resources Accepted status change.  Now we are running a recurring process that looks for Order Releases without Buy Side GL and throws a custom event.  An agent is listening for that event and the only thing it does is to perform that action.  The Agent's Error Handler sends an email when it fails, so I get emails while the GL code actually is getting assigned.  Our DBAs are seeing deadlocks in the DB during this process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center