5 Replies Latest reply: Feb 26, 2013 10:42 PM by Hussein Sawwan-Oracle RSS

    Need suggestion on forms customization

    MKUK
      Hi All,

      I'm new to Oracle Forms and would like to know how to go about the following on a seeded form in Oracle apps R12.

      1) On the 'Create Service' form which is available under Field Service Manager responsibility, we have a field called 'Category'. I checked the record history and it is coming from the view cs_sr_incidents_v_sec

      2) The requirement is to get this field from some other table (client has requested for a change based on their business process).

      3) Can you please advise me on how to do this? Can it be done by modifying custom.pll?

      4) Also please help me with links to any tutorial/demo explaining similar change in a seeded form of Oracle apps.
        • 1. Re: Need suggestion on forms customization
          MKUK
          Bringing this thread on top
          • 2. Re: Need suggestion on forms customization
            Srini Chavali-Oracle
            It is considered bad practice to modify a seeded form - any customizations will be overwritten by future patches/upgrades. General guidelines are provided in the documentation - http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T458264.htm#4164762

            HTH
            Srini
            • 3. Re: Need suggestion on forms customization
              Hussein Sawwan-Oracle
              Modifying seeded forms (objects) is not supported, and your changes might get lost each time you apply an application patch that overwrites this form/object.

              Customizing/Extending Oracle Applications Release 11 FAQ [ID 101048.1]
              Global Customer Services Customization Guidelines [ID 122452.1]

              If you want to change the source object that a form is reading from then you need to create your own custom form and use a different view/table.

              https://forums.oracle.com/forums/search.jspa?threadID=&q=Customization&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
              https://forums.oracle.com/forums/search.jspa?threadID=&q=Forms+AND+Customization&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

              Thanks,
              Hussein
              • 4. Re: Need suggestion on forms customization
                MKUK
                Thanks Srini & Hussein.

                I had a discussion with the stakeholders regarding the possibility of overriding of custom changes when new patch is applied. They have a process in place to carry forward the changes (manually) after patch is applied.

                So, now the question is:

                1) I want to change the data source of a LOV field. I tried personalization but the LOV field didn't accept the new values. Should I do custom.pll changes instead of personalization?

                2) In general, what approach would you suggest to replace the query used for the LOV?

                As I've very little knowledge on Forms, any help would help me research in the right direction.

                Thanks

                Edited by: MKUK on Feb 26, 2013 8:34 PM
                • 5. Re: Need suggestion on forms customization
                  Hussein Sawwan-Oracle
                  1) I want to change the data source of a LOV field. I tried personalization but the LOV field didn't accept the new values. Should I do custom.pll changes instead of personalization?

                  2) In general, what approach would you suggest to replace the query used for the LOV?

                  As I've very little knowledge on Forms, any help would help me research in the right direction.
                  Please see the docs/links.

                  How To Customize a LOV using Form Personalization ? [ID 726324.1]

                  https://forums.oracle.com/forums/search.jspa?threadID=&q=LOV+AND+Personalization&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

                  Thanks,
                  Hussein