4 Replies Latest reply: Oct 15, 2012 5:57 AM by User467808-Oracle RSS

    Java Lov which has Multiple columns - LOV value selected is not populated

    User467808-Oracle
      Hi Gurus,
      In my custom web ADI integrator, I have defined a new Java Validation Class and Component for a dependent field. This LOV displays 2 columns (Vendor Name and Vendor Site). This LOV displays these 2 values correctly for all resulted rows. But when any row is selected, the value is not returned to field in Spreadsheet.

      I didn't understand how to map the Lov Column (I want only one column - Vendor Site - value) into the interface column. If there is only one display name in LOV then we can set the tableSelect column to this interface column.

      My code is as below:
      String[] tableColumns = { "VENDOR_NAME", "VENDOR_SITE_CODE" };
      String[] tableHeaders = { "Vendor Name", "Vendor Site Code" };
      String[] *tableSelectColumn = { "P_VENDOR_SITE_CODE" };* // Where P_VENDOR_SITE_CODE is the interface column to where the select value has to return.

      -- and setting these values in as
      setTableData( getTableData( context.getBneWebAppsContext(), bean, parameterValues, searchCriteria ) );
      setTableColumns( tableColumns );
      setTableHeaders( tableHeaders );
      setTableSelectColumn( tableSelectColumn );


      My question here is:
      In tableColumns, I set 2 columns (VENDOR_NAME and VENDOR_SITE_CODE). In tableSelectColumn, I set only one interfaceColumn Name (P_VENDOR_SITE_CODE). How the integrator knows that which one out of 2 tableColumns map to single tableSelectColumn (P_VENDOR_SITE_CODE)?
      is it that when 'n' no. of columns are displayed in java lov then we must map them to 'n' no. of interface Columns (like, in my example, tableSelectColumn = {P_VENDOR_NAME, P_VENDOR_SITE_CODE} )?
      or
      java Lov doesn't support Multiple Columns to display?

      I found the code/answers only if one column displays in java-LOV. Please help me.


      Thanks in Advance

      Madhu
        • 1. Re: Java Lov which has Multiple columns - LOV value selected is not populated
          Ashish_Apps
          Never worked with JAVA LOV but plsql lov works fine.

          Same for AOL value sets
          • 2. Re: Java Lov which has Multiple columns - LOV value selected is not populated
            User467808-Oracle
            Ashish,
            What is the solution for my issue in plsql lov. Could you elaborate more.


            Any other knows the solution in Java Lov. Please help me.

            Thanks
            Madhu
            • 3. Re: Java Lov which has Multiple columns - LOV value selected is not populated
              967532
              Hello Madhu,
              You have to set TABLE_COLUMN_ALIAS as well, because values in TABLE_COLUMNS and TABLE_SELECT_COLUMNS are not equal.I am saying values, not number of values.
              Go through below link for more information,
              http://sagarkatratoracleapps.blogspot.com/2012/09/DependentLOVOracleWebADI.html


              --
              Sagar
              • 4. Re: Java Lov which has Multiple columns - LOV value selected is not populated
                User467808-Oracle
                Sagar,
                Thank You. It is working fine now.
                In Component class, I set the values as:

                String[] tableColumns = {  "VENDOR_SITE_CODE", "VENDOR_NAME" };
                String[] tableHeaders = { "Vendor Site Code", "Vendor Name" };
                String[] tableSelectColumn = { "P_VENDOR_SITE_CODE" };
                String[] tableColumnAlias = { "P_VENDOR_SITE_CODE", "VENDOR_NAME" };

                Thank You Once again Sagar.
                --Madhu