This discussion is archived
5 Replies Latest reply: Feb 26, 2013 8:42 PM by Hussein Sawwan-Oracle RSS

Need suggestion on forms customization

MKUK Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    Bringing this thread on top
  • 2. Re: Need suggestion on forms customization
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points