X

The Latest Technology Stack News Directly from EBS Development

How to Define Table-Validated Lists of Values in Web ADI

I am pleased to announce a new video tutorial on defining table-validated Lists of Values using the Oracle Web Application Desktop Integrator (Web ADI).  One of the common requirements for List of Values in a Web Application Desktop Integrator spreadsheet is to display user-friendly values in a desktop-based spreadsheet but upload a corresponding identifier or code to the E-Business Suite. You can learn how to do this in this new tutorial.

Using the List of Values component with Web ADI

Oracle Web Application Desktop Integrator supports Oracle E-Business Suite’s user interface components such as List of Values (LOV) in spreadsheets. In a Web Application Desktop Integrator spreadsheet, a List of Values can be displayed as a pop-list or as a standard Search and Select view. A table-validated List of Values is a type of List of Values that not only displays set of values from a table, but also ensures that the value uploaded to Web Application Desktop Integrator Interface is valid. 

The Desktop Integration Framework allows you to create custom desktop integrators for Web Application Desktop Integrator in E-Business Suite Release 12. You can define table-validated List of Values components for data uploaded from spreadsheets to the Oracle E-Business Suite.

 

 

What is in this tutorial?

This step-by-step video tutorial walks you through the following:

 

  1. Prepare Database Objects
  2. Create Custom Integrator
  3. Define Table List of Values Component
  4. Associate Table List of Values Component to Interface Attribute
  5. Define Layout for Integrator
  6. Preview Integrator
  7. Verify uploaded data

Your feedback is welcome

This is our first video tutorial and we're very interested in feedback.  Please post a comment here or drop us an email directly with your thoughts.

References

 

 

Related Articles

 

 

 

Join the discussion

Comments ( 13 )
  • Wim van der Veer Thursday, July 11, 2013

    Hello,

    Very nice demo and good explanation of the new UI for R12.1.3.

    I have noticed that Web ADI framework supports dependent LOV, and Oracle-seeded integrators use them. However, as of Oracle E-Business Suite Release 12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV from UI.

    So my question is, how can I create a dependency between two custom LOV´s, do I need to use an API or add a code directly into a certain BNE table. Please let me know how we can create this in R12.1.3 from a technical point of view.

    Thanks and regards,

    Wim


  • Rekha Ayothi Thursday, July 11, 2013

    Thank you, Wim.

    You got it right - Web ADI as a framework supports dependent LOV. This functionality is currently available to Oracle seeded integrators only. As of today, Desktop Integration Framework does not support creation of dependent LOV. And hence, it is not available for custom integrators.

    Please note, we do not recommend any other means of defining custom integrators - such as, direct insertion to BNE tables.

    Please log an enhancement request in My Oracle Support - this will help in tracking your requirement. And, forward me the ER number.

    Thanks,

    Rekha


  • Madhubabu Wednesday, September 25, 2013

    <BNEBOOT><item><name>tracelevel</name><value>3</value></item><item><name>host</name><value>http://rtcsrv.apsrtc.com

    See this is the Ist coloum of my file WebADI.xls

    I am newbie to Oraapps. I am working linux client and installed msoffice 2007 using crossover and made the setup

    Please help as early as


  • guest Wednesday, December 4, 2013

    Hi,

    Nice tutorial, but when I try to create Component type LOV Table, I get following Error:

    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)

    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)

    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    at _OA._jspService(_OA.java:212)

    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)

    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)

    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)

    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

    at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)

    at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)

    at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)

    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

    at java.lang.Thread.run(Thread.java:738)

    ## Detail 0 ##

    java.lang.NullPointerException

    at oracle.apps.bne.wdf.component.webui.BneCreateComponentCO.createOrModifyComponents(BneCreateComponentCO.java:356)

    at oracle.apps.bne.wdf.component.webui.BneCreateComponentCO.processFormRequest(BneCreateComponentCO.java:115)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)

    at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)

    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    at _OA._jspService(_OA.java:212)

    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)

    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)

    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)

    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

    at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)

    at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)

    at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)

    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

    at java.lang.Thread.run(Thread.java:738)

    java.lang.NullPointerException

    at oracle.apps.bne.wdf.component.webui.BneCreateComponentCO.createOrModifyComponents(BneCreateComponentCO.java:356)

    at oracle.apps.bne.wdf.component.webui.BneCreateComponentCO.processFormRequest(BneCreateComponentCO.java:115)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)

    at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)

    at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)

    at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)

    at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)

    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)

    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    at _OA._jspService(_OA.java:212)

    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)

    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)

    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)

    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

    at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)

    at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)

    at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)

    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

    at java.lang.Thread.run(Thread.java:738)


  • Rekha Ayothi Wednesday, December 4, 2013

    Hello Guest,

    Thank you, and I am sorry to hear that you are facing this issue. Have you applied the consolidated patch mentioned here https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web

    If you are still facing this issue, please log formal service request in My Oracle Support, one of our Support Engineers will assist you. Feel free to forward SR number.

    Thanks,

    Rekha


  • guest Thursday, February 27, 2014

    Hi,

    The dependent LOV functionality is available thru UI now? we have many requirements to have dependent LOvs for validation.


  • Rekha Ayothi Thursday, February 27, 2014

    Hello Guest,

    As of now, ability to define dependent LOV from Desktop Integration Framework UI is not available. Please file a formal enhancement request in My Oracle Support and, forward me the Service Request number.

    Thanks,

    Rekha


  • guest Tuesday, September 2, 2014

    Hi Rekha,

    I have created lov in web adi using BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV

    but presently i need to delete the lov.

    could you specify how to delete the lov in web adi?

    Regards,

    Raj Kiran


  • guest Monday, November 24, 2014

    Where is the video for this. I don't see anything! No link URL nothing?


  • Steven Chan Monday, November 24, 2014

    Hello, Guest,

    Sorry about that. Our blog seems to have lost its mind. The link to Youtube is back. You can click on the screenshot in the article to get to the video.

    Regards,

    Steven


  • guest Tuesday, June 23, 2015

    Hi, excellent post and very informative video.

    I am in the process of trying to migrate my WEB ADIs across environments and attempting this using FNDLOAD to generate .ldt files. I know that this can be used to export Integrators, Layouts and Mappings but is it possible to migrate LOV Components, and if so, how could this be achieved?

    Bill


  • Rekha Ayothi Wednesday, June 24, 2015

    Dear Guest,

    LOV component definition is exported/ imported as part of Integrator definition. Please refer following document to download and upload integrator definition:

    http://docs.oracle.com/cd/E26401_01/doc.122/e22005/T544562T550952.htm#5609235

    Thanks,

    Rekha


  • guest Thursday, August 11, 2016

    Hi,

    Thanks for this useful demo and very nice explanation. I have created custom integrator and have to validate few fields with lookup values. While creating component for lookup validation. I do see that lookup is appearing fine with defined values but while selecting the lookup value the value does not get selected.

    I tried recreating again but no luck. Any pointers will be much appreciated.

    Thanks

    Ahmed


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services