1 Reply Latest reply on Feb 8, 2010 3:01 PM by 747405

    Addition of one column in LOV through Form Personalization

    669555
      Hi

      While approving a purchase order when we click on Forward check box the forward to field becomes enabled and it has the LOV containing employee names and employee numbers. I want to add another column in this LOV for employee positions through form personalization.
      Can any one guide me how to do this.

      Regards
        • 1. Re: Addition of one column in LOV through Form Personalization
          747405
          Hello,
          To set another LOV, you should change the property of your combobox, named LOV_NAME with Forms perso, but you need some PL SQL code to create a new LOV.
          See this example : [http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/custom-lov-using-custompll-883870]

          One pre-requisite is that your new LOV should have the same number of rows and the same datatype, so I'm afraid you won't be able to do this just using Forms perso

          Kind regards,
          Xavier