Friday, April 25, 2008

Oracle Service Contracts User Guide

›
Oracle Service contracts user guide can be found here
294 comments:

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,'11...
105 comments:
Thursday, March 27, 2008

Query Serial Number for an Order in Oracle

›
SELECT wl.meaning release_status      , wdd.released_status      , wdd.source_line_id      , wdd.source_code      , wser.fm_serial_number   ...
98 comments:
Friday, January 18, 2008

List all concurrent requests in Oracle

›
Use the following query to list all the concurrent requests in Oracle which are in errored or error status. Modify the query to get the rep...
58 comments:
Thursday, January 10, 2008

Custom.pll

›
Steps to convert/compile custom.pll files. Convert .pll to .pld f60gen MODULE=CUSTOM USERID=apps/sldfkjns5 MODULE_TYPE=LIBRARY SCRIPT=YES Co...
289 comments:
Monday, January 7, 2008

List Responsibilities by User in Oracle Apps eBusiness Suite.

›
List Responsibilities by User in Oracle Apps eBusiness Suite. Use the following query to list the responsibilities assigned to a particular ...
58 comments:
Thursday, January 3, 2008

Sys.xmlType datatype and parsing XML in Oracle9i, 10g onwards

›
Oracle9i onwards there is new datatype called sys.xmlType. This provides a great way to handle XML documents with minimal or no parsing requ...
436 comments: