Technology Stack - EBS (MOSC)

MOSC Banner

Oracle Alerts 12.0.4 causing blocking locks?

edited Aug 20, 2021 11:20AM in Technology Stack - EBS (MOSC) 7 commentsAnswered
 We have an Oracle Alert where the alert SQL searches order header table for blank attribute20.

Once it finds a blank attribute20, the alert action runs a SQL Update statement to update attribute20 with a scheduled ship date from the same row.

This alert runs every 30 minutes.

We are noticing that this alert Update statement is a suspect of blocking locks which in turn doesn't allow Order Administrators to query or update data in the system.

My question is does Oracle Alerts do any implicit or explicit locking of database objects when the action is an UPDATE statement on the same database object the alert SQL is on?

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