5 Replies Latest reply: May 15, 2013 10:45 AM by Vik Kumar-Oracle RSS

    How to create a LOV for a ESS Job Parameter

    Ankit.Bang-Oracle
      Hi,

      I have an ESS job and for one of the parameter , I want to provide users to select from the static List of values.

      What is the easiest possible approach and how to achieve that.


      Thanks in Advance,
      Ankit
        • 1. Re: How to create a LOV for a ESS Job Parameter
          Vik Kumar-Oracle
          Ankit

          Can you please elaborate a bit more about your current app to understand better and advise accordingly.

          Vik
          • 2. Re: How to create a LOV for a ESS Job Parameter
            Ankit.Bang-Oracle
            Sure,

            We have a custom ESS Job which loads the data into one table into Fusion using SQL*Loader. In this Job we have a parameter which gives the user a flexibility to load all or an entity specific data for ex: Locations, Organizations etc.

            What we would like to do is to attach a LOV to this Parameter, so that whenevelr an user try to submit the Job they should be able to select from the list of values. (Similar to EBS where we create a independent valueset and attach it to the Concurrent Program parameter).

            Thanks,
            Ankit
            • 3. Re: How to create a LOV for a ESS Job Parameter
              Ankit.Bang-Oracle
              Hi,

              Does any one got any solution for this?

              will appreciate a quick help.

              Thanks,
              Ankit
              • 4. Re: How to create a LOV for a ESS Job Parameter
                Ankit.Bang-Oracle
                Hi,

                Is there any update over the same?

                We are struggling to get this done.

                Any help would be appreciated.

                Thanks,
                Ankit
                • 5. Re: How to create a LOV for a ESS Job Parameter
                  Vik Kumar-Oracle
                  Sorry I missed it somehow. So, assuming currently the job parameter is a text box. Here, is what you can do.

                  1. Create a new Fusion application with a model project in it. Then Create a new view object with data based on static values type in the JDeveloper.
                  2. Create a new Fusion Applications Customization Application based on the exploded EAR
                  3. Open the page you want to change by customize option and then keep a note of the current binding value from the ess parameter inputText and then delete this field from UI.
                  4. Shuttle the newly created vo in the AM used for this page. For this to be available you will need to add your project created in step 1 as a library to the Customization application.
                  5. Now expand the data controls and drop the attribute from the VO as a LOV on your page and copy the value binding from the deleted field to this one.

                  Please note that the above approach should work but I have not personally tried or tested it. Also you will need to go through the extensibility guide for setting up your environment, to understand the customization process, and deploying it to test. Extensibility guide can be found [http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e16691/toc.htm]

                  Thanks & Regards !
                  Vik

                  Fusion Apps Developer Relations
                  http://blogs.oracle.com/fadevrel

                  Please mark the response helpful or answered appropriately