We might need to find the difference between two dates columns in hours/minutes in many cases. Like trying to find how long some program ran. One of the easiest way I found is
SELECT to_number( to_char(to_date('1','J') +
(date1 - date2), 'J') - 1) days,
to_char(to_date('00:00:00','HH24:MI:SS') +
(date1 - date2), 'HH24:MI:SS') time
FROM mytable;
Thursday, 2 December 2010
Progress Order Workflow Automatically.
In any implementation using Order Management Order Workflow errors are a common thing. And once you customize the workflow the pain is even more.
Sometimes the workflow gets struck of the errors might be momentary. Something like some service not available at that point of time.
Oracle provides a Automatic Retry program which does the job for us.
Program Name : Retry Activities in Error
Item Type : In most cases this happens to be 'OM Order Line' or else select accordingly.
Mode : Preview/Execute ,select Execute to commit/action the retry.
Subscribe to:
Posts (Atom)