3 Replies Latest reply: Jan 15, 2013 3:12 AM by Suren.Khatana RSS

    Creation of 250+ custom UDFs in OIM 11gR2

    Suren.Khatana
      We are working on a IAM implementation using OIM 11g R2. Our requirement is to add 250+ custom UDF attributes in user profile.
      We already have 100 UDFs and planning to create additional 150 UDFs.
      Could you please let us know if anyone of you have come across such a large number of UDFs in your experience and any performance impacts that can be associated.


      Thanks
      Suren
        • 1. Re: Creation of 250+ custom UDFs in OIM 11gR2
          Nishith Nayan
          Just try below


          1. export User.xml using deployment manager(metadata export)
          2. export sandbox. make sure at least one udf you have added in all the pages (Create, Modify and View page)

          [Must have a copy/backup of both which will help you for recovery if something goes wrong]

          3. open User.xml and copy paste for the remaning 150 UDF similar to the existing entries

          4. go to exported sandbox. there will be file like UserEo.xml, UserEo.xml.xml, UserVo.xml, UserVo.xml.xml.. may one more file will be there. open each file and add similar entries for the remaining attribute


          5. import User.xml using deployment manager

          6. import sandbox and activate same.


          Oh I didn't get your question. Yes we had around 200 UDF on Beta version of R2, and there was no diff on the performance. So, I don't think there will be any performance issue.
          • 2. Re: Creation of 250+ custom UDFs in OIM 11gR2
            Rajiv Dewan
            Performance issues will be seen whenever View User Details will be loaded. As 250 is quite a bug number so OIM has to set values for each field from Database.

            You must follow tuning steps which are provided by Oracle.
            • 3. Re: Creation of 250+ custom UDFs in OIM 11gR2
              Suren.Khatana
              Thanks Folks.

              Regards
              Suren