6 Replies Latest reply on Jul 24, 2019 6:09 PM by User393354

    Customizing / Personalization of Record History (Who columns) in Forms

    User393354
    User393354 Jul 23, 2019 1:15 PM

      Hi,

       

      We have requirement to customize / personalize the WHO Column, specifically LAST_UPDATED_BY. As of now LAST_UPDATED_BY displaying the user name.

        Instead customer would like to see user description against LAST UPDATED BY.

       

        For eg:

       

      select USER_NAME, DESCRIPTION from fnd_user

      where 1=1

      and user_name = 'AA313'

       

      USER_NAME   DESCRIPTION

      AA313               Matthew Zeson

       

      As of now:

       

      Created By:  AA313

      Creation Date:  01-APR-2019 19:43:38

      Table Name:  OE_ORDER_HEADERS_V

      Updated By:  AA313

      Update Date:  15-MAY-2019 19:57:54

      System Logon:  UNKNOWN

      Terminal:  Concurrent

       

      Expected:

       

      Created By:  AA313

      Creation Date:  01-APR-2019 19:43:38

      Table Name:  OE_ORDER_HEADERS_V

      Updated By:  Matthew Zeson

      Update Date:  15-MAY-2019 19:57:54

      System Logon:  UNKNOWN

      Terminal:  Concurrent

       

       

      Appreciate your inputs. Thank you!

       

      Regards,

      Ram

      • 279 Views
      • Tags:
        • 1. Re: Customizing / Personalization of Record History (Who columns) in Forms
          Doifode
          Doifode Jul 24, 2019 3:24 AM (in response to User393354)

          hi,

           

          Is this requirement for specific page or for all pages?

           

          For specific page you may attempt form personalization after going through the specific page code and finding out exactly how many tables last updated by getting updated and then do the form personalization to update those specific tables who columns with description.

          • 2. Re: Customizing / Personalization of Record History (Who columns) in Forms
            User393354
            User393354 Jul 24, 2019 8:04 AM (in response to Doifode)

            Hi,

             

              Requirement is in Forms (eg: Order Organizer screen), not OAF pages. Per documentation, I see FNDSQF pll will hold the code  to set WHO columns (SET_WHO).

             

              But how to overwrite or customize?

             

            Regards,

            Ram

            • 3. Re: Customizing / Personalization of Record History (Who columns) in Forms
              dmillerp
              dmillerp Jul 24, 2019 12:09 PM (in response to User393354)

              Personally, I think this is a bad idea...and I think Oracle would agree.  Rather than do that, why would you not have any reports and/or processes that you are requiring that information just include a fetch of this description where needed?

              • 4. Re: Customizing / Personalization of Record History (Who columns) in Forms
                Bommi
                Bommi Jul 24, 2019 3:45 PM (in response to User393354)

                Hi,

                 

                With my knowledge and experience, I say as BIG NO for this customization.

                 

                Because

                1. If you are customizing even a single form, it doesn't mean only one form or only one table will effect. There may be many tables that will interact with this table and they may also effect.

                2. You are saying customizing the Oracle Standard table OE_ORDER_HEADERS_V, where Oracle WILL NOT support if there are any issues in future which not only directly effects only this table, but also effects this table from other tables and also vice versa

                     This is a very serious issue

                3. Some times Description will not available for all FND_USERs, intentionally or accidentally or because of users habituated not to enter. In this case it is very serious issue

                 

                so, my simple suggestion is convince client to not do this customization

                 

                Regards,

                Bommi

                • 5. Re: Customizing / Personalization of Record History (Who columns) in Forms
                  User393354
                  User393354 Jul 24, 2019 6:03 PM (in response to dmillerp)

                  Hi,

                   

                    Kindly note that am just trying to manipulate the Last Updated By to be more descriptive (Matthew Zeson) which would be employee name rather user name (AA313)

                    which is not rational to identify the person.

                   

                     For eg: In a PO form, if a supervisor would like to see who recently updated current PO Line in PO Summary screen, then the Record History of that PO Line is expected

                                  to display User description (Matthew Zeson) against Last Updated By, instead of user name (AA313).

                   

                     This change is expected to work across every form in the application.

                   

                  Regards,

                  Ram

                  • 6. Re: Customizing / Personalization of Record History (Who columns) in Forms
                    User393354
                    User393354 Jul 24, 2019 6:09 PM (in response to Bommi)

                    Hi Bommi,

                     

                      Kindly note that am just trying to manipulate the Last Updated By to be more descriptive (Matthew Zeson) which would be employee name rather user name (AA313)

                      which is not rational to identify the person in Help --> Record History window.

                     

                       For eg: In a PO form, if a supervisor would like to see who recently updated current PO Line in PO Summary screen, then the Record History of that PO Line is expected

                                    to display User description (Matthew Zeson) against Last Updated By, instead of user name (AA313).

                     

                       This change is expected to work across every form in the application.

                     

                    Also, here clarified your concerns inline to your points below.

                     

                    1. If you are customizing even a single form, it doesn't mean only one form or only one table will effect. There may be many tables that will interact with this table and they may also effect.    -  We are not customizing the seeded screen. We are trying to find option to personalize or customize

                    2. You are saying customizing the Oracle Standard table OE_ORDER_HEADERS_V, where Oracle WILL NOT support if there are any issues in future which not only directly effects only this table, but also effects this table from other tables and also vice versa

                         This is a very serious issue

                     

                                - NO, please read my explanation in the beginning of the reply. We are not touching seeded table, we would like to personalize or customize WHO columns in Records History window.

                     

                    3. Some times Description will not available for all FND_USERs, intentionally or accidentally or because of users habituated not to enter. In this case it is very serious issue

                            Valid point, but in case description is NULL, then username will be displayed.

                     

                    Regards,

                    Ram