Order Management - EBS (MOSC)

MOSC Banner

How to clear a hung message from the SFM queue?

There is a message ID that is hung in the SFM/XNP_MSG queue. If we start the SFM event manager service then rest of the messages in the queue are going through and new messages getting picked up a for while. Then the same hung message is holding up the queue.

The hung message is in Ready Status in XNP_MSG table and also present xnp.xnp_in_evt_qtab 

This is impacting our production environment. Any idea how to move the message out the queue so that rest of the transactions go through without any delay.

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