tag:blogger.com,1999:blog-135113162024-03-13T10:18:29.112+05:30Sridhar YerramAbout :Oracle Apps(E-Business Suite), Oracle Application Framework (OAF), Application Development Framework (ADF) / ADF MobileSridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.comBlogger100125tag:blogger.com,1999:blog-13511316.post-9104436263692309512019-11-07T12:11:00.001+05:302019-11-07T12:11:28.555+05:30OIC Important Links<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://docs.oracle.com/en/cloud/paas/integration-cloud/whats-new/index.html#INTWN-GUID-FB4FDA1D-A2E9-42F2-8209-F54537B180D2"><span style="color: windowtext; font-size: 12.0pt;">What’s New</span></a><o:p></o:p></div>
<div class="MsoNormal">
<a href="https://docs.oracle.com/en/cloud/paas/integration-cloud/">Oracle
Integration</a><o:p></o:p></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="http://secure-web.cisco.com/161ZjcqOt1xDsVy0MMIOyrPAVhMTLwTsYNiWDVh5LLTS1iiDbqexL_Z9Hw9MEyTk7GaBD6E4mJI1-r1t1LJ8jJ0-nRP11L3KrojoE60eTt_VhbOI5TfafzjhJkQXvVvSRas6N5h2YTv2ZcMjh0kHGGLUqliRdMCpplHZVpjldbVdEupKw6vfXAOq9Yfh7SjBoyN-KuvzGiDvqNiyZiqHiJkAVnwwkCkAG-hOFahe4UJl5u9PiciYZxtVArVaASGudXJ1eRmuvD9zvQE8HDbpg8abG_G6b5xiKssi2J0RL05iZpGKfnfWpyuT8etua4XbQe04oA0oi2cX0ly5sxodebcGyy54RiGz9DRxu4k_-9lOcaNfvOpTmbaJ3lsdRgX1psLID4_Xf2ETTLWUiAseaOe5tY8SnKOcTk56CqXqlv2ztEhJI1piPD37xqPts_t-RNzLOOfNq1sFMm_H33F0Wds2bB1TSKETE9YcQ5oQcwCksQ3A1ZCfUv560wrU320LbEGQmiFwpPM-lB6x_nTyHdQ/http%3A%2F%2Fwww.ateam-oracle.com%2Fintegration-cloud-file-handling-primer%2F"><span style="color: windowtext; font-size: 12.0pt;">Large Data Handling Best Practice -1</span></a><span style="color: #1f497d; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/fmw/oracle-integration-cloud-oic-file-based-integration-best-practices"><span style="color: windowtext; font-size: 12.0pt;">Large Data Handling Best Practice-2</span></a><span style="font-size: 12.0pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/fmw/oracle-integration-and-erp-cloud-how-to-get-job-name-and-parameters-of-erp-bulk-import-jobs"><span style="color: windowtext; font-size: 12.0pt;">FBDI Manifest File Creation Tips</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/integration/enabling-the-future-today-feature-flags-in-oracle-integration-cloud"><span style="color: windowtext; font-size: 12.0pt;">Feature Flag Enablement</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/integration/the-power-of-high-availability-connectivity-agent"><span style="color: windowtext; font-size: 12.0pt;">Connectivity Agent HA</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/integration/a-simple-guide-to-use-nested-scope-in-orchestration"><span style="color: windowtext; font-size: 12.0pt;">Nested Scopes</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://secure-web.cisco.com/1pmEuMJvMRNwf2A7UayzzlXRyitlWCgjKEk4lu8iDJ48utn8huEavQtxudI3PAKHOYw2lqfaBsJKpoTabEF2PQz-JhSr4Jq0yiwF_NAvIw9YSUIaZ6xX3E0X-GU41M5cC2znNhZ3v1DsLHbpC3x8y-NZgx1tpm8lcf6gVSB5VGvD4hPHqoYl9HQmWpFE0ZyrhCmR4xeJKZ4l0LYKiYLygV3-KKlu_Sz7O6HpOjYTX2CGlinCa4VxqvlCik5DG8qi5Zb-BaIFNyZTET5acVO5PkiHD1QHxS4E5BBirJpvFPsAN-3RR-nSFKcttuVuDReaeKnr4WWvWLwNXV2O2984WbnSI4GLlj0ulGFOjBX3bhXaD0GdQ9HDAK3ctrHPN3a6ig9gLOw5fEpCx0MLVc9LcVuY6W-GwIZpgBV2LRhv9cEPt7BDDve1CWPVapuiw1oITQfpU716LZJ0Qf0ZI6ELq8U5VF1qtpOyZN8hFuJyVHoWM8y_tFTd9W0e118YpGfCLq5MrT6Vte3pFYPp-_KGAPA/https%3A%2F%2Foracle-integration.cloud%2F2017%2F02%2F23%2Fusing-ical-in-scheduling-ics-definitive-tip-3%2F"><span style="color: windowtext; font-size: 12.0pt;">Scheduler custom iCal Expressions</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://blogs.oracle.com/integration/overriding-schedule-parameters"><span style="color: windowtext; font-size: 12.0pt;">Schedule Parameters</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-size: 12.0pt;">Dev
OPs:</span></b><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in; text-indent: .5in;">
<a href="https://secure-web.cisco.com/180-SqsBUEwurzpeUHw4pB-gsPCkItjJ0lxlSv-AchZCPWE7k_kS8TpqddSnK-4JDxETygUenOBQFUSmnyJqPLe7A8XqVjXxGkdZhwy9qgQZK_27nCV1-fWbcynFc-XthzIq7hoDW606UVQo27luE7hSq1Zfogr6TsBGJCgdU9_9cGXG7kEfP2Os_mA9kcTtYYEfe8fVUj8baMtNagC2P1df9LwoQOBnvxFxF_dKzK04y8gkW0kt-sbFN0ZkKEBubI2wMxzsFtJ3MPUnHadXkMgcP-wW-9-r5J9cunezBFjb2rdzfOj2ONT5NVNTG7WJkJ5aEeeLSJYvgOlZXbFzx4_aHOH9ptITvTsyhMHsBy915ogcJVX1AznkDJSwKPexJdLips7aTpQYzzDkg8YLkn_zMwqAo9g74RazpDG-TiAjMTLBGFE9z__Gp8U2yrrtPHtozMj--JAKsNSFvW-mg-4YOUXBWIHWWEPpvntSndhTTtynBl9bQ3Um7jU9rRL3OgNUOWd5yzS3wREBiFY8fPA/https%3A%2F%2Fredthunder.blog%2F2017%2F02%2F26%2Fteaching-how-to-use-developer-cloud-service-to-promote-ics-integrations-into-new-environments%2F"><span style="color: windowtext; font-size: 12.0pt;">Dev OPs with Developer CS</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in; text-indent: .5in;">
<b><u><span style="font-size: 12.0pt;">OIC REST APIs:</span></u></b><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in; text-indent: .5in;">
<span style="font-size: 12.0pt;"> </span><a href="https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsra/toc.htm"><span style="color: windowtext; font-size: 12.0pt;">V1</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in; text-indent: .5in;">
<span style="font-size: 12.0pt;"> </span><a href="https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icsrb/toc.htm"><span style="color: windowtext; font-size: 12.0pt;">V2</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-size: 12.0pt;">
</span><a href="https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/index.html"><span style="color: windowtext; font-size: 12.0pt;">Latest</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-size: 12.0pt;">
</span><a href="https://blogs.oracle.com/integration/how-to-migrate-from-ics-to-oic"><span style="color: windowtext; font-size: 12.0pt;">Migration ICS to OIC</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-size: 12.0pt;">
</span><a href="https://blogs.oracle.com/integration/how-to-use-asserter-to-create-oic-integration-unit-tests-automatically-and-run-them-to-catch-regressions"><span style="color: windowtext; font-size: 12.0pt;">Regression Framework</span></a><span style="font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<a href="https://cloud.oracle.com/cost-estimator"><span style="color: windowtext; font-size: 12.0pt;">Cost Estimator</span></a><span style="font-size: 12.0pt;"> (We
can share Cost Estimator guideline Excel that helps you to work on sizing,
please get back to us in case you need) <o:p></o:p></span></div>
<div class="MsoNormal" style="text-indent: .5in;">
<a href="https://www.oracle.com/webfolder/s/assets/demo/integration-simulator/index.html#step1">OIC
Simulator</a><o:p></o:p></div>
<div class="MsoNormal" style="text-indent: .5in;">
<a href="https://cloudmarketplace.oracle.com/marketplace/en_US/productHomePage">OIC
Marketplace</a> <o:p></o:p></div>
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-5849286566563985082018-07-28T11:05:00.003+05:302018-07-28T11:05:38.624+05:30Jdeveloper - ADF - Tips<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<ul style="text-align: left;">
<li>When the log window wents crazy ;) The solution for this problem is to rename/delete the windowinglayout.xml file from the jdevsystemoracle.ide.10.1.3.39.84 directory. https://blogs.oracle.com/shay/where-did-that-jdeveloper-window-went-to</li>
</ul>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-21102218433906766972018-07-19T10:07:00.004+05:302018-07-19T10:07:33.565+05:30ADF - Security Options to be mentioned while invoking Oracle Cloud SaaS WebService from ADF<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
set JAVA_OPTIONS=%JAVA_OPTIONS% -DUseSunHttpHandler=true -Dssl.SocketFactory.provider=sun.security.ssl.SSLSocketFactoryImpl -Dssl.ServerSocketFactory.provider=sun.security.ssl.SSLSocketFactoryImpl<br />
<br />
Edit the file -setDomainEnv.cmd<br />
it will be in the default domain of the jdeveloper installation directory</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-91916520450821096812018-05-23T17:55:00.001+05:302018-05-23T17:55:06.520+05:30ADF - Location of Standard Icons<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<ol style="text-align: left;">
<li>Go to the location : C:\Oracle\Middleware\oracle_common\modules\oracle.adf.view_11.1.1</li>
<li>Extract the jar file : adf-richclient-impl-11.jar</li>
<li>Check the extract folder ./adf/images</li>
</ol>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-vKz9hS3W1rA/WwVdhmthc4I/AAAAAAAAKm4/Pa7fBcksQTIhaMJV3yNaznW2wLOpOsgAwCLcBGAs/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="724" data-original-width="1374" height="210" src="https://1.bp.blogspot.com/-vKz9hS3W1rA/WwVdhmthc4I/AAAAAAAAKm4/Pa7fBcksQTIhaMJV3yNaznW2wLOpOsgAwCLcBGAs/s400/Untitled.png" width="400" /></a></div>
<div>
<br /></div>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-37490366859923589492018-03-22T16:10:00.001+05:302018-03-22T16:10:12.091+05:30ADF - Customizing the Standard Search Functionality <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
In OAF - We have a bean called : QueryBean - which performs Automatic Search Functionality.<br />
There are use cases where we do customization to the Standard Query bean.<br />
<br />
Similarly in ADF too, there is search bean and also it provides custom logic to be implemented.<br />
<br />
The Same is explained in this tutorial in detailed manner @<br />
<br />
http://www.oracle.com/technetwork/developer-tools/adf/learnmore/30-table-filter-queries-169172.pdf<br />
<br />
<br />
<b><u></u></b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><u><a href="https://4.bp.blogspot.com/-ZdG9fdH47RA/WrOH3UFRa8I/AAAAAAAAKE4/4X1O7Rn1HLMjx565LRfy88vMpY7upP50gCLcBGAs/s1600/image001.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="489" data-original-width="936" src="https://4.bp.blogspot.com/-ZdG9fdH47RA/WrOH3UFRa8I/AAAAAAAAKE4/4X1O7Rn1HLMjx565LRfy88vMpY7upP50gCLcBGAs/s1600/image001.jpg" /></a></u></b></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<b><u><a href="https://4.bp.blogspot.com/-In62AVhqKHA/WrOH25_DRGI/AAAAAAAAKEw/95pxRuwoC2kHcOs3ZaRiCQKLzGS5flWXACLcBGAs/s1600/image002.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="418" data-original-width="543" src="https://4.bp.blogspot.com/-In62AVhqKHA/WrOH25_DRGI/AAAAAAAAKEw/95pxRuwoC2kHcOs3ZaRiCQKLzGS5flWXACLcBGAs/s1600/image002.jpg" /></a></u></b></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<b><u><a href="https://1.bp.blogspot.com/-TMBO7Ugyc80/WrOH3OlU9tI/AAAAAAAAKE0/9X1mYF5ZvVMPHcfnRt9NULoHcS6KWVO-ACLcBGAs/s1600/image003.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="357" data-original-width="936" src="https://1.bp.blogspot.com/-TMBO7Ugyc80/WrOH3OlU9tI/AAAAAAAAKE0/9X1mYF5ZvVMPHcfnRt9NULoHcS6KWVO-ACLcBGAs/s1600/image003.jpg" /></a></u></b></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<b><u><a href="https://3.bp.blogspot.com/-cdaBIjEg6YA/WrOH4L3TU1I/AAAAAAAAKE8/9VyCZVcwoT8LdgQ-fIZdf6Rl1yKxmTC-gCLcBGAs/s1600/image004.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="306" data-original-width="937" src="https://3.bp.blogspot.com/-cdaBIjEg6YA/WrOH4L3TU1I/AAAAAAAAKE8/9VyCZVcwoT8LdgQ-fIZdf6Rl1yKxmTC-gCLcBGAs/s1600/image004.jpg" /></a></u></b></div>
<br />
<b><u><br /></u></b>
<b><u><br /></u></b>
<b><u>Java Logic Used is mentioned below : EmployeeQueryPG.java</u></b><br />
<b><u><br /></u></b>
package view.backing;<br />
<br />
import java.util.Map;<br />
<br />
import javax.el.ELContext;<br />
import javax.el.ExpressionFactory;<br />
import javax.el.MethodExpression;<br />
<br />
import javax.faces.context.FacesContext;<br />
<br />
import oracle.adf.view.rich.component.rich.RichDocument;<br />
import oracle.adf.view.rich.component.rich.RichForm;<br />
import oracle.adf.view.rich.component.rich.data.RichTable;<br />
import oracle.adf.view.rich.component.rich.input.RichInputDate;<br />
import oracle.adf.view.rich.component.rich.output.RichMessages;<br />
import oracle.adf.view.rich.event.QueryEvent;<br />
import oracle.adf.view.rich.model.FilterableQueryDescriptor;<br />
<br />
public class EmployeeQueryPG {<br />
private RichForm f1;<br />
private RichDocument d1;<br />
private RichMessages m1;<br />
private RichTable t1;<br />
private RichInputDate id1;<br />
<br />
public void setF1(RichForm f1) {<br />
this.f1 = f1;<br />
}<br />
<br />
public RichForm getF1() {<br />
return f1;<br />
}<br />
<br />
public void setD1(RichDocument d1) {<br />
this.d1 = d1;<br />
}<br />
<br />
public RichDocument getD1() {<br />
return d1;<br />
}<br />
<br />
public void setM1(RichMessages m1) {<br />
this.m1 = m1;<br />
}<br />
<br />
public RichMessages getM1() {<br />
return m1;<br />
}<br />
<br />
public void setT1(RichTable t1) {<br />
this.t1 = t1;<br />
}<br />
<br />
public RichTable getT1() {<br />
return t1;<br />
}<br />
<br />
public void setId1(RichInputDate id1) {<br />
this.id1 = id1;<br />
}<br />
<br />
public RichInputDate getId1() {<br />
return id1;<br />
}<br />
<br />
public void onQuery(QueryEvent queryEvent) {<br />
// Add event code here...<br />
System.out.println("user is searching");<br />
<br />
// pre-processing code here<br />
<br />
boolean invokeQuery = true;<br />
/*<br />
* Method called by the Query Listener. This method checks if<br />
* the DepartmentId parameter contains a valid number and puts<br />
* the DepartmentName into the expected case<br />
*/<br />
FilterableQueryDescriptor fqd =<br />
(FilterableQueryDescriptor)<br />
queryEvent.getDescriptor();<br />
Map map = fqd.getFilterCriteria();<br />
<br />
// ensure DepartmentId contains a Number<br />
String EmployeeId = (String) map.get("EmployeeId");<br />
<br />
System.out.println("entered EmployeeId-->" + EmployeeId);<br />
<br />
if (EmployeeId != null && EmployeeId.length()>0){<br />
<br />
try {<br />
// try to parse String to integer<br />
Long.parseLong(EmployeeId);<br />
<br />
} catch (Exception ex) {<br />
// not a string<br />
System.out.println("Not a string");<br />
// add some error message here<br />
// unset selection<br />
map.remove("DepartmentId");<br />
invokeQuery = false;<br />
}<br />
}<br />
<br />
// ensure the initial character is in uppercase<br />
String departmentName = (String) map.get("FirstName");<br />
if (departmentName != null && departmentName.length()>0){<br />
StringBuffer sbuf = new StringBuffer();<br />
sbuf.append(departmentName.substring(0,1).toUpperCase());<br />
sbuf.append(departmentName.substring(1).toLowerCase());<br />
map.put("FirstName",sbuf.toString()); <br />
}<br />
<br />
if (invokeQuery) {<br />
invokeMethodExpression("#{bindings.EmployeeEOVO1Query.processQuery}",<br />
Object.class,QueryEvent.class,<br />
queryEvent);<br />
}<br />
<br />
<br />
<br />
}<br />
<br />
public Object invokeMethodExpression(String expr, Class returnType, Class[] argTypes,Object[] args){<br />
FacesContext fc = FacesContext.getCurrentInstance(); <br />
ELContext elctx = fc.getELContext();<br />
ExpressionFactory elFactory = fc.getApplication().getExpressionFactory(); <br />
MethodExpression methodExpr = elFactory.createMethodExpression(elctx,expr,returnType,argTypes); <br />
return methodExpr.invoke(elctx,args); <br />
}<br />
<br />
<br />
public Object invokeMethodExpression(String expr, Class returnType,Class argType, Object argument){ <br />
return invokeMethodExpression(expr, returnType,new Class[]{argType}, new Object[]{argument});<br />
}<br />
<br />
<br />
}<br />
<div>
<br /></div>
<br />
<br />
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-12486107967189449522018-03-21T16:02:00.001+05:302018-03-21T16:02:26.922+05:30ADF - Get Selected Rows - Single/Multi Selection<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b>//Single Selection</b><br />
<br />
public String singleSelection_action() {<br />
// Add event code here...<br />
<br />
System.out.println("User Clicked on Single Button");<br />
<br />
DCBindingContainer bindings =<br />
(DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();<br />
DCIteratorBinding dcItteratorBindings =<br />
bindings.findIteratorBinding("EmployeeEOVO1Iterator");<br />
<br />
// Get an object representing the table and what may be selected within it<br />
ViewObject voTableData = dcItteratorBindings.getViewObject();<br />
<br />
// Get selected row<br />
Row rowSelected = voTableData.getCurrentRow();<br />
<br />
// Display attribute of row in console output - would generally be bound to a UI component like a Label and or used to call another proces<br />
System.out.println(rowSelected.getAttribute("EmployeeId"));<br />
<br />
<br />
<br />
return null;<br />
}<br />
<br />
<br />
<b>//Multi Selection</b><br />
<br />
public String multipleSelection_action() {<br />
// Add event code here...<br />
System.out.println("User Clicked on Multiple Selection ");<br />
<br />
<br />
// RowKeySet Object can hold the selected rows from a user as follows<br />
RowKeySet rksSelectedRows =<br />
this.getT1().getSelectedRowKeys();<br />
<br />
// Iterator object provides the ability to use hasNext(), next() and remove() against the selected rows<br />
Iterator itrSelectedRows = rksSelectedRows.iterator();<br />
<br />
// Get the data control that is bound to the table - e.g. OpenSupportItemsIterator<br />
DCBindingContainer bindings =<br />
(DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();<br />
DCIteratorBinding dcIteratorBindings =<br />
bindings.findIteratorBinding("EmployeeEOVO1Iterator");<br />
<br />
// Information from binding that is specific to the rows<br />
RowSetIterator rsiSelectedRows =<br />
dcIteratorBindings.getRowSetIterator();<br />
<br />
// Loop through selected rows<br />
while (itrSelectedRows.hasNext()) {<br />
<br />
// Get key for selected row<br />
Key key = (Key)((List)itrSelectedRows.next()).get(0);<br />
<br />
// Use the key to get the data from the above binding that is related to the row<br />
Row myRow = rsiSelectedRows.getRow(key);<br />
<br />
// Display attribute of row in console output - would generally be bound to a UI component like a Label and or used to call another proces<br />
System.out.println(myRow.getAttribute("EmployeeId"));<br />
}<br />
<br />
<br />
<br />
<br />
return null;<br />
}</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-5025021002269563962018-03-01T16:46:00.003+05:302018-03-01T16:46:32.094+05:30ADF - Sample Java Code To Iterate VO Data<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
Following is the code snippet to extract the data from VO.<br />
<br />
Below code is very similar to the logic which we write in OAF (Oracle Application Framework)<br />
<br />
public class AppModuleAMTest {<br />
<br />
public static void main(String args[])<br />
{<br />
//bc4jclient --press enter <br />
String amDef = "oracle.fod.storefront.model.module.AppModuleAM";<br />
String config = "AppModuleAMLocal";<br />
ApplicationModule am =<br />
Configuration.createRootApplicationModule(amDef, config);<br />
ViewObject vo = am.findViewObject("Employees1");<br />
vo.executeQuery();<br />
while(vo.hasNext())<br />
{ <br />
Row empRow = vo.next();<br />
System.out.println("Employee ID -->"+ empRow.getAttribute(1));<br />
<br />
}<br />
// Work with your appmodule and view object here<br />
Configuration.releaseRootApplicationModule(am, true);<br />
}<br />
}</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-79116369177671007292018-02-27T10:31:00.002+05:302018-02-27T10:31:54.955+05:30ADF build.xml File For : StoreFront Sample<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b><u>Following is the build.properties file</u></b><br />
<br />
Value for : jdeveloper.home is very important , Please check the below screenshot<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-CXs0qfmjhxM/WpTliB-lxyI/AAAAAAAAJ7g/Soep6xVFPjkd16k6H8rmyudDWxdrskttACLcBGAs/s1600/Capture.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="814" data-original-width="1219" height="213" src="https://1.bp.blogspot.com/-CXs0qfmjhxM/WpTliB-lxyI/AAAAAAAAJ7g/Soep6xVFPjkd16k6H8rmyudDWxdrskttACLcBGAs/s320/Capture.PNG" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
# Master Ant properties file for Fusion Order Demo<br />
# All build files refer to this master list of properties<br />
# Continuous builds override these settings<br />
# $Id: build.properties 812 2007-02-20 07:14:33Z lmunsing $<br />
<br />
# Base Directory for library lookup<br />
jdeveloper.home=C:/Oracle/Middleware/jdeveloper/<br />
src.home=..//..<br />
<br />
# JDBC info used to create Schema<br />
jdbc.driver=oracle.jdbc.OracleDriver<br />
jdbc.urlBase=jdbc:oracle:thin:@localhost<br />
jdbc.port=1521<br />
jdbc.sid=XE<br />
<br />
# Information about the default setup for the demo user.<br />
db.adminUser=system<br />
db.demoUser=FOD<br />
db.demoUser.password=fusion<br />
db.demoUser.tablespace=USERS<br />
db.demoUser.tempTablespace=TEMP<br />
<br />
<br />
<b>Running the build.xml ANT Script.</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-PdkSXKzdAa8/WpTmCVXZ0FI/AAAAAAAAJ7o/NgCyMDIOLMYCoXAB34t_n3bL4C8P6Zk8wCLcBGAs/s1600/Untitled.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="802" data-original-width="1600" height="160" src="https://1.bp.blogspot.com/-PdkSXKzdAa8/WpTmCVXZ0FI/AAAAAAAAJ7o/NgCyMDIOLMYCoXAB34t_n3bL4C8P6Zk8wCLcBGAs/s320/Untitled.png" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Buildfile: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\Ant\build.xml<br />
<br />
init:<br />
[javac] Compiling 1 source file to C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\Ant\classes<br />
<br />
setProperties:<br />
<br />
createDatabase:<br />
<br />
refreshSchema:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Failed to execute: DROP USER FOD CASCADE<br />
[sql] java.sql.SQLSyntaxErrorException: ORA-01918: user 'FOD' does not exist<br />
<br />
[sql] 10 of 11 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[echo] Warning: An unlocked database user 'FOD' has been created, with create session, table, and sequence privileges.<br />
<br />
createSchemaObjects:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\createFODSchemaObjects.sql<br />
[sql] 489 of 489 SQL statements executed successfully<br />
<br />
createSequenceTriggers:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\createSequenceTriggers.sql<br />
[sql] 20 of 20 SQL statements executed successfully<br />
<br />
populateTables:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 4 of 4 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[echo] Demo Options Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\AVAILABLE_LANGUAGES.sql<br />
[sql] 5 of 5 SQL statements executed successfully<br />
[echo] Available Languages Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 244 of 244 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 244 of 244 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 244 of 244 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 244 of 244 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 244 of 244 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[echo] Country Codes Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 66 of 66 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 66 of 66 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 66 of 66 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 66 of 66 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 66 of 66 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[echo] Lookup Codes Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ADDRESSES.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\DISCOUNTS_BASE.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\MEMBERSHIPS_BASE.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\SHIPPING_OPTIONS_BASE.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\SUPPLIERS.sql<br />
[sql] 173 of 173 SQL statements executed successfully<br />
[echo] Addresses, Memberships, Discounts, Shipping Options and Suppliers Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\DISCOUNT_TRANSLATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ELIGIBLE_DISCOUNTS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\MEMBERSHIP_TRANSLATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\PERSONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\SHIPPING_OPTION_TRANSLATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\WAREHOUSES.sql<br />
[sql] 117 of 117 SQL statements executed successfully<br />
[echo] Persons, Warehouses, Discount Translations, Shipping Option Translations, and Eligible Discounts Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ADDRESS_USAGES.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\CUSTOMER_IDENTIFICATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\PAYMENT_OPTIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCT_CATEGORIES_BASE.sql<br />
[sql] 197 of 197 SQL statements executed successfully<br />
[echo] Address Usages, Customer Identifications, Payment Options, Product Categories, and Orders Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\CATEGORY_TRANSLATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\CUSTOMER_INTERESTS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ORDERS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCTS_BASE.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\WAREHOUSE_STOCK_LEVELS.sql<br />
[sql] 425 of 425 SQL statements executed successfully<br />
[echo] Products, Warehouse Stock Levels, Coupon Usages, Categories, and Customer Interests Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ALTER_TABLES.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\COUPON_USAGES.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\HELP_TRANSLATIONS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\ORDER_ITEMS.sql<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCT_TRANSLATIONS.sql<br />
[sql] 165 of 165 SQL statements executed successfully<br />
[echo] Coupon Usages, Product Translations, Order Items, and Help Translations Created<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\PackageScripts\user_context.sql<br />
[sql] 2 of 2 SQL statements executed successfully<br />
[echo] USER_CONTEXT Package Created<br />
<br />
createIndexes:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\createIndexes.sql<br />
[sql] 2 of 2 SQL statements executed successfully<br />
[echo] Indexes Created<br />
<br />
compileImagesApp:<br />
[javac] Compiling 3 source files to C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\classes<br />
[javac] Note: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\src\oracle\fodemo\share\imageloader\EnvProvider.java uses or overrides a deprecated API.<br />
[javac] Note: Recompile with -Xlint:deprecation for details.<br />
[javac] Note: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\src\oracle\fodemo\share\imageloader\EnvProvider.java uses unchecked or unsafe operations.<br />
[javac] Note: Recompile with -Xlint:unchecked for details.<br />
[copy] Copying 5 files to C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\classes<br />
<br />
populateImages:<br />
[java] Feb 27, 2018 10:25:26 AM oracle.adf.share.ADFContext getCurrent<br />
[java] WARNING: Automatically initializing a DefaultContext for getCurrent.<br />
[java] Caller should ensure that a DefaultContext is proper for this use.<br />
[java] Memory leaks and/or unexpected behaviour may occur if the automatic initialization is performed improperly.<br />
[java] This message may be avoided by performing initADFContext before using getCurrent().<br />
[java] For more information please enable logging for oracle.adf.share.ADFContext at FINEST level.<br />
[java] Feb 27, 2018 10:25:28 AM oracle.mds<br />
[java] NOTIFICATION: PManager instance is created without multitenancy support as JVM flag "oracle.multitenant.enabled" is not set to enable multitenancy support.<br />
[java] oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=oracle/jdbc/OracleClob<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTarget(Project.java:1306)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.runBuild(Main.java:758)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.startAnt(Main.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.start(Main.java:179)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.main(Main.java:268)<br />
Caused by: oracle.jbo.JboException: JBO-29115 Unable to construct the error message due to error java.lang.ClassNotFoundException: oracle.jbo.client.remote.StringManagerImpl. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-29000. Error message parameters are {0=java.lang.NoClassDefFoundError, 1=oracle/jdbc/OracleClob}<br />
<span style="white-space: pre;"> </span>at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:602)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2396)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2270)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3169)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)<br />
<span style="white-space: pre;"> </span>at oracle.fodemo.share.imageloader.LoadImages.main(LoadImages.java:23)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)<br />
<span style="white-space: pre;"> </span>... 33 more<br />
Caused by: java.lang.NoClassDefFoundError: oracle/jdbc/OracleClob<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getDeclaredConstructors0(Native Method)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getConstructor0(Class.java:2699)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance0(Class.java:326)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance(Class.java:308)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ComponentObjectImpl.createRef(ComponentObjectImpl.java:221)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.doCreateViewObject(ApplicationModuleImpl.java:4057)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.AMViewUsage.createViewObject(AMViewUsage.java:112)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadViewObject(ApplicationModuleDefImpl.java:659)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadComponents(ApplicationModuleDefImpl.java:922)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:512)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:87)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:158)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:73)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:2836)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:583)<br />
<span style="white-space: pre;"> </span>... 48 more<br />
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleClob<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1400)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1341)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.loadClass(AntClassLoader.java:1094)<br />
<span style="white-space: pre;"> </span>at java.lang.ClassLoader.loadClass(ClassLoader.java:246)<br />
<span style="white-space: pre;"> </span>... 64 more<br />
--- Nested Exception ---<br />
oracle.jbo.JboException: JBO-29115 Unable to construct the error message due to error java.lang.ClassNotFoundException: oracle.jbo.client.remote.StringManagerImpl. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-29000. Error message parameters are {0=java.lang.NoClassDefFoundError, 1=oracle/jdbc/OracleClob}<br />
<span style="white-space: pre;"> </span>at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:602)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2396)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2270)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3169)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)<br />
<span style="white-space: pre;"> </span>at oracle.fodemo.share.imageloader.LoadImages.main(LoadImages.java:23)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTarget(Project.java:1306)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.runBuild(Main.java:758)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.startAnt(Main.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.start(Main.java:179)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.main(Main.java:268)<br />
Caused by: java.lang.NoClassDefFoundError: oracle/jdbc/OracleClob<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getDeclaredConstructors0(Native Method)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getConstructor0(Class.java:2699)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance0(Class.java:326)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance(Class.java:308)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ComponentObjectImpl.createRef(ComponentObjectImpl.java:221)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.doCreateViewObject(ApplicationModuleImpl.java:4057)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.AMViewUsage.createViewObject(AMViewUsage.java:112)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadViewObject(ApplicationModuleDefImpl.java:659)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadComponents(ApplicationModuleDefImpl.java:922)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:512)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:87)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:158)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:73)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:2836)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:583)<br />
<span style="white-space: pre;"> </span>... 48 more<br />
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleClob<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1400)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1341)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.loadClass(AntClassLoader.java:1094)<br />
<span style="white-space: pre;"> </span>at java.lang.ClassLoader.loadClass(ClassLoader.java:246)<br />
<span style="white-space: pre;"> </span>... 64 more<br />
## Detail 0 ##<br />
java.lang.NoClassDefFoundError: oracle/jdbc/OracleClob<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getDeclaredConstructors0(Native Method)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.getConstructor0(Class.java:2699)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance0(Class.java:326)<br />
<span style="white-space: pre;"> </span>at java.lang.Class.newInstance(Class.java:308)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ComponentObjectImpl.createRef(ComponentObjectImpl.java:221)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.doCreateViewObject(ApplicationModuleImpl.java:4057)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.AMViewUsage.createViewObject(AMViewUsage.java:112)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadViewObject(ApplicationModuleDefImpl.java:659)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleDefImpl.loadComponents(ApplicationModuleDefImpl.java:922)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:512)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:87)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:158)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:73)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:2836)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:583)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2396)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2270)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3169)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)<br />
<span style="white-space: pre;"> </span>at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)<br />
<span style="white-space: pre;"> </span>at oracle.fodemo.share.imageloader.LoadImages.main(LoadImages.java:23)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
<span style="white-space: pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
<span style="white-space: pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
<span style="white-space: pre;"> </span>at java.lang.reflect.Method.invoke(Method.java:597)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Task.perform(Task.java:348)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.execute(Target.java:357)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Target.performTasks(Target.java:385)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTarget(Project.java:1306)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Project.executeTargets(Project.java:1189)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.runBuild(Main.java:758)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.startAnt(Main.java:217)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.start(Main.java:179)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.Main.main(Main.java:268)<br />
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleClob<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1400)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1341)<br />
<span style="white-space: pre;"> </span>at org.apache.tools.ant.AntClassLoader.loadClass(AntClassLoader.java:1094)<br />
<span style="white-space: pre;"> </span>at java.lang.ClassLoader.loadClass(ClassLoader.java:246)<br />
<span style="white-space: pre;"> </span>... 64 more<br />
[java] Java Result: -1<br />
<br />
revokePrivs:<br />
[sql] Executing resource: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[sql] 6 of 6 SQL statements executed successfully<br />
[delete] Deleting: C:\Users\sriyerram\Documents\Sridhar\Cloud\ADF\FusionOrderDemo_R2_1_revised\Infrastructure\DBSchema\Scripts\SQLRunner1246245679.sql<br />
[echo] Cleaning up database user privileges.<br />
<br />
createDatabase:<br />
[echo] Database (Re)Creation Complete<br />
<br />
buildAll:<br />
<br />
BUILD SUCCESSFUL<br />
Total time: 18 seconds<br />
<div>
<br /></div>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-77069545288604882482018-02-15T09:46:00.003+05:302018-02-15T09:46:31.566+05:30ADF - Code Snippets<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>Extract the value from the text input component</u></b><br />
<b><br /></b>
<b>Write the below method in the managed bean.</b><br />
<b><br /></b>
public Object cb1_action() {<br />
// Add event code here...<br />
<br />
FacesContext facesContext = FacesContext.getCurrentInstance();<br />
UIViewRoot root = facesContext.getViewRoot();<br />
RichInputText inputText = (RichInputText)root.findComponent("it1");<br />
String val = (String)inputText.getValue();<br />
System.out.println("Entered Value -->"+ val);<br />
return null;<br />
<br />
}</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-37747856425544693002017-12-14T19:13:00.002+05:302017-12-14T19:13:23.735+05:30Comparison of Files Created For HelloWorld Application in OAF and ADF<div dir="ltr" style="text-align: left;" trbidi="on">
In this post, i would like to provide very basic level of files comparison between OAF and ADF<br />
<br />
HelloWorld - OAF Application Requires the following :<br />
<br />
Below are the bare minimum files, which are required to create HelloWorld Page in OAF.<br />
<br />
Workspace - .jws file<br />
Project - .jpr file<br />
Application Module : AM.xml , AMImpl.java<br />
UI Page - HelloWorldPG.xml<br />
<br />
Below are the files, which are required to create HelloWorld Page in ADF<br />
Workspace - .jws file<br />
Project- ViewController.jpr , Model.jpr<br />
UI Page - HelloWorldPG.jspx<br />
Config Files : adf-config.xml, weblogic-application.xml, adfc-config.xml, faces-config.xml, trinidad-config.xml, web.xml<br />
<br />
<br />
Few Observations in this HelloWorld ADF Sample :<br />
<br />
<ul style="text-align: left;">
<li>AM is not required to run HelloWorld PG in ADF</li>
<li>2 Projects are created by Default in ADF</li>
<li>ADF runs on Embedded Weblogic Server(While Running from Desktop)</li>
<li>No DB connection is required</li>
</ul>
<br />
<br />
<br />
<br />
<br />
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-2455182628074053752017-12-14T16:03:00.002+05:302017-12-14T16:03:11.959+05:30OAF - Code Snippet to get list of AM's Loaded in the page<div dir="ltr" style="text-align: left;" trbidi="on">
OAApplicationModule parentAM = pageContext.getRootApplicationModule() ;<br />
String[] nestedAMNames = parentAM.getApplicationModuleNames();<br />
<br />
// If you want to retrieve all currently loaded nested Application Modules<br />
ApplicationModule[] nestedAMs = new ApplicationModule[nestedAMNames.length];<br />
<br />
// oracle.apps.ar.hz.components.account.customer.server.HzPuiCustActAMImpl hzCustAccountAM = null;<br />
oracle.apps.ar.hz.components.account.contact.server.HzPuiActContRoleAMImpl HzPuiActContRoleAM = null;<br />
for (int i = 0; i < nestedAMNames.length && temp==0; i++)<br />
{<br />
nestedAMs[i] = parentAM.findApplicationModule(nestedAMNames[i]);<br />
pageContext.writeDiagnostics(this,"nestedAMs["+i+"]" + nestedAMs[i],OAFwkConstants.STATEMENT);<br />
if(nestedAMs[i] instanceof HzPuiActContRoleAMImpl)<br />
{<br />
temp = 1;<br />
HzPuiActContRoleAM = (HzPuiActContRoleAMImpl)nestedAMs[i];<br />
pageContext.writeDiagnostics(this,"Matching AM Found ; nestedAMs["+i+"]" + nestedAMs[i],OAFwkConstants.STATEMENT);<br />
}<br />
}</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-25628887521722860592017-12-06T16:49:00.003+05:302017-12-06T16:49:32.942+05:30Oracle SCM - Lookups<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><b><span style="font-family: inherit;">mtl_txn_request_lines -Line Status Lookup</span></b></span><br />
<span style="background-color: white;"><b><span style="font-family: inherit;"><br /></span></b></span>
<b><br /></b>
<b>select lookup_code, meaning</b><br />
<b>from mfg_lookups </b><br />
<b>where lookup_type = 'MTL_TXN_REQUEST_STATUS' </b><br />
<b><span style="background-color: white;"></span></b><br />
<b>order by lookup_code </b></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-3004751036087518322017-10-31T16:10:00.000+05:302017-10-31T16:10:04.058+05:30Solidity - Smart Contract - FirstOne - HelloWorld<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
From Website : https://karl.tech/learning-solidity-part-1-deploy-a-contract/<br />
<br />
contract HelloWorld { <br />
event log_string(bytes32 log); // Event<br />
<br />
function () { // Fallback Function<br />
log_string("Hello World!");<br />
}<br />
}</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-61189430322830953152017-10-31T07:49:00.001+05:302017-10-31T07:49:42.423+05:30BlockChain Notes<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Quora BlockChain Advisors<br />
<br />
https://www.quora.com/profile/Arnav-Vohra-3<br />
<br />
<br />
Top BlockChain Companies<br />
<br />
<ol style="color: #333333; font-family: q_serif, Georgia, Times, "Times New Roman", "Hiragino Kaku Gothic Pro", Meiryo, serif; font-size: 15px; list-style-image: initial; list-style-position: initial; margin: 0px 2em 1em 0px; padding: 0px;">
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Applied Blockchain</b> (<span class="qlink_container"><a class="external_link" data-qt-tooltip="appliedblockchain.com" data-tooltip="attached" href="http://appliedblockchain.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">http://appliedblockchain.com</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Parity Technologies </b>(<span class="qlink_container"><a class="external_link" href="https://ethcore.io/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">https://ethcore.io/</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>ConsenSys </b>(<span class="qlink_container"><a class="external_link" href="http://consensys.net/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">http://consensys.net</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>AlphaPoint </b>(<span class="qlink_container"><a class="external_link" href="http://www.alphapoint.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">http://www.alphapoint.com/</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>ChainThat </b>(<span class="qlink_container"><a class="external_link" href="http://chainthat.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">http://chainthat.com/</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Chainsmiths </b>(<span class="qlink_container"><a class="external_link" data-qt-tooltip="chainsmiths.com" data-tooltip="attached" href="http://chainsmiths.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">http://chainsmiths.com</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Ledger Labs </b>(<span class="qlink_container"><a class="external_link" data-qt-tooltip="ledgerlabs.com" data-tooltip="attached" href="https://ledgerlabs.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">Ledger Labs - Expert</a></span> <span class="qlink_container"><a class="external_link" data-qt-tooltip="ledgerlabs.com" data-tooltip="attached" href="https://ledgerlabs.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">Blockchain Consulting</a></span>)</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px; position: relative;"><b>Brainbot Technologies </b>(<span class="qlink_container"><a class="external_link" data-qt-tooltip="brainbot.com" data-tooltip="attached" href="http://www.brainbot.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">brainbot technologies</a></span>)</li>
</ol>
<br />
<div class="qtext_para" style="color: #333333; font-family: q_serif, Georgia, Times, "Times New Roman", "Hiragino Kaku Gothic Pro", Meiryo, serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
Experts:</div>
<ol style="color: #333333; font-family: q_serif, Georgia, Times, "Times New Roman", "Hiragino Kaku Gothic Pro", Meiryo, serif; font-size: 15px; list-style-image: initial; list-style-position: initial; margin: 0px 2em 0px 0px; padding: 0px;">
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Vitalik Buterin</b> - Co-Founder of Ethereum, Co-founder of Bitcoin Magazine.</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><b>Nick Szabo</b></li>
<li style="margin: 0px 0px 0px 2em; padding: 0px 0px 0.7em; position: relative;"><span class="qlink_container"><a class="external_link" data-qt-tooltip="antonopoulos.com" data-tooltip="attached" href="https://antonopoulos.com/" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank"><b>Andreas M. Antonopoulos</b></a></span><b> </b>-<b> </b>Author of Mastering Bitcoin, first comprehensive book about how it all works.</li>
<li style="margin: 0px 0px 0px 2em; padding: 0px; position: relative;"><b>Broke Pierce</b> - Managing Partner at <span class="qlink_container"><a class="external_link" data-qt-tooltip="twitter.com" href="https://twitter.com/hashtag/Blockchain?src=hash" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">Blockchain</a></span> Capital & Chairman of <span class="qlink_container"><a class="external_link" data-qt-tooltip="twitter.com" href="https://twitter.com/hashtag/Bitcoin?src=hash" rel="noopener nofollow" style="background-attachment: initial; background-clip: initial; background-image: url("//qsf.ec.quoracdn.net/-3-images.new_grid.external_link.svg-26-aef78ead48f1f1e2.svg"); background-origin: initial; background-position: right 0.3em; background-repeat: no-repeat; background-size: 10.5px; color: #2b6dad; padding-right: 15px; text-decoration-line: none;" target="_blank">Bitcoin</a></span> Foundation.</li>
</ol>
<div>
<span style="color: #333333; font-family: q_serif, Georgia, Times, Times New Roman, Hiragino Kaku Gothic Pro, Meiryo, serif;"><span style="font-size: 15px;"><br /></span></span></div>
<br />
The next disruptive technology.<br />
<br />
The below list of URL's to help out to learn about Ehterium BlockChain<br />
<br />
<br />
<br />
<ul style="text-align: left;">
<li>https://remix.ethereum.org/</li>
<li>https://remix.readthedocs.io/en/latest/</li>
<li>https://metamask.io/</li>
</ul>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-75824318146255579432017-09-11T15:18:00.003+05:302017-09-11T15:18:46.056+05:30Oracle E-Business Suite 12.2.7 - Released<div dir="ltr" style="text-align: left;" trbidi="on">
E-Business Suite Development is pleased to announce the availability of Oracle E-Business
Suite 12.2.7. This latest release, which continues a pattern of ongoing functional and
technical innovation, is organized around these key investment drivers:<br />
<br />
<br />
http://www.oracle.com/us/products/applications/ebs-ga-2017-09-08-3876665.pdf</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-85331808901739305982017-08-31T19:37:00.001+05:302017-08-31T19:37:50.024+05:30Custom Lot Number Generation - Oracle E-Business Inventory<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="kmContent" style="font-size: x-small;"><br /></span>
<span class="kmContent" id="kmPgTpl:r1:ot71" style="font-size: x-small;">To do this:<br />1. Select the lot number generation option as "User-Defined"<br />2. Write the code to generate the lot number as per the business need in the procedure<br /> generate_lot_number<br />3. This procedure is found in the file "INVUDLGS.pls"</span><br />
<span class="kmContent" style="font-size: x-small;">4. Package Name : user_pkg_lot , method name : generate_lot_number</span><br />
<span class="kmContent" style="font-size: x-small;"><br /></span></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-85232109855611765472017-08-25T20:26:00.003+05:302017-08-25T20:27:38.120+05:30Value Sets - Special Value Sets - <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
One of the frequent issues faced mostly in SQL/PLSQL is based on Date Formats.<br />
<br />
Following is one of the code snippet to validate From Date/ To Date with users using Different Date Formats.<br />
<br />
<br />
FND PLSQL " DECLARE<br />
<br />
l_char varchar2(25) := :!value ;<br />
l_count NUMBER := 0;<br />
<br />
l_value DATE := TO_DATE(l_char,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'), 'NLS_DATE_LANGUAGE = AMERICAN') ;<br />
<br />
BEGIN<br />
SELECT trunc(l_value - to_date(':$FLEX$.XX_FROM_DATE','YYYY/MM/DD HH24:MI:SS'))<br />
INTO l_count<br />
FROM dual;<br />
<br />
IF l_count > 365<br />
<br />
THEN<br />
<span style="white-space: pre;"> </span> fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;<br />
<span style="white-space: pre;"> </span> fnd_message.set_token( 'MESSAGE', 'Date Difference Should Not Be Greater Than 365 Days' );<br />
<span style="white-space: pre;"> </span> fnd_message.raise_error ;<br />
ELSIF l_count <1 THEN<br />
fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;<br />
fnd_message.set_token( 'MESSAGE', 'To Date Should Be Greater Than From Date');<br />
fnd_message.raise_error ;<br />
END IF;<br />
<span style="white-space: pre;"> </span><br />
END;"</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-27330308724988280122017-07-20T12:42:00.003+05:302017-07-20T14:05:23.837+05:30Oracle ERP- Supplier Audit - Important Points<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; font-weight: bold; text-align: right;">After Supplier Is Updated, Alert On AP_SUPPLIERS Table Is Triggered Twice (Doc ID 1969553.1)</span><br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14.3px; font-weight: bold; text-align: right;"><br /></span>
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">As part of enabling Oracle Alert functionality, the following trigger is created on the AP_SUPPLIERS table:</span><br />
<br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">create trigger TEST_SUPP_UPD_ALERT_AU AFTER UPDATE on AP.AP_SUPPLIERS for each row</span><br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">begin</span><br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">insert into XXTEST_SUPP_ALERT_UPD values (:new.VENDOR_ID, :new.LAST_UPDATE_DATE);</span><br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">end;</span><br />
<br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">When supplier data is updated through the Supplier Master pages, multiple rows are inserted into the table XXTEST_SUPP_ALERT_UPD. The expectation is that only one row would be inserted.</span><br />
<br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;" />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: x-small;">Please explain / provide fix.</span></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-88722189073845038952017-05-12T12:39:00.003+05:302017-05-12T12:39:22.100+05:30How to know the Oracle Cloud Version (Fusion ERP Version)<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-GJ_zlfivK-c/WRVfd5G8I_I/AAAAAAAAHeU/xYhAfnkgoHU-gx-YUx8K0iAgyPiwxWxpwCLcB/s1600/image001.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="130" src="https://1.bp.blogspot.com/-GJ_zlfivK-c/WRVfd5G8I_I/AAAAAAAAHeU/xYhAfnkgoHU-gx-YUx8K0iAgyPiwxWxpwCLcB/s320/image001.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-Ev6J_3pfsoc/WRVfdpKd2YI/AAAAAAAAHeQ/9sZsCc75gQMIojaDWWWRt7oQy5z1joN4wCLcB/s1600/image002.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://4.bp.blogspot.com/-Ev6J_3pfsoc/WRVfdpKd2YI/AAAAAAAAHeQ/9sZsCc75gQMIojaDWWWRt7oQy5z1joN4wCLcB/s320/image002.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-322XkXGYzro/WRVfd_ikLLI/AAAAAAAAHeY/9Z7nEeBjeJQEm10adDj-g1blie7uiNV7ACLcB/s1600/image003.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://3.bp.blogspot.com/-322XkXGYzro/WRVfd_ikLLI/AAAAAAAAHeY/9Z7nEeBjeJQEm10adDj-g1blie7uiNV7ACLcB/s320/image003.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-fRB9XpI2Tf0/WRVfeE9aaBI/AAAAAAAAHec/4toBbZt42TIt7zAB8HfHe3vKqw3P92KewCLcB/s1600/image004.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="53" src="https://3.bp.blogspot.com/-fRB9XpI2Tf0/WRVfeE9aaBI/AAAAAAAAHec/4toBbZt42TIt7zAB8HfHe3vKqw3P92KewCLcB/s320/image004.jpg" width="320" /></a></div>
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-4518354598691415752017-04-27T13:52:00.003+05:302017-04-27T13:52:50.359+05:30Oracle SQL to validate non-english characters<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
We had a requirement to validate non-english characters in the data.<br />
<br />
Well, i used standard function <b>regexp_like(column, '[A-Z]') </b>considering those characters which are not replaced by this function are non-english, to my surprise it is not considering turkish characters.<br />
<br />
<b><span style="font-size: large;">select REGEXP_replace(UPPER('rn Aıklaması'), '[A-Z]','')Test from dual ;</span></b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-VUEAtd_MPu0/WQGnVubhI0I/AAAAAAAAHQE/1z2IrcWq-tgcnzt8D_orVxGrKsDhISyZwCLcB/s1600/First.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="169" src="https://2.bp.blogspot.com/-VUEAtd_MPu0/WQGnVubhI0I/AAAAAAAAHQE/1z2IrcWq-tgcnzt8D_orVxGrKsDhISyZwCLcB/s320/First.JPG" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Alternate Solution for this problem is using : <span style="background-color: #eff0f1; color: #303336; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; white-space: inherit;">asciistr </span>Function<br />
<br />
If input is equal to asciistr function, then it is non-english.<br />
<br />
<b><span style="font-size: large;">select count(*) from dual where 'ĞEĞİK' <> asciistr('ĞEĞİK') ;</span></b><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-CfJUHNRcu-Y/WQGpsUgJ2uI/AAAAAAAAHQY/RFh1fovkocEASzufn0m_0KdsK8Lggw6qgCLcB/s1600/Test2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="66" src="https://2.bp.blogspot.com/-CfJUHNRcu-Y/WQGpsUgJ2uI/AAAAAAAAHQY/RFh1fovkocEASzufn0m_0KdsK8Lggw6qgCLcB/s320/Test2.JPG" width="320" /></a></div>
<br />
<br />
<br />
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-12129999709377578562017-04-26T16:24:00.003+05:302017-04-26T16:24:53.512+05:30Oracle E-Business Suite : Purchase Order Type Lookup Code<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b style="color: #222222; font-family: Tahoma, sans-serif; font-size: 18.07px;">PO_HEADERS_ALL</b><br />
<div style="color: #222222; font-family: Tahoma, sans-serif; font-size: small;">
The following table describes column information for the PO_HEADERS_ALL table.</div>
<table border="1" cellpadding="4" cellspacing="0" style="font-family: Tahoma, sans-serif; font-size: small;" summary="table is summarized in text"><caption style="font-weight: bold; width: auto;"></caption><tbody>
<tr bgcolor="#E0E0E0" class="HEADER" valign="CENTER"><th scope="col" style="text-align: left; vertical-align: bottom;"><b>Column Name</b></th><th scope="col" style="text-align: left; vertical-align: bottom;"><b>Null</b></th><th scope="col" style="text-align: left; vertical-align: bottom;"><b>Type</b></th><th scope="col" style="text-align: left; vertical-align: bottom;"><b>Comments</b></th></tr>
<tr valign="TOP"><td style="vertical-align: top;">PO_HEADER_ID</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">Primary key</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">AGENT_ID</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">Foreign key: HR_EMPLOYEES</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">TYPE_LOOKUP_CODE</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">VARCHAR2(25)</td><td style="vertical-align: top;">Foreign Key: PO_LOOKUP_ CODES</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">LAST_UPDATE_DATE</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">DATE</td><td style="vertical-align: top;">N/A</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">LAST_UPDATED_BY</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">N/A</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">SEGMENT1</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">VARCHAR2(20)</td><td style="vertical-align: top;">PO number</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">SUMMARY_FLAG</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">VARCHAR2(1)</td><td style="vertical-align: top;">N</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">ENABLED_FLAG</td><td style="vertical-align: top;">NOT NULL</td><td style="vertical-align: top;">VARCHAR2(1)</td><td style="vertical-align: top;">Y</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">VENDOR_ID</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">Foreign key: PO_VENDORS</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">VENDOR_SITE_ID</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">Foreign key: PO_VENDOR_SITES</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">TERMS_ID</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">NUMBER</td><td style="vertical-align: top;">N/A</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">FREIGHT_TERMS_ LOOKUP_CODE</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">VARCHAR2(25)</td><td style="vertical-align: top;">Foreign key: PO_LOOKUP_ CODES</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">CURRENCY_CODE</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">VARCHAR2(15)</td><td style="vertical-align: top;">N/A</td></tr>
<tr valign="TOP"><td style="vertical-align: top;">APPROVED_FLAG</td><td style="vertical-align: top;"> </td><td style="vertical-align: top;">VARCHAR2(1)</td><td style="vertical-align: top;">Y</td></tr>
</tbody></table>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0in;
margin-right:0in;
margin-bottom:8.0pt;
margin-left:0in;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{font-family:"Calibri",sans-serif;}
.MsoPapDefault
{margin-bottom:8.0pt;
line-height:107%;}
/* Page Definitions */
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<br />
<div class="WordSection1">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-autospace: none;">
<span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-autospace: none;">
<span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-autospace: none;">
<span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">select</span><span style="background: white; font-family: "Courier New"; font-size: 18pt;"> </span><span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">*</span><span style="background: white; font-family: "Courier New"; font-size: 18pt;">
</span><span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">from</span><span style="background: white; font-family: "Courier New"; font-size: 18pt;"> PO_LOOKUP_CODES </span><span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">where</span><span style="background: white; font-family: "Courier New"; font-size: 18pt;">
lookup_type</span><span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">=</span><span style="background: white; color: red; font-family: "Courier New"; font-size: 18.0pt;">'PO TYPE'</span><span style="background: white; color: blue; font-family: "Courier New"; font-size: 18.0pt;">;</span><span style="background: white; font-family: "Courier New"; font-size: 18pt;">
</span><span style="font-family: "Segoe UI", sans-serif; font-size: 10pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-autospace: none;">
<span style="font-family: "Segoe UI", sans-serif; font-size: 10pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-autospace: none;">
<span style="font-family: "Segoe UI", sans-serif; font-size: 10pt;"><br /></span></div>
</div>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-72432743619537164682017-03-17T17:47:00.001+05:302017-03-17T17:47:05.929+05:30Oracle E-Business Suite Supplier / Supplier Site Related API's Queries<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
API To Update Supplier/Supplier Site<br />
<br />
<br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14.3px; font-weight: bold; text-align: right;">R12: AP: New Supplier Update API's in Oracle Payables (Doc ID 1618099.1)</span></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-66343218183995317692017-02-24T10:00:00.003+05:302017-02-24T10:00:49.234+05:30OAF- How to get Segment values from KFF<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Following is the code snippt, which can be used to get segment values from the selected KFF.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Iw5_mEWaxFw/WK-2qs_GzgI/AAAAAAAAGt4/Rr0kYAlhyC0r88f6ZCWyZH3iiKXgVFGfwCLcB/s1600/KFF1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://1.bp.blogspot.com/-Iw5_mEWaxFw/WK-2qs_GzgI/AAAAAAAAGt4/Rr0kYAlhyC0r88f6ZCWyZH3iiKXgVFGfwCLcB/s320/KFF1.png" width="320" /></a></div>
<br />
///Below is the PFR Code on Save button<br />
<br />
OAKeyFlexBean kffbean= (OAKeyFlexBean)webBean.findIndexedChildRecursive("kffID"); //Get the KFF bean<br /><br /> KeyFlexfield kff=(KeyFlexfield)kffbean.getAttributeValue(OAWebBeanConstants.FLEXFIELD_REFERENCE); //Getting the Reference Value<br /> if(kff!=null){<br /> if(kff.getSegment(1).getValue()!=null)<br /> {<br /> String value = kff.getSegment(1).getValue().toString(); //This returns Value object so we can just see a object<br /> String name = kff.getSegment(1).getName(); // This returns the Segment name attached<br /> String inputValue = kff.getSegment(1).getInputValue(); // This returns the Segment value when user gives as input<br /> <br /> System.out.println("Value -->"+ value);<br /> System.out.println("name -->"+ name);<br /> System.out.println("inputValue -->"+ inputValue);<br /> }<br /> }<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-cOMhVwx5k3k/WK-24ruhPAI/AAAAAAAAGt8/ItLZh5GHbxs6sjyKdHSTdPIeOYqtDY1BACLcB/s1600/KFF2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="115" src="https://3.bp.blogspot.com/-cOMhVwx5k3k/WK-24ruhPAI/AAAAAAAAGt8/ItLZh5GHbxs6sjyKdHSTdPIeOYqtDY1BACLcB/s320/KFF2.png" width="320" /></a></div>
</div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com1tag:blogger.com,1999:blog-13511316.post-48873309713661213522017-02-13T16:38:00.000+05:302017-02-13T16:38:50.700+05:30Tips in ADF - for developers from OAF background<div dir="ltr" style="text-align: left;" trbidi="on">
TIP # 1. How to find the backing bean of an ADF Page ?<br />
(In OAF, it is very easy to get the CO name which is used in a given page/region).<br />
<br />
In ADF -- Controller logic is handled through Taskflows.<br />
<br />
For a given page : check the below way to get which Controller(Taskflow) is used.<br />
<br />
Following is the page and its managed bean information.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-yOGD6pRbI1w/WKFyvVqgQmI/AAAAAAAAGn4/zT6JNeI06iEf3QyHmqOcIRWq6bo0GB46gCLcB/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://1.bp.blogspot.com/-yOGD6pRbI1w/WKFyvVqgQmI/AAAAAAAAGn4/zT6JNeI06iEf3QyHmqOcIRWq6bo0GB46gCLcB/s320/image001.png" width="247" /></a></div>
<br />
Following is the screen for the Page file.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-cxm80jZOL9A/WKFyvYGeLfI/AAAAAAAAGnw/0cXaoItHzyMEOr6K6ructI3_-Cwx7NtFQCLcB/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="152" src="https://2.bp.blogspot.com/-cxm80jZOL9A/WKFyvYGeLfI/AAAAAAAAGnw/0cXaoItHzyMEOr6K6ructI3_-Cwx7NtFQCLcB/s320/image003.png" width="320" /></a></div>
Following is the content of page file in XML Code.<br />
In the below code : (if you compare with OAF - which is based on UIX-User interface for XML) -- This is based jspx ; xml with jsp.<br />
Top level bean in JSPX is : JSP:Root followed by : f:view<br />
<br />
<f:view><br />
<af:document id="d1" binding="#{backingBeanScope.backing_ADFRegionsPG.d1}"><br />
<af:form id="f1" binding="#{backingBeanScope.backing_ADFRegionsPG.f1}"></af:form><br />
</af:document><br />
</f:view><br />
<br />
In f:view -- other tag is : af:document <br />
this is attached to bean -- This is bean which is attached to this page.<br />
CTRL+CLICK on : ADFRegionsPG.<b>d1</b> -- Navigates to <b>ADFRegionsPG.java</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-DWPWmV-Sg_o/WKFyvTeyQkI/AAAAAAAAGn0/eQf4aTHfF_0HOkhOQXPTuoFMfkubBaOEQCLcB/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="https://1.bp.blogspot.com/-DWPWmV-Sg_o/WKFyvTeyQkI/AAAAAAAAGn0/eQf4aTHfF_0HOkhOQXPTuoFMfkubBaOEQCLcB/s320/image005.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-UkMeMQnx2oo/WKFyv4DWJHI/AAAAAAAAGoA/qfqwxokaVOA_gdQU04fPawgBuKUa_70EACLcB/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://2.bp.blogspot.com/-UkMeMQnx2oo/WKFyv4DWJHI/AAAAAAAAGoA/qfqwxokaVOA_gdQU04fPawgBuKUa_70EACLcB/s320/image007.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-BRtLU-pLT9I/WKFyv3a2OZI/AAAAAAAAGn8/FBxaOsEokLk9Jwcp6giKzolyiuvqNSy6wCLcB/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="158" src="https://2.bp.blogspot.com/-BRtLU-pLT9I/WKFyv3a2OZI/AAAAAAAAGn8/FBxaOsEokLk9Jwcp6giKzolyiuvqNSy6wCLcB/s320/image009.png" width="320" /></a></div>
<br />
Backing bean information : about : package, class details of it.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-MhjV4oi30MI/WKFywDeCHcI/AAAAAAAAGoE/FyPltIyaN38F14vMsR2C6AVSyu-hn3K8gCLcB/s1600/image011.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="141" src="https://2.bp.blogspot.com/-MhjV4oi30MI/WKFywDeCHcI/AAAAAAAAGoE/FyPltIyaN38F14vMsR2C6AVSyu-hn3K8gCLcB/s320/image011.png" width="320" /></a></div>
<br />
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0tag:blogger.com,1999:blog-13511316.post-30662714260064308702017-01-10T15:06:00.000+05:302017-01-10T15:06:15.132+05:30Basic Level Comparison of OAF vs ADF - MVC Layer Execution<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Hello All,<br />
<br />
In this i will try to highlight how the page execution happens and the framework differences between OAF and ADF.<br />
<br />
Consider the below scenario :<br />
<br />
Display Department Data in the output.<br />
<br />
-----------------------------------------------------------------------------------------<br />
<b>From OAF Perspective</b><br />
-----------------------------------------------------------------------------------------<br />
-----------------------------------------------------------------------------------------<br />
* Following files would be required to display the data.<br />
<b>Model</b><br />
SampleAM.xml<br />
SampleAMImpl.java<br />
DeptVO.xml<br />
DeptVOImpl.java<br />
<br />
<b>View </b><br />
DeptDetailsPG.xml<br />
<br />
<b>CO </b><br />
DeptpDetailsCO.java<br />
-----------------------------------------------------------------------------------------<br />
-----------------------------------------------------------------------------------------<br />
<b>From ADF Perspective</b><br />
<b><br /></b>
<b>Model</b><br />
SampleAM.xml<br />
SampleAMImpl.java<br />
DeptVO.xml<br />
DeptVOImpl.java<br />
<br />
<b>View </b><br />
<strike>DeptDetailsPG.xml</strike><br />
DeptDetailsPG.jspx<br />
DeptDetailsPGPageDef.xml<br />
<br />
<strike>CO </strike><br />
<strike> DeptpDetailsCO.java</strike><br />
<br />
-----------------------------------------------------------------------------------------<br />
-----------------------------------------------------------------------------------------<br />
<br /></div>
Sridhar Yerramhttp://www.blogger.com/profile/06904887781190622545noreply@blogger.com0