Shipping Execution - EBS (MOSC)

MOSC Banner

WSH_EXCEPTION_PUB to purge and close exception

edited Nov 29, 2012 2:12AM in Shipping Execution - EBS (MOSC) 5 commentsAnswered
I am working to find a way to use WSH_EXCEPTION_PUB.EXCEPTION_ACTION to change status and/or purge closed exception.  What I want is to change status or purge a specify row  in WSH_EXCEPTIONS table.  But I always purge or change status more than 1 row.  I suspect I did not have the correct p_exception_rec value set.

For change_status, I set the p_exception_rec.exception_id and p_exception_rec.new_status.  I would expect only 1 row has changed status since exception_id is unique.  but the x_msg_count shows me 3 rows of data has change the status.  WHY?  How can I specify one row to change status?

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