Payables and Cash Management - EBS (MOSC)

MOSC Banner

Alert for Invoices on Qty Holds

edited Apr 14, 2011 6:18AM in Payables and Cash Management - EBS (MOSC) 9 commentsAnswered
We are trying to use the Alert feature to send the seeded alert everytime a Qty Ord or Qty Rec is placed.  The problem we're seeing is that we have to use a timestamp to limit it to only the holds that were just placed rather than all holds in the ap_holds_all table.  And the problem with that is we can't limit it to just one notification per hold because it kicks off the alert for every insert into ap_holds_all that occurs within the determined timeframe. 

So we match an invoice and the system places 3 holds but only one is a Qty Ord hold.  Each hold is an insert which kicks off the alert and since the three holds were placed within the same timeframe the alert finds the one Qty Ord hold each time.  So there are 3 notifications because of the timeframe.

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