orclpps.blogspot.com
Oracle CRM Blog: June 2007
http://orclpps.blogspot.com/2007_06_01_archive.html
Enter your search terms. Tuesday, June 19, 2007. Registering a table AD DD.register table in Oracle Applications 11i Ebusiness suite. Registering a table in Oracle Applications 11i Ebusiness suite to be used in Alerts and Flexfields. ADD DD.REGISTER TABLE. Ad ddregister table ( 'Application short name'. ADD DD.REGISTER COLUMN. Ad ddregister column ('Application short name',. EMAIL TEMPLATE ID',- Column. Setting proxy in UTL HTTP package method calls for Oracle 9i, 10g. Utl Http.Set Proxy (. Url = v url,.
orclpps.blogspot.com
Oracle CRM Blog: December 2006
http://orclpps.blogspot.com/2006_12_01_archive.html
Enter your search terms. Friday, December 29, 2006. Calling Web Services from Oracle 9i or 10g using UTL HTTP. Calling Web Services from Oracle 9i or 10g using UTL HTTP package in PLSQL. First Identify the webservice and the "envelope" that you need to post to the webservice using UTL HTTP post method. In this example, I am using the following WebService. Http:/ www.webservicex.net/stockquote.asmx? The WebService is expecting the following Envelope for the GetQuote Method. Http req utl http.req;. Xmlns:x...
orclpps.blogspot.com
Oracle CRM Blog: April 2008
http://orclpps.blogspot.com/2008_04_01_archive.html
Enter your search terms. Friday, April 25, 2008. Oracle Service Contracts User Guide. Oracle Service contracts user guide can be found here. Oks reprocessing , query failed transactions. 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. Subscribe to: Posts (Atom). Oracle Service Contracts User Guide. Carlos de la torre.
orclpps.blogspot.com
List all concurrent requests in Oracle - Oracle CRM Blog
http://orclpps.blogspot.com/2008/01/list-all-concurrent-requests-in-oracle.html
Enter your search terms. 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 reports that you want. Select a.request id,a.request date,b.user concurrent program name, a.requested by,a.responsibility application id, a.responsibility id,. And astatus code='E' and a.request date to date('13-jan-2008','DD-MON-YYYY') order by a.request date desc. I Agree. It...
orclpps.blogspot.com
Oracle CRM Blog: December 2007
http://orclpps.blogspot.com/2007_12_01_archive.html
Enter your search terms. Monday, December 31, 2007. FND GLOBAL.APPS INITIALIZE for initializing session in Oracle Ebusiness suite. FND GLOBAL.APPS INITIALIZE is used for initializing the session before calling any public or private API's in Oracle Ebusiness suite. Its not required for all the API's but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND GLOBAL.APPS INITIALIZE function. L resp id is the responsibility ID.
orclpps.blogspot.com
Oracle CRM Blog: January 2008
http://orclpps.blogspot.com/2008_01_01_archive.html
Enter your search terms. 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 reports that you want. Select a.request id,a.request date,b.user concurrent program name, a.requested by,a.responsibility application id, a.responsibility id,. And astatus code='E' and a.request date to date('13-jan-2008','DD-MON-YYYY') order by a.request date desc. SELECT FNDRESP&...
orclpps.blogspot.com
Oracle CRM Blog: March 2008
http://orclpps.blogspot.com/2008_03_01_archive.html
Enter your search terms. Thursday, March 27, 2008. Query Serial Number for an Order in Oracle. SELECT wl.meaning release status. Oeheader.sold to org id. FROM wsh delivery details wdd. OE ORDER LINES ALL oelines. Oe order headers all oeheader. Wsh serial numbers wser. WHERE 1 = 1. AND wl.lookup type = 'PICK STATUS'. AND wl.lookup code = wdd.released status. AND wdd.source code = 'OE'. AND wdd.source line id=oelines.line id. And oelines.header id = oeheader.header id. Subscribe to: Posts (Atom).