Message LOV Input in OAF

In Oracle Apps Framework the messageLovInput item style is a combination of the lovInput and inlineMessage controls.

Note: messageLovInput can have two or more lovMaps created under it, and each of those lovMaps can have the Criteria Item property set. However if you set the Criteria Item property on more than one lovMap, at runtime when the user invokes an LOV, selects a value from the LOV, and then re-invokes it, both the entered criteria are used. In this case, deleting the value from the search item will not enable the user to query all records from the LOV table’s view objects.

Corresponding web bean: OAMessageLovInputBean

Import Path: import oracle.apps.fnd.framework.webui.beans.message.OAMessageLovInputBean;

Tagged , , , , , . Bookmark the permalink.
  • badri

    in my page 4 dependent lovs are there.i need handel the dependent lov througuh code

    Could u plz help me

    my lovs are country,state,city,county all the values comeing from hz_geographies table

    how to handel plz help me

    • techhoney

      Hi Badri,

      You can handle this using lov mapping.

      Thanks,
      Admin

      • badri

        i know lov mapping process but i need lov handling through code

        • techhoney

          You can use pagecontext.isLOVEvent.. for example…

          if (pageContext.isLovEvent())

          {

          String lovSourceId = pageContext.getLovInputSourceId();

          // Your Business Logic
          }

          • badri

            country lov
            select distinct country_code,geography_element1 from hz_geographies order by country_code

            state lov

            select geography_code state from hz_geographies where geography_type = ‘STATE’ order by geography_element2

            city lov

            select geography_name city,geography_element3 county from hz_geographies where geography_type = ‘CITY’ order by geography_name

            hi above queries are lov queries.how to give lov mappins and how to set form value.could u plz help me .

          • techhoney

            As you mentioned above that you know LOV mappings… with dependent LOVs you need to add a criteria item for each dependent lov..
            for example…
            Country will be criteria item for State LOV and State will be the criteria item for City LOV

          • badri

            HI
            i created one custom page inEBSDEV POS top.i need to move this custom page to EBSUAT POS top.what is the process .please advise me what are the steps

          • techhoney

            Hi Badri,

            You can move custom OAF page files from one instance to another instance by using shell script.

            Thanks,
            Admin

          • badri

            Hi
            please tell me the process or steps or give the scipt example

          • techhoney

            Hi Badri,
            Here’s an example Script..

            Suppose you want to move an OAF Page (TestPG) from DEV To UAT
            Step1:-Compile all the database related objects in UAT instance.

            Step2:-Copy the folder, which you want to migrate, from the DEV to UAT instance
            from $JAVA_TOP

            Step3:- Move the copied folder to UAT instance in $JAVA_TOP.

            Step4:- Run the xml import command from $JAVA_TOP/xxsy/oracle/apps/inv/eo/webui in unix server.
            ($JAVA_TOP/path of the page)
            java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/page_path/TestPG.xml -rootdir $JAVA_TOP -username -password -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=))(CONNECT_DATA=(SID=)))”

            Step5:-Bounce the apache.

            Step6:-Create a function in UAT as in DEV.

            Step7:-Attach that function to menu.

            And test your page..

            Also, you can write a UNIX Shell script to do all this..

            Thanks

          • badri

            Thanq

          • badri

            Hi

            Previous we are using ebs 12.0.6 now we are moved to 12.2.3

            in 12.0.6 one custom oaf working fine .now it is not working 12.2.3

            error

            Exception Details.

            oracle.apps.fnd.framework.OAException: oracle.jbo.JboException:
            JBO-29000: Unexpected exception caught: java.lang.IllegalAccessError,
            msg=oracle/jdbc/driver/OraclePreparedStatement at
            oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
            at
            oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
            at
            oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
            at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown
            Source) at
            oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
            at
            oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775)
            at
            xxusc.oracle.apps.inv.pmp.webui.XxuscChangeOrgRNCO.processRequest(XxuscChangeOrgRNCO.java:58)
            at
            oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
            at
            oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
            at
            oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1218)
            at
            oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown
            Source) at
            oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
            at
            oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)

            ……………………………………………………………

            ……………………………………………## Detail 0 ##
            java.lang.IllegalAccessError: oracle/jdbc/driver/OraclePreparedStatement
            at xxusc.oracle.apps.inv.pmp.server.XxuscPMPAMImpl.validPMMuser1(XxuscPMPAMImpl.java:531)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:606)
            at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
            at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
            at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775)
            at xxusc.oracle.apps.inv.pmp.webui.XxuscChangeOrgRNCO.processRequest(XxuscChangeOrgRNCO.java:58)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
            at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
            at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1218)
            at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
            at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
            at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
            at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)

            above error is comeing.give the solution

          • techhoney

            Hi Badri,
            Seems to be like an issue with database connectivity.

            Thanks
            Admin

          • badri

            How to list all OAF customizations of a particular instance

          • techhoney

            seems that there is no way as per now to list all user done customizations