Friday, April 25, 2008

Oracle Service Contracts User Guide

Oracle Service contracts user guide can be found here

oks_reprocessing , query failed transactions

select order_number
from oks_reprocessing a
where a.success_flag = 'E' and order_number not in (Select nvl(source_header_ref,'11111') from csi_txn_errors)

List the orders that have failed in transaction and have an entry in the CSI_TXN_ERRORS table.