tag:blogger.com,1999:blog-43656627391669688642024-03-28T20:29:50.549-07:00Oracle CRM BlogVenkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-4365662739166968864.post-4690125466207231982008-04-25T14:30:00.001-07:002008-04-25T14:30:05.240-07:00Oracle Service Contracts User Guide<p>Oracle Service contracts user guide can be found <a href="http://gurlx.com/6u">here</a></p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com295tag:blogger.com,1999:blog-4365662739166968864.post-32753783138453783062008-04-25T14:26:00.001-07:002008-04-25T14:26:06.075-07:00oks_reprocessing , query failed transactions<p>select order_number<br>from oks_reprocessing a<br>where a.success_flag = 'E' and order_number not in (Select nvl(source_header_ref,'11111') from csi_txn_errors) <p>List the orders that have failed in transaction and have an entry in the CSI_TXN_ERRORS table.</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com103tag:blogger.com,1999:blog-4365662739166968864.post-86778407484244714032008-03-27T14:49:00.001-07:002008-03-27T14:49:18.073-07:00Query Serial Number for an Order in Oracle<p>SELECT wl.meaning release_status<br> , wdd.released_status<br> , wdd.source_line_id<br> , wdd.source_code<br> , wser.fm_serial_number<br> , wser.TO_SERIAL_NUMBER<br> , wdd.CREATION_DATE<br> , oelines.header_id<br> , oeheader.sold_to_org_id<br> , wdd.shipped_quantity <br> , wdd.delivery_detail_id<br> FROM wsh_delivery_details wdd<br> , apps.wsh_lookups wl<br> , OE_ORDER_LINES_ALL oelines<br> , oe_order_headers_all oeheader<br> , wsh_serial_numbers wser<br> WHERE 1 = 1<br> AND wl.lookup_type = 'PICK_STATUS'<br> AND wl.lookup_code = wdd.released_status<br> AND wdd.source_code = 'OE'<br> AND wdd.source_line_id=oelines.line_id<br> and oelines.header_id = oeheader.header_id<br> AND WDD.DELIVERY_DETAIL_ID=wser.delivery_detail_id</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com99tag:blogger.com,1999:blog-4365662739166968864.post-60201101076099117332008-01-18T14:14:00.001-08:002008-01-18T14:14:14.586-08:00List all concurrent requests in Oracle<p>Use the following query to list all the concurrent requests in Oracle which are in errored or error status. </p> <p>Modify the query to get the reports that you want</p> <p>select a.request_id,a.request_date,b.user_concurrent_program_name, a.requested_by,a.responsibility_application_id, a.responsibility_id,<br> a.completion_text, a.logfile_name from FND_CONCURRENT_REQUESTS a, FND_CONCURRENT_PROGRAMS_TL b where a.concurrent_program_id=b.concurrent_program_id<br>and a.status_code='E' and a.request_date > to_date('13-jan-2008','DD-MON-YYYY') order by a.request_date desc</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com57tag:blogger.com,1999:blog-4365662739166968864.post-36236007398826937282008-01-10T14:03:00.001-08:002008-01-10T14:03:46.979-08:00Custom.pll<pre>Steps to convert/compile custom.pll files.</pre><pre>Convert .pll to .pld<br />f60gen MODULE=CUSTOM USERID=apps/sldfkjns5 MODULE_TYPE=LIBRARY SCRIPT=YES<br /><br />Convert .pld to .pll<br />f60gen MODULE=CUSTOM USERID=apps/sldfkjns5 MODULE_TYPE=LIBRARY PARSE=YES<br /><br />Compile all modules<br />f60gen MODULE=CUSTOM USERID=apps/sldfkjns5 MODULE_TYPE=LIBRARY <br />COMPILE_ALL=yes<br /><br />Copy the pll and plx back to $AU_TOP/resource<br />Then bounce forms port (f60down and f60up should not be used as because it kills existing connections)<br /></pre> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com277tag:blogger.com,1999:blog-4365662739166968864.post-46394358077460236112008-01-07T11:31:00.001-08:002008-01-07T11:31:04.562-08:00List Responsibilities by User in Oracle Apps eBusiness Suite.<p>List Responsibilities by User in Oracle Apps eBusiness Suite. Use the following query to list the responsibilities assigned to a particular user in Oracle Applications (Ebusiness Suite) <p>SELECT FNDRESP.* FROM fnd_user fnduser, fnd_user_resp_groups FNDRESPGROUP, fnd_responsibility_TL FNDRESP WHERE <br> fnduser.user_id=FNDRESPGROUP.user_id<br>AND FNDRESP.responsibility_id=FNDRESPGROUP.responsibility_id<br>and upper(fnduser.user_name) like upper('%your user%'); Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com59tag:blogger.com,1999:blog-4365662739166968864.post-19348935504874264572008-01-03T21:23:00.001-08:002008-01-03T21:25:03.062-08:00Sys.xmlType datatype and parsing XML in Oracle9i, 10g onwards<p>Oracle9i onwards there is new datatype called sys.xmlType. This provides a great way to handle XML documents with minimal or no parsing required.</p> <p>Listed below is a sample of how to use the xmlType.</p> <p>Step 1. Create Table of XML type</p> <blockquote> CREATE TABLE xml_table( xml_col SYS.XMLTYPE ); </blockquote> Step 2. Insert the following XML into the xml_table defined above <blockquote> <p><?xml version="1.0"?> <br /><email> <br />    <from>xyz@gmail.com</from> <br />    <to>xyz1@gmail.com</to> <br />    <subject>some subject</subject> <br />    <body>some body</body> <br /></email></p> <p>declare</p> <p>l_temp sys.xmlType;</p> <p>begin</p> <p>l_temp := sys.xmlType.createXML('</p> <?xml version="1.0"?> <br /><email> <br />    <from>xyz@gmail.com</from> <br />    <to>xyz1@gmail.com</to> <br />    <subject>some subject</subject> <br />    <body>some body</body> <br /></email>' <p>);</p> <p>insert into xml_table values ( l_Temp);</p> <p>Commit;</p> <p>end;</p> </blockquote> <p>Step 3. Write select query to extract data from this table. Sample extract query listed below.</p> <blockquote> <p>select a.xml_col.extract("//from/text()").getStringVal() as from from xml_table a</p></blockquote> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com437tag:blogger.com,1999:blog-4365662739166968864.post-47082004713951700472008-01-02T10:33:00.001-08:002008-01-02T10:33:54.187-08:00User Hooks in Oracle<p>User hooks provide the client with the ability to add logic to application processing and to disable optional product processing. These User Hooks take the form of procedures that may be called by the application, in sequence, when the application takes a specified action on a specified object type. <p>Not all the Oracle Applications API's have user hooks. The API's which have users hooks are listed in the following table <p>jtf_user_hooks. <p>So if you are looking to modify/customize a particular API, look for the that API in the the above table. <p>For example, <p>select * from jtf_user_hooks where API_NAME = 'CANCEL_ORDER' <p>Just like triggers, User Hooks can be made to fire pre/post. In order to set a user hook as active , the execute flag has to be set to 'Y'. </p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com42tag:blogger.com,1999:blog-4365662739166968864.post-38496420616105032182007-12-31T21:13:00.001-08:002007-12-31T21:13:31.594-08:00FND_GLOBAL.APPS_INITIALIZE for initializing session in Oracle Ebusiness suite<p>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. </p> <p>Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function</p> <p>fnd_global.APPS_INITIALIZE(user_id=>l_user_id, <br />                                                   resp_id=>l_resp_id, <br />                                                resp_appl_id=>l_resp_appl_id);</p> <ol> <li>l_user_id is the fnd user ID which will be utilized during the call.</li> <li>l_resp_id is the responsibility ID</li> <li>l_resp_appl_id is the responsibility application ID.</li> </ol> <p>You can use either sysadmin or use some user who has all the above listed responsibilities.</p> <p>For SYSADMIN, utilize the following query to get the respective values</p> <p>select fnd.user_id , <br />       fresp.responsibility_id, <br />       fresp.application_id <br />from   fnd_user fnd <br />,      fnd_responsibility_tl fresp <br />where  fnd.user_name = 'SYSADMIN' <br />and    fresp.responsibility_name = 'Order Management Super User';</p> <p>Another option is Help > Diagnostics > Examine and get the values from $profile session values.</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com50tag:blogger.com,1999:blog-4365662739166968864.post-38276486931532682862007-12-30T21:11:00.001-08:002007-12-30T21:15:25.161-08:00Business Events Oracle, step by step guide<p>Business Events Oracle, step by step guide.</p> <p>Described below is a sample of setting up Business Events in Oracle Applications ( 11.5.10) onwards. </p> <p>The first step to setting up business events is to making sure you have the right responsibilities. You will have to request the system administrator to provide you "Work Flow Administrator" responsibility.</p> <p>Work Flow Administrator --> Business Events --> Search</p> <p><a href="http://lh3.google.com/venkatesh.rangarajan/R3h6BxJ7iUI/AAAAAAAAAgU/QSNJIOzSE-8/Image1%5B2%5D"><img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="89" alt="Image1" src="http://lh4.google.com/venkatesh.rangarajan/R3h6CBJ7iVI/AAAAAAAAAgc/VHhMURNO_dE/Image1_thumb" width="244" border="0" /></a> </p> <p>Search for the events you want to attach custom logic to. In this example, the event used is </p> <p>oracle.apps.jtf.cac.task.createTask</p> <p>Each time a new task gets created the events will get triggered. Attach the custom pl/sql function that you want to fire associated with this event.</p> <p><a href="http://lh6.google.com/venkatesh.rangarajan/R3h6ChJ7iWI/AAAAAAAAAgk/-9vSTrxTBvE/Image2%5B2%5D"><img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="164" alt="Image2" src="http://lh3.google.com/venkatesh.rangarajan/R3h6CxJ7iXI/AAAAAAAAAgs/q0-7kyBA44Y/Image2_thumb" width="244" border="0" /></a> </p> <p>Now the next step is defining the custom function handling the logic. The standard signature of all subscription functions is</p> <p>myfunc(p_guid in RAW, p_event in ou noCopy WF_EVENT_T) return varchar2.</p> <p>You can get the values passed by the event using GeValueForParameter();</p> <p>CREATE OR REPLACE PACKAGE BODY APPS.test_BE_Pkg IS</p> <p>FUNCTION my_test_task_business_event(p_subscrition_guid IN RAW,</p> <p>p_event IN OUT NOCOPY WF_EVENT_T )RETURN VARCHAR2 IS</p> <p>l_task_id NUMBER;</p> <p>l_task_status VARCHAR2(30);</p> <p>l_task_num VARCHAR2(30);</p> <p>l_event_name VARCHAR2(240) := p_event.getEventName();</p> <p>BEGIN</p> <p>l_task_id := p_event.GetValueForParameter('TASK_ID');</p> <p>INSERT INTO my_temp VALUES ( l_task_id ,l_task_id);</p> <p>COMMIT;</p> <p>SELECT sts.NAME,</p> <p>a.task_number </p> <p>INTO l_task_status ,</p> <p>l_task_num</p> <p>FROM jtf_task_statuses_vl sts,</p> <p>jtf_tasks_b a</p> <p>WHERE a.task_id = l_task_id</p> <p>AND a.task_status_id = sts.task_status_id;</p> <p>INSERT INTO my_temp VALUES(l_task_num,l_task_status);</p> <p>RETURN 'SUCCESS';</p> <p>COMMIT;</p> <p>END my_test_task_business_event;</p> <p>END test_BE_Pkg;</p> <p>/</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com11tag:blogger.com,1999:blog-4365662739166968864.post-77058281022984613022007-12-28T17:27:00.001-08:002007-12-28T17:35:37.366-08:00Invoking WebServices From Oracle 9i or 10g using UTL_HTTP<p>Invoking WebServices From Oracle 9i or 10g using UTL_HTTP</p> <p>Here is the a very simple method to invoke WebServices from Oracle 9i or 10g using the UTL_HTTP method. </p> <ul> <li>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 <blockquote> <p><a title="http://www.webservicex.net/stockquote.asmx?op=GetQuote" href="http://www.webservicex.net/stockquote.asmx?op=GetQuote">http://www.webservicex.net/stockquote.asmx?op=GetQuote</a></p> <p>The WebService is expecting the following Envelope for the GetQuote Method</p></blockquote> <blockquote><pre><?xml version="1.0" encoding="utf-8"?><br /><soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><br /> <soap:Body><br /> <GetQuote xmlns="http://www.webserviceX.NET/"><br /> <symbol>string</symbol><br /> </GetQuote><br /> </soap:Body><br /></soap:Envelope></pre></blockquote><br /><li>PL/SQL routine for invoking the webservice <br /><p>create or replace FUNCTION WS_QUOTE( symbol in varchar2) RETURN sys.xmltype<br>as<br> env VARCHAR2(32767);<br> http_req utl_http.req;<br> http_resp utl_http.resp;<br> resp sys.xmltype;<br> in_xml sys.xmltype;<br> url varchar2(2000):='<a href="http://www.webservicex.net/stockquote.asmx?WSDL';">http://www.webservicex.net/stockquote.asmx?WSDL';</a><br> BEGIN<br>-- generate_envelope(req, env);<br> env:='<?xml version="1.0" encoding="utf-8"?><br><soap:Envelope xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance"">http://www.w3.org/2001/XMLSchema-instance"</a> xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema"">http://www.w3.org/2001/XMLSchema"</a> xmlns:soap="<a href="http://schemas.xmlsoap.org/soap/envelope/"">http://schemas.xmlsoap.org/soap/envelope/"</a>><br> <soap:Body><br> <GetQuote xmlns="<a href="http://www.webserviceX.NET/"">http://www.webserviceX.NET/"</a>><br> <symbol>' || symbol || '</symbol><br> </GetQuote><br> </soap:Body><br></soap:Envelope>';<br> http_req := utl_http.begin_request(url, 'POST','HTTP/1.1');<br> utl_http.set_body_charset(http_req, 'UTF-8');<br>-- utl_http.set_proxy('proxy:80', NULL);<br>-- utl_http.set_persistent_conn_support(TRUE);<br>-- UTL_HTTP.set_authentication(http_req, '', '3', 'Basic', TRUE );<br> utl_http.set_header(http_req, 'Content-Type', 'text/xml');<br> utl_http.set_header(http_req, 'Content-Length', length(env));<br> utl_http.set_header(http_req, 'SOAPAction', '<a href="http://www.webserviceX.NET/GetQuote');">http://www.webserviceX.NET/GetQuote');</a><br> utl_http.write_text(http_req, env);<br> http_resp := utl_http.get_response(http_req);<br> utl_http.read_text(http_resp, env);<br> utl_http.end_response(http_resp);<br> in_xml := sys.xmltype.createxml(env);<br> resp := xmltype.createxml(env);<br> dbms_output.put_line('same output');<br> dbms_output.put_line(SUBSTR(env, 1, 245));<br> RETURN resp;<br> END; </p></li></ul>Observe here that SYMBOL is the only parameter required for this function. All other is required just to create the envelope. <br /><ul><br /><li><br /><div align="left">Sample extract Query for extracting the information</div></li></ul><br /><p>select extract(ws_quote('GOOG'),'//GetQuoteResult/text()',</p><br /><p>'xmlns:soap="<a href="http://schemas.xmlsoap.org/soap/envelope/"').getStringVal()">http://schemas.xmlsoap.org/soap/envelope/"').getStringVal()</a> from dual</p><br /><p>Using this technique, all webservices calls are reduced to simple queries in the database and can be used to virtualize the database. </p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com8tag:blogger.com,1999:blog-4365662739166968864.post-284107531358866622007-12-28T12:24:00.001-08:002007-12-28T12:30:24.096-08:00Oracle Applications 11i Modules and their Short Names (Abbreviations)<p>Oracle Applications 11i Modules and their Short Names (Abbreviations)</p> <p>Listed below are the various Oracle Application Modules, their short names and their App ID for reference </p> <table> <tbody> <tr> <td>APPLICATION_SHORT_NAME</td> <td>APPLICATION_ID</td> <td>APPLICATION_NAME</td></tr> <tr> <td>FND</td> <td>0</td> <td>Application Object Library</td></tr> <tr> <td>SYSADMIN</td> <td>1</td> <td>System Administration</td></tr> <tr> <td>AU</td> <td>3</td> <td>Application Utilities</td></tr> <tr> <td>AD</td> <td>50</td> <td>Applications DBA</td></tr> <tr> <td>SHT</td> <td>60</td> <td>Applications Shared Technology</td></tr> <tr> <td>SQLGL</td> <td>101</td> <td>General Ledger</td></tr> <tr> <td>OFA</td> <td>140</td> <td>Assets</td></tr> <tr> <td>ALR</td> <td>160</td> <td>Alert</td></tr> <tr> <td>RG</td> <td>168</td> <td>Application Report Generator</td></tr> <tr> <td>CS</td> <td>170</td> <td>Service</td></tr> <tr> <td>CCT</td> <td>172</td> <td>Telephony Manager</td></tr> <tr> <td>ECX</td> <td>174</td> <td>XML Gateway</td></tr> <tr> <td>EC</td> <td>175</td> <td>e-Commerce Gateway</td></tr> <tr> <td>ICX</td> <td>178</td> <td>Self-Service Web Applications</td></tr> <tr> <td>XTR</td> <td>185</td> <td>Treasury</td></tr> <tr> <td>AZ</td> <td>190</td> <td>Application Implementation</td></tr> <tr> <td>BIS</td> <td>191</td> <td>Applications BIS</td></tr> <tr> <td>SQLAP</td> <td>200</td> <td>Payables</td></tr> <tr> <td>PO</td> <td>201</td> <td>Purchasing</td></tr> <tr> <td>CHV</td> <td>202</td> <td>Supplier Scheduling</td></tr> <tr> <td>AR</td> <td>222</td> <td>Receivables</td></tr> <tr> <td>PN</td> <td>240</td> <td>Property Manager</td></tr> <tr> <td>QA</td> <td>250</td> <td>Quality</td></tr> <tr> <td>CE</td> <td>260</td> <td>Cash Management</td></tr> <tr> <td>FRM</td> <td>265</td> <td>Report Manager</td></tr> <tr> <td>EAA</td> <td>270</td> <td>SEM Exchange</td></tr> <tr> <td>BSC</td> <td>271</td> <td>Balanced Scorecard</td></tr> <tr> <td>ABM</td> <td>272</td> <td>Activity Based Management</td></tr> <tr> <td>EVM</td> <td>273</td> <td>Value Based Management</td></tr> <tr> <td>FEM</td> <td>274</td> <td>Strategic Enterprise Management</td></tr> <tr> <td>PA</td> <td>275</td> <td>Projects</td></tr> <tr> <td>AS</td> <td>279</td> <td>Sales Foundation</td></tr> <tr> <td>CN</td> <td>283</td> <td>Incentive Compensation</td></tr> <tr> <td>POM</td> <td>298</td> <td>Exchange</td></tr> <tr> <td>OE</td> <td>300</td> <td>Order Entry</td></tr> <tr> <td>WMS</td> <td>385</td> <td>Warehouse Management</td></tr> <tr> <td>WPS</td> <td>388</td> <td>Manufacturing Scheduling</td></tr> <tr> <td>INV</td> <td>401</td> <td>Inventory</td></tr> <tr> <td>MWA</td> <td>405</td> <td>Mobile Applications</td></tr> <tr> <td>WSM</td> <td>410</td> <td>Shop Floor Management</td></tr> <tr> <td>FII</td> <td>450</td> <td>Financial Intelligence</td></tr> <tr> <td>OPI</td> <td>451</td> <td>Operations Intelligence</td></tr> <tr> <td>POA</td> <td>452</td> <td>Purchasing Intelligence</td></tr> <tr> <td>HRI</td> <td>453</td> <td>Human Resources Intelligence</td></tr> <tr> <td>ISC</td> <td>454</td> <td>Supply Chain Intelligence</td></tr> <tr> <td>OKC</td> <td>510</td> <td>Contracts Core</td></tr> <tr> <td>CSC</td> <td>511</td> <td>Customer Care</td></tr> <tr> <td>CSD</td> <td>512</td> <td>Depot Repair</td></tr> <tr> <td>CSF</td> <td>513</td> <td>Field Service</td></tr> <tr> <td>CSS</td> <td>514</td> <td>Support</td></tr> <tr> <td>OKS</td> <td>515</td> <td>Service Contracts</td></tr> <tr> <td>ME</td> <td>516</td> <td>Controlled Availability Product</td></tr> <tr> <td>BIM</td> <td>517</td> <td>Marketing Intelligence</td></tr> <tr> <td>BIC</td> <td>518</td> <td>Customer Intelligence</td></tr> <tr> <td>IES</td> <td>519</td> <td>Scripting</td></tr> <tr> <td>AMV</td> <td>520</td> <td>Marketing Encyclopedia System</td></tr> <tr> <td>AST</td> <td>521</td> <td>TeleSales</td></tr> <tr> <td>ASF</td> <td>522</td> <td>Sales Online</td></tr> <tr> <td>CSP</td> <td>523</td> <td>Spares Management</td></tr> <tr> <td>OKX</td> <td>524</td> <td>Contracts Integration</td></tr> <tr> <td>AMS</td> <td>530</td> <td>Marketing</td></tr> <tr> <td>XNM</td> <td>531</td> <td>Marketing for Communications</td></tr> <tr> <td>XNC</td> <td>532</td> <td>Sales for Communications</td></tr> <tr> <td>XNS</td> <td>533</td> <td>Service for Communications</td></tr> <tr> <td>XNP</td> <td>534</td> <td>Number Portability</td></tr> <tr> <td>XDP</td> <td>535</td> <td>Provisioning</td></tr> <tr> <td>FPT</td> <td>538</td> <td>Banking Center</td></tr> <tr> <td>IEO</td> <td>539</td> <td>Interaction Center Technology</td></tr> <tr> <td>GMA</td> <td>550</td> <td>Process Manufacturing Systems</td></tr> <tr> <td>GMI</td> <td>551</td> <td>Process Manufacturing Inventory</td></tr> <tr> <td>GMD</td> <td>552</td> <td>Process Manufacturing Product Development</td></tr> <tr> <td>GME</td> <td>553</td> <td>Process Manufacturing Process Execution</td></tr> <tr> <td>GMP</td> <td>554</td> <td>Process Manufacturing Process Planning</td></tr> <tr> <td>GMF</td> <td>555</td> <td>Process Manufacturing Financials</td></tr> <tr> <td>GML</td> <td>556</td> <td>Process Manufacturing Logistics</td></tr> <tr> <td>GR</td> <td>557</td> <td>Process Manufacturing Regulatory Management</td></tr> <tr> <td>PMI</td> <td>558</td> <td>Process Manufacturing Intelligence</td></tr> <tr> <td>AX</td> <td>600</td> <td>Global Accounting Engine</td></tr> <tr> <td>AK</td> <td>601</td> <td>Common Modules-AK</td></tr> <tr> <td>XLA</td> <td>602</td> <td>Subledger Accounting</td></tr> <tr> <td>ONT</td> <td>660</td> <td>Order Management</td></tr> <tr> <td>QP</td> <td>661</td> <td>Advanced Pricing</td></tr> <tr> <td>RLM</td> <td>662</td> <td>Release Management</td></tr> <tr> <td>VEA</td> <td>663</td> <td>Automotive</td></tr> <tr> <td>WSH</td> <td>665</td> <td>Shipping Execution</td></tr> <tr> <td>IBA</td> <td>670</td> <td>iMarketing</td></tr> <tr> <td>IBE</td> <td>671</td> <td>iStore</td></tr> <tr> <td>IBU</td> <td>672</td> <td>iSupport</td></tr> <tr> <td>IBY</td> <td>673</td> <td>iPayment</td></tr> <tr> <td>IBP</td> <td>674</td> <td>Bill Presentment & Payment</td></tr> <tr> <td>BIL</td> <td>676</td> <td>Sales Intelligence</td></tr> <tr> <td>BIX</td> <td>677</td> <td>Interaction Center Intelligence</td></tr> <tr> <td>IEM</td> <td>680</td> <td>Email Center</td></tr> <tr> <td>OZP</td> <td>681</td> <td>Trade Planning</td></tr> <tr> <td>OZF</td> <td>682</td> <td>Trade Management</td></tr> <tr> <td>OZS</td> <td>683</td> <td>iClaims</td></tr> <tr> <td>ASG</td> <td>689</td> <td>CRM Gateway for Mobile Devices</td></tr> <tr> <td>JTF</td> <td>690</td> <td>CRM Foundation</td></tr> <tr> <td>IEX</td> <td>695</td> <td>Collections</td></tr> <tr> <td>IEU</td> <td>696</td> <td>Universal Work Queue</td></tr> <tr> <td>ASO</td> <td>697</td> <td>Order Capture</td></tr> <tr> <td>CSR</td> <td>698</td> <td>Scheduler</td></tr> <tr> <td>IEB</td> <td>699</td> <td>Interaction Blending</td></tr> <tr> <td>MFG</td> <td>700</td> <td>Manufacturing</td></tr> <tr> <td>BOM</td> <td>702</td> <td>Bills of Material</td></tr> <tr> <td>ENG</td> <td>703</td> <td>Engineering</td></tr> <tr> <td>MRP</td> <td>704</td> <td>Master Scheduling/MRP</td></tr> <tr> <td>CRP</td> <td>705</td> <td>Capacity</td></tr> <tr> <td>WIP</td> <td>706</td> <td>Work in Process</td></tr> <tr> <td>CZ</td> <td>708</td> <td>Configurator</td></tr> <tr> <td>RLA</td> <td>710</td> <td>Release Management Integration Kit</td></tr> <tr> <td>VEH</td> <td>711</td> <td>Automotive Integration Kit</td></tr> <tr> <td>PJM</td> <td>712</td> <td>Project Manufacturing</td></tr> <tr> <td>FLM</td> <td>714</td> <td>Flow Manufacturing</td></tr> <tr> <td>MSD</td> <td>722</td> <td>Demand Planning</td></tr> <tr> <td>MSO</td> <td>723</td> <td>Constraint Based Optimization</td></tr> <tr> <td>MSC</td> <td>724</td> <td>Advanced Supply Chain Planning</td></tr> <tr> <td>RHX</td> <td>725</td> <td>Advanced Planning Foundation</td></tr> <tr> <td>OKE</td> <td>777</td> <td>Project Contracts</td></tr> <tr> <td>PER</td> <td>800</td> <td>Human Resources</td></tr> <tr> <td>PAY</td> <td>801</td> <td>Payroll</td></tr> <tr> <td>FF</td> <td>802</td> <td>FastFormula</td></tr> <tr> <td>DT</td> <td>803</td> <td>DateTrack</td></tr> <tr> <td>SSP</td> <td>804</td> <td>SSP</td></tr> <tr> <td>BEN</td> <td>805</td> <td>Advanced Benefits</td></tr> <tr> <td>HXT</td> <td>808</td> <td>Time and Labor</td></tr> <tr> <td>HXC</td> <td>809</td> <td>Time and Labor Engine</td></tr> <tr> <td>OTA</td> <td>810</td> <td>Learning Management</td></tr> <tr> <td>JA</td> <td>7000</td> <td>Asia/Pacific Localizations</td></tr> <tr> <td>JE</td> <td>7002</td> <td>European Localizations</td></tr> <tr> <td>JG</td> <td>7003</td> <td>Regional Localizations</td></tr> <tr> <td>JL</td> <td>7004</td> <td>Latin America Localizations</td></tr> <tr> <td>GHR</td> <td>8301</td> <td>US Federal Human Resources</td></tr> <tr> <td>PQH</td> <td>8302</td> <td>Public Sector HR</td></tr> <tr> <td>PQP</td> <td>8303</td> <td>Public Sector Payroll</td></tr> <tr> <td>PSB</td> <td>8401</td> <td>Public Sector Budgeting</td></tr> <tr> <td>GMS</td> <td>8402</td> <td>Grants Accounting</td></tr> <tr> <td>PSP</td> <td>8403</td> <td>Labor Distribution</td></tr> <tr> <td>IGW</td> <td>8404</td> <td>Grants Proposal</td></tr> <tr> <td>IGS</td> <td>8405</td> <td>Student Systems</td></tr> <tr> <td>IGF</td> <td>8406</td> <td>Financial Aid</td></tr> <tr> <td>IGC</td> <td>8407</td> <td>Contract Commitment</td></tr> <tr> <td>PSA</td> <td>8450</td> <td>Public Sector Financials</td></tr> <tr> <td>IPA</td> <td>8721</td> <td>Capital Resource Logistics - Projects</td></tr> <tr> <td>CUI</td> <td>8722</td> <td>Network Logistics - Inventory</td></tr> <tr> <td>CUP</td> <td>8723</td> <td>Network Logistics - Purchasing</td></tr> <tr> <td>CUF</td> <td>8724</td> <td>Capital Resource Logistics - Financials</td></tr> <tr> <td>CUS</td> <td>8727</td> <td>Network Logistics</td></tr> <tr> <td>CUN</td> <td>8729</td> <td>Network Logistics - NATS</td></tr> <tr> <td>CUA</td> <td>8731</td> <td>Capital Resource Logistics - Assets</td></tr> <tr> <td>FV</td> <td>8901</td> <td>Federal Financials</td></tr> <tr> <td>IMC</td> <td>879</td> <td>Customers Online</td></tr> <tr> <td>XNI</td> <td>872</td> <td>Install Base Intelligence</td></tr> <tr> <td>POS</td> <td>177</td> <td>iSupplier Portal</td></tr> <tr> <td>AHM</td> <td>864</td> <td>Hosting Manager</td></tr> <tr> <td>ASP</td> <td>869</td> <td>Field Sales/Palm Devices</td></tr> <tr> <td>BIV</td> <td>862</td> <td>Service Intelligence</td></tr> <tr> <td>CSI</td> <td>542</td> <td>Install Base</td></tr> <tr> <td>PV</td> <td>691</td> <td>Partner Management</td></tr> <tr> <td>ASL</td> <td>544</td> <td>Sales Offline</td></tr> <tr> <td>EAM</td> <td>426</td> <td>Enterprise Asset Management</td></tr> <tr> <td>FTE</td> <td>716</td> <td>Transportation Execution</td></tr> <tr> <td>IGI</td> <td>8400</td> <td>Public Sector Financials International</td></tr> <tr> <td>ITG</td> <td>230</td> <td>Internet Procurement Enterprise Connector</td></tr> <tr> <td>MSR</td> <td>726</td> <td>Inventory Optimization</td></tr> <tr> <td>IPD</td> <td>420</td> <td>Product Development</td></tr> <tr> <td>ENI</td> <td>455</td> <td>Product Intelligence</td></tr> <tr> <td>CUE</td> <td>543</td> <td>Billing Connect</td></tr> <tr> <td>OKR</td> <td>541</td> <td>Contracts for Rights</td></tr> <tr> <td>IZU</td> <td>278</td> <td>Oracle Support Diagnostic Tools</td></tr> <tr> <td>CSL</td> <td>868</td> <td>Field Service/Laptop</td></tr> <tr> <td>CUG</td> <td>866</td> <td>Citizen Interaction Center</td></tr> <tr> <td>IMT</td> <td>861</td> <td>iMeeting (obsolete)</td></tr> <tr> <td>OKI</td> <td>870</td> <td>Contracts Intelligence</td></tr> <tr> <td>IEC</td> <td>545</td> <td>Advanced Outbound Telephony</td></tr> <tr> <td>CSE</td> <td>873</td> <td>Enterprise Install Base</td></tr> <tr> <td>OKO</td> <td>871</td> <td>Contracts for Sales</td></tr> <tr> <td>JTS</td> <td>875</td> <td>CRM Self Service Administration</td></tr> <tr> <td>JTM</td> <td>874</td> <td>Mobile Application Foundation</td></tr> <tr> <td>AHL</td> <td>867</td> <td>Complex Maintenance Repair and Overhaul</td></tr> <tr> <td>OKB</td> <td>865</td> <td>Contracts for Subscriptions (obsolete)</td></tr> <tr> <td>BNE</td> <td>231</td> <td>Web Applications Desktop Integrator</td></tr> <tr> <td>QRM</td> <td>186</td> <td>Risk Management</td></tr> <tr> <td>PON</td> <td>396</td> <td>Sourcing</td></tr> <tr> <td>OKL</td> <td>540</td> <td>Lease Management</td></tr> <tr> <td>IBC</td> <td>549</td> <td>Content Manager</td></tr> <tr> <td>AMF</td> <td>882</td> <td>Fulfillment Services</td></tr> <tr> <td>QOT</td> <td>880</td> <td>Quoting</td></tr> <tr> <td>CSM</td> <td>883</td> <td>Field Service/Palm</td></tr> <tr> <td>DOM</td> <td>432</td> <td>Document Managment and Collaboration</td></tr> <tr> <td>EGO</td> <td>431</td> <td>Advanced Product Catalog</td></tr> <tr> <td>DDD</td> <td>430</td> <td>CADView-3D</td></tr> <tr> <td>PJI</td> <td>1292</td> <td>Project Intelligence</td></tr> <tr> <td>XDO</td> <td>603</td> <td>XML Publisher</td></tr> <tr> <td>XNB</td> <td>881</td> <td>eBusiness Billing</td></tr> <tr> <td>ZFA</td> <td>505</td> <td>Financial Analyzer</td></tr> <tr> <td>ZSA</td> <td>506</td> <td>Sales Analyzer</td></tr> <tr> <td>CLN</td> <td>701</td> <td>Supply Chain Trading Connector for RosettaNet</td></tr> <tr> <td>EDR</td> <td>709</td> <td>E-Records</td></tr> <tr> <td>PRP</td> <td>694</td> <td>Proposals</td></tr> <tr> <td>AMW</td> <td>242</td> <td>Internal Controls Manager</td></tr> <tr> <td>XLE</td> <td>204</td> <td>Legal Entity Configurator</td></tr> <tr> <td>ASN</td> <td>280</td> <td>Sales</td></tr> <tr> <td>MST</td> <td>390</td> <td>Transportation Planning</td></tr> <tr> <td>FUN</td> <td>435</td> <td>Financials Common Modules</td></tr> <tr> <td>GCS</td> <td>266</td> <td>Global Consolidation System</td></tr> <tr> <td>ZX</td> <td>235</td> <td>E-Business Tax</td></tr> <tr> <td>LNS</td> <td>206</td> <td>Loans</td></tr> <tr> <td>IA</td> <td>205</td> <td>iAssets</td></tr> <tr> <td>FPA</td> <td>440</td> <td>Portfolio Analyzer</td></tr> <tr> <td>ZPB</td> <td>210</td> <td>Enterprise Planning and Budgeting</td></tr></tbody></table> <p> </p> <p>Use the following query to retrieve this information on your specific instance.</p> <p>SELECT FND.APPLICATION_ID, APPLICATION_SHORT_NAME, PRODUCT_CODE, APPLICATION_NAME<br> FROM FND_APPLICATION FND , FND_APPLICATION_TL FNDTL WHERE FND.APPLICATION_ID=FNDTL.APPLICATION_ID</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com306tag:blogger.com,1999:blog-4365662739166968864.post-50450244306551223162007-12-20T16:27:00.001-08:002007-12-20T16:27:14.310-08:00Tracking Oracle Installed base error transactions<p>Most of the Oracle Installed base error transactions reside in </p> <p>csi_txn_errors table. source_header_ref_id is nothing but the order header ID. In case it is required to get the IB failed transactions based on the order number, one can utilize the following query. <p>select * from csi_txn_errors csie, oe_order_headers_all_b oedh where <br>csie.source_header_ref_id = oedh.header_id and oedh.order_number= &order_number</p> Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com5tag:blogger.com,1999:blog-4365662739166968864.post-1039894609618717082007-06-19T18:28:00.001-07:002007-07-02T14:28:36.594-07:00Registering a table AD_DD.register_table in Oracle Applications 11i Ebusiness suite<p>Registering a table in Oracle Applications 11i Ebusiness suite to be used in Alerts and Flexfields</p> <p>Flexfields and Oracle Alert are the only features or products that require the custom tables to be registered in Oracle Applications (Application Object Library) before they can be used. Custom application tables can be registered by using the AD_DD PL/SQL Package. If you are planning to use custom tables either in Alerts or in Flexfields, they need to be registered. The following methods describe how you can register the tables.</p> <ul> <li><strong>ADD_DD.REGISTER_TABLE</strong></li></ul> <blockquote><pre class="csharpcode">ad_dd.register_table (<span class="str">'Application short name'</span>, <span class="str">'EMAIL_TEMPLATES'</span>, <span class="str">'T'</span>);</pre></blockquote><br /><ul><br /><li><strong>ADD_DD.REGISTER_COLUMN</strong></li></ul><br /><blockquote><br /><p><em>ad_dd.register_column ('Application short name',<br>'EMAIL_TEMPLATES',<br>'EMAIL_TEMPLATE_ID',--Column<br>1,--Sequence<br>'number',--type<br>4,--width<br>'N',<br>'N'<br>);<br></em><em></em></p><em></em></blockquote><br /><ul><br /><li><em>Register all the columns one by one . Now you can use these custom table in your flex field definitions and in Oracle Alerts</em></li></ul>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com381tag:blogger.com,1999:blog-4365662739166968864.post-31599982503313720752007-06-19T07:52:00.001-07:002007-06-20T09:43:24.075-07:00Setting proxy in UTL_HTTP package method calls for Oracle 9i, 10g<p>Oracle provides PL/SQL UTL_HTTP package for calling HTTP from Oracle database. While using UTL_HTTP, it is required to set the proxy settings when calling a URL which is out side the firewall or beyond the proxy. In order to set the proxy, Oracle provides the following methods to set the proxy information. </p> <blockquote> <p>Utl_Http.Set_Proxy (<br> proxy => 'yourproxy',<br> no_proxy_domains => 'yourdomains' ); <p>req := Utl_Http.Begin_Request (<br> url => v_url,<br> method => 'GET' ); <p>Utl_Http.Set_Authentication (<br> r => req,<br> username => 'username', <p> password => 'password',<br> scheme => 'Basic',<br> for_proxy => false );</p> <div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:c7523cc6-24e4-48d6-b02b-2b9784661f18" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; float: none; padding-bottom: 0px; margin: 0px; padding-top: 0px">Technorati Tags: <a href="http://technorati.com/tags/Oracle" rel="tag">Oracle</a>, <a href="http://technorati.com/tags/oracle%2010g" rel="tag">oracle 10g</a>, <a href="http://technorati.com/tags/Oracle%209i" rel="tag">Oracle 9i</a>, <a href="http://technorati.com/tags/proxy" rel="tag">proxy</a>, <a href="http://technorati.com/tags/UTL_HTTP" rel="tag">UTL_HTTP</a>, <a href="http://technorati.com/tags/webservices" rel="tag">webservices</a></div></blockquote>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com7tag:blogger.com,1999:blog-4365662739166968864.post-67028061389727903072007-06-18T22:09:00.001-07:002007-06-18T22:49:14.667-07:00Querying group name from JTF_RS_GROUPS_VL using Group ID in Oracle 11i Ebusiness suite<p>SELECT group_name FROM jtf_rs_groups_vl WHERE group_id = p_group_id;</p> <p>pass p_group_id as the parameter. </p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com0tag:blogger.com,1999:blog-4365662739166968864.post-67659763139014399422007-06-18T22:05:00.001-07:002007-06-18T22:05:42.153-07:00Retrieving HR Person ID from Email address in Oracle Applications 11i<p>Retrieving HR Person ID from Email address in Oracle Applications 11i eBusiness Suite.</p> <p>Use the following query to retrieve the HR person ID for any employee by using the email address. This can be used in any modules of Oracle Applications 11i.</p> <p>SELECT person_id FROM per_people_x WHERE<br> UPPER(email_address) = p_email<br>and current_employee_flag = 'Y';</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com1tag:blogger.com,1999:blog-4365662739166968864.post-37953047156697819542007-06-18T19:00:00.001-07:002007-06-21T09:18:46.049-07:00jtf_notes used for Notes module in Oracle<p>jtf_notes used for Notes module in Oracle <p>Oracle Applications use jtf_notes for storing all notes related information across various modules. The tables used are jtf_notes_B, jtf_note_types. There is a translation table called jtf_notes_tl</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com0tag:blogger.com,1999:blog-4365662739166968864.post-81843583990874606902007-06-18T18:49:00.001-07:002007-06-20T16:35:22.499-07:00FND_MSG_PUB for error logging in Oracle Applications<p>FND_MSG_PUB for error logging in Oracle Applications. <p>Use the following snipped of code while calling any seeded API in Oracle Applications, like CRM, or Financials. <p>Put this block exactly under the section where you invoke the private or public API. The errors raised in the API are logged in the following API. Use this code while error logging or while debugging. Comment out the code before moving into production. <p>IF ( FND_MSG_PUB.Count_Msg > 0) THEN<br>FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP<br>FND_MSG_PUB.Get(p_msg_index => i,<br> p_encoded => 'F',<br> p_data => out_message,<br> p_msg_index_OUT => l_msg_index_OUT );<br>dbms_output.put_line('l_msg_data :' ||out_message);<br>END LOOP;<br>END IF;</p> <div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:e13af1f5-92b0-4fae-97df-5d08f4410e97" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px">Technorati Tags: <a href="http://technorati.com/tags/CRM" rel="tag">CRM</a>, <a href="http://technorati.com/tags/fnd_msg_pub" rel="tag">fnd_msg_pub</a>, <a href="http://technorati.com/tags/iAS" rel="tag">iAS</a>, <a href="http://technorati.com/tags/Oracle%20Apps" rel="tag">Oracle Apps</a>, <a href="http://technorati.com/tags/service%20request" rel="tag">service request</a>, <a href="http://technorati.com/tags/teleservices" rel="tag">teleservices</a></div>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com30tag:blogger.com,1999:blog-4365662739166968864.post-57576053521948794262007-06-18T18:35:00.001-07:002007-06-18T18:39:16.093-07:00Calling cs_servicerequest_pvt for updating service request in Oracle<p>Calling cs_servicerequest_pvt for updating service request in Oracle Applications <p>cs_servicerequest_pvt.Update_ServiceRequest(<br> P_API_VERSION => 3.0,<br> P_INIT_MSG_LIST => FND_API.G_TRUE,<br> P_COMMIT => FND_API.G_FALSE,<br> P_VALIDATION_LEVEL => fnd_api.G_VALID_LEVEL_NONE ,<br> X_RETURN_STATUS => out_status,<br> X_MSG_COUNT => x_msg_count,<br> X_MSG_DATA => out_message,<br> P_REQUEST_ID => x_sr_id, --in_request_id ,<br> P_OBJECT_VERSION_NUMBER => m_obj_version,<br> P_LAST_UPDATED_BY => m_user_id,<br> P_LAST_UPDATE_DATE => m_update_date,<br> P_SERVICE_REQUEST_REC => m_sr_rec_upd,<br> P_NOTES => m_notes_tbl,<br> P_CONTACTS => m_contacts_tbl,<br> X_INTERACTION_ID => X_INTER_ID,<br> X_WORKFLOW_PROCESS_ID => X_WORKFLOW_ID); </p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com0tag:blogger.com,1999:blog-4365662739166968864.post-29635111268788664242007-06-18T18:33:00.001-07:002007-06-21T09:28:37.969-07:00Calling cs_servicerequest_pvt API for create service request<p>Calling cs_servicerequest_pvt API for create service request in Oracle 11i. <p>cs_servicerequest_pvt.Create_ServiceRequest(<br> P_API_VERSION => 3.0,<br> P_INIT_MSG_LIST => FND_API.G_TRUE,<br> P_COMMIT => FND_API.G_FALSE,<br> P_VALIDATION_LEVEL => fnd_api.g_valid_level_full ,<br> X_RETURN_STATUS => out_status,<br> X_MSG_COUNT => x_msg_count,<br> X_MSG_DATA => out_message,<br> P_RESP_APPL_ID => NULL,<br> P_ORG_ID => NULL,<br> P_REQUEST_NUMBER => in_request_number,<br> P_SERVICE_REQUEST_REC => m_sr_rec,<br> P_NOTES => m_notes_tbl,<br> P_CONTACTS => m_contacts_tbl,<br> P_USER_ID => m_user_id,<br> P_RESP_ID => in_respId ,<br> X_REQUEST_ID => x_sr_id,<br> P_AUTO_ASSIGN => in_autoassign,<br> X_REQUEST_NUMBER => out_sr_number,<br> X_INTERACTION_ID => x_inter_id,<br> X_WORKFLOW_PROCESS_ID => x_workflow_id,<br> X_INDIVIDUAL_OWNER =>P_INDIVIDUAL_OWNER,<br> X_GROUP_OWNER =>P_GROUP_OWNER,<br> X_INDIVIDUAL_TYPE =>P_INDIVIDUAL_TYPE ); </p> <div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:b30b9307-87c8-4034-a6b4-a86b1b28346f" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px">Technorati Tags: <a href="http://technorati.com/tags/Oracle" rel="tag">Oracle</a>, <a href="http://technorati.com/tags/Oracle%20Apps" rel="tag">Oracle Apps</a>, <a href="http://technorati.com/tags/service%20request" rel="tag">service request</a></div>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com8tag:blogger.com,1999:blog-4365662739166968864.post-9593409449383662102007-06-18T17:21:00.001-07:002007-06-18T17:22:57.822-07:00Location of Cache/JSP Cache for jServ / Apache<p>Here is where the JSERV cache is located <p>$OA_HTML/_pages/_oa__html <p>Clear this Cache, especially when working on the login page. This ensures that the page is recompile each time. <p>Related to , Oracle Appliacations 11i, Cache, Self Service Applications and OA Framework.</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com53tag:blogger.com,1999:blog-4365662739166968864.post-3256804622074537792007-06-18T17:20:00.001-07:002007-06-19T22:00:28.680-07:00Bouncing Apache in Oracle Applications 11i<p>Bouncing Apache in Oracle Applications 11i. </p><p> In case you are doing development in Oracle Applications 11i and are working on JTT Framework or OAFramework, then you will need to bounce the Apache in order for your changes to be picked up. This is required for "Self Service Applications" and may not apply to forms 6i or oracle reports development. </p><p>In order to bounce the Apache, you will have to request the DBA access to the MidTier and the required privileges to bounce. </p><p>The script that does the bouncing for you is adapcctl.sh . Its commonly located under $COMMON_TOP/admin/scripts </p><p>Command for executing the bounce are </p><p>$ adapcctl.sh stop</p> <p>$ adapcctl.sh start</p> <p>Now there are cases when only bouncing is not enough and you might have to clear the cache. JSP cache is created each time SSA Applications are accessed in Oracle 11i. Its wise to clear the cache to be on the safer side.</p> <p>The cache is located under</p> <p>$OA_HTML/_pages/_oa__html</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com2tag:blogger.com,1999:blog-4365662739166968864.post-34332116649565206282007-06-18T17:11:00.001-07:002007-06-18T17:12:36.159-07:00Adding a new JSP to existing Oracle Applications<p>Adding a new JSP to existing Oracle Applications menu. JSP can be added under any responsibility. First define the menu as a JSP Function and then add it to the respective responsibility. <p>1. Log into to Application developer . Define the region if you want. Say IBU_SUPPORT_MENU and add the prompt and function name here. <p><a href="http://photos1.blogger.com/img/13/1633/1024/Adding%20Menu.jpg"><img src="http://photos1.blogger.com/img/13/1633/320/Adding%20Menu.jpg" border="0"></a></p> <p>2. Create a new function </p> <p><br><a href="http://photos1.blogger.com/img/13/1633/1024/AddingMenu0.jpg"><img src="http://photos1.blogger.com/img/13/1633/320/AddingMenu0.jpg" border="0"></a></p> <p>3. Define it as a SSWA jsp function and give the JSP name</p> <p><br><a href="http://photos1.blogger.com/img/13/1633/1024/CreateFunction2.jpg"><img src="http://photos1.blogger.com/img/13/1633/320/CreateFunction2.jpg" border="0"></a></p> <p>4. Find the menu under which you want to add this function.</p> <p><br><a href="http://photos1.blogger.com/img/13/1633/1024/CreateMenu1.jpg"><img src="http://photos1.blogger.com/img/13/1633/320/CreateMenu1.jpg" border="0"></a></p> <p>5. Run concurrent request/ bounce the apache.</p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com40tag:blogger.com,1999:blog-4365662739166968864.post-60241110592772521932007-06-18T17:02:00.001-07:002007-06-18T17:03:35.253-07:00Trim SR numbers and other parameters in JSP<h5>This can be used to trimming SR or other data that is passed to JSP's</h5> <p>function trim(strText) { <br> // this will get rid of leading spaces <br> while (strText.substring(0,1) == ' ') <br> strText = strText.substring(1, strText.length); <p> // this will get rid of trailing spaces <br> while (strText.substring(strText.length-1,strText.length) == ' ')<br> strText = strText.substring(0, strText.length-1); <p> return strText;<br>} </p>Venkateshhttp://www.blogger.com/profile/15939062060586923306noreply@blogger.com0