Supply Chain Management - PSFT (MOSC)

MOSC Banner

Deadlock issues on the not-so-TAO table IN_RLS_DMD_TAO

edited May 16, 2015 12:03AM in Supply Chain Management - PSFT (MOSC) 1 comment

IN_RLS_DMD_TAO is an Inventory table that, despite the naming convention, is not actually defined as a temporary table.  As such, it does not follow the normal processing conventions that we are familiar with around TAO tables, ie: multiple instances defined, one instance used per active AE process, etc.

The design was intentional... certain multi-step jobs require continuity of the data state to complete, and there was no way to "hand-off" a specific temp TAO instance between the different processes.

Keeping this table around, and having multiple processes try to access the one instance, can have some unintended consequences.

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