Oracle CRM Blog
Friday, April 25, 2008
Oracle Service Contracts User Guide
›
Oracle Service contracts user guide can be found here
295 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...
103 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...
277 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 ...
59 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:
›
Home
View web version