9 Replies Latest reply on Feb 22, 2012 10:36 AM by 848964

    Form Personalization Query

    848964
      Hi,

      Could any one please let me know what does :CTL_GLOBALS.SESSION_DATE exactly do in form personalization. I know it will give the session date but to be specific I want to know the significance of CTL_GLOBALS.

      Regards,

      Ad
        • 1. Re: Form Personalization Query
          848964
          I am new to Form personalization so also need to know the following 3 triggers:

          WHEN-NEW-ITEM-INSTANCE

          WHEN-NEW-RECORD-INSTANCE

          WHEN-NEW-BLOCK-INSTANCE

          What is Item, Record , Block interms a oracle apps forms screen (say element entry screen in payroll).

          I have some idea on it but may not be accurate. so someone can help me on this plz.

          Also let me know the significance of - Builtin Type - DO_KEY & Target Object - NEXT_ITEM


          Regards,

          Ad
          • 2. Re: Form Personalization Query
            Sandeep Gandhi, Consultant
            If you are new, I would suggest you read up a little bit on Oracle forms.
            You can start with http://www.orafaq.com/wiki/Forms_FAQ

            WHEN-NEW-ITEM-INSTANCE is an event that fires when the control has navigated to a new item

            WHEN-NEW-RECORD-INSTANCE is an event that fires when the control has navigated to a new record

            WHEN-NEW-BLOCK-INSTANCE is an event that fires when the control has navigated to a new block


            What is Item, Record , Block interms a oracle apps forms screen (say element entry screen in payroll).
            See http://osm.utoronto.ca/i/doc/AEMIG/frms_comp_about.htm

            DO_KEY is a way to execute the actions associated with that key.
            NEXT_ITEM is the field that the cursor will go to after you hit tab.

            Hope this helps,
            Sandeep Gandhi
            • 3. Re: Form Personalization Query
              848964
              Hi,

              Your response was really helpful w.r.t my queries as it narrowed down my queries further:

              1) I want to be familiar with a Block , Record, Item with respect to an oracle applications form. An examle would clear my doubts may be.

              2) A beginner level document/tutorial on form personalisation might help

              3) DO_KEY is not yet clear to me . Let me know if you can provide me some example on the same.

              Regards,

              Ad
              • 4. Re: Form Personalization Query
                Sandeep Gandhi, Consultant
                See http://blogs.ittoolbox.com/oracle/appstraction/archives/my-thoughts-on-form-personalization-part-i-11909

                http://blogs.ittoolbox.com/oracle/appstraction/archives/oracle-form-personalization-basic-example-11936
                http://www.scribd.com/doc/16769540/Introduction-to-Form-Personalization

                Also see http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/do_key-explanation-684051

                Hope this helps,
                Sandeep Gandhi
                1 person found this helpful
                • 5. Re: Form Personalization Query
                  848964
                  Hi Sandeep,

                  Thanks for the links. I am going through the same.

                  Any idea on how can we restrict person types data while creating an employee from a particular responsibility with the help of form personalization.

                  Regards,

                  Ad
                  • 6. Re: Form Personalization Query
                    Sandeep Gandhi, Consultant
                    Consider creating a when-validate-record personalization on the employee screen that checks the type and displays an error message.
                    This will fire only in the given responsibility and prohitb user from saving the record.

                    Hope this helps,
                    Sandeep Gandhi
                    1 person found this helpful
                    • 7. Re: Form Personalization Query
                      848964
                      Hi Sandeep,

                      I was aware of a little similar approach but my requirement is restricting the data shown in the person type based upon a selected responsibility.
                      In the mentioned approach, user will see all the data in person type and after selecting a particular person types, it is expected to give an error message.

                      I am afraid if I am looking for a solution which is not feasible.

                      Regards,

                      Ad
                      • 8. Re: Form Personalization Query
                        Sandeep Gandhi, Consultant
                        If it is a list of values, you can try to modify the LOV using personalization.
                        One approach involves creating a new record group and associating it with your LOV. See http://oracleappstechnicalworld.blogspot.com/2009/05/oracle-apps-changing-lov-query-form.html for details.

                        The other approach is described below but I have not used it.
                        http://bloggingaboutoracleapplications.org/making-a-list-of-values-context-sensitive-using-forms-personalization/

                        Hope this helps,
                        Sandeep Gandhi
                        1 person found this helpful
                        • 9. Re: Form Personalization Query
                          848964
                          Hi Sandeep,

                          Actually the person type for an employee in HRMS is defined in the other definitions - person types. Its neither a lookup nor valuset. Thats the problem. I now have a feeling that what I want may not be possible but still trying to do some r and d if I can get something.

                          Keeping it simple, I would like this list to be selective when logged in from different responsibility.

                          Lets see if I can somehow make it work. If you somehow get something on this, I would appreciate your assistance.

                          Regards,

                          Ad