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

Comments:

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

Posted by Wim van der Veer on July 11, 2013 at 01:59 AM PDT #

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

Posted by Rekha Ayothi on July 11, 2013 at 11:50 AM PDT #

<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

Posted by Madhubabu on September 24, 2013 at 10:37 PM PDT #

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)

Posted by guest on December 04, 2013 at 06:22 AM PST #

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

Posted by Rekha Ayothi on December 04, 2013 at 08:53 AM PST #

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

Posted by guest on February 26, 2014 at 09:54 PM PST #

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

Posted by Rekha Ayothi on February 27, 2014 at 05:20 AM PST #

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

Posted by guest on September 02, 2014 at 07:32 AM PDT #

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

Posted by guest on November 24, 2014 at 06:46 AM PST #

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

Posted by Steven Chan on November 24, 2014 at 09:13 AM PST #

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

Posted by guest on June 23, 2015 at 05:45 AM PDT #

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

Posted by Rekha Ayothi on June 24, 2015 at 04:15 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today