3 Replies Latest reply on Jun 3, 2015 2:24 PM by 2846585

    LOV Value number limitation in Oracle EBS 12.1.3

    maxim.s

      Hi All,

       

      The problem is that user can not get more than 10000 values in search form.

      We have made next actions:

       

      a- Go to the autoconfig Template folder:
      $cd $AD_TOP/admin/template
      b- Create new directory named (custom)
      $ mkdir custom
      c- Make sure that new directory has same file permissions as ($AD_TOP/admin/template)
      d- Copy the following autoconfig template to the new custom directory:
      $cp $AD_TOP/admin/template/APPLSYS_ux.env $AD_TOP/admin/template/custom/APPLSYS_ux.env
      e- Edit the file copied file under custom directory and add the following 2 lines at the end of section:

      ####################################
      # Oracle Forms environment variables
      ####################################

      FORMS_RECORD_GROUP_MAX=10000
      export FORMS_RECORD_GROUP_MAX

      f- Save and exit from the file.
      g- Next time autoconfig run, it will read the custom directory and check for any customizations there.

       

      Then autoconfig was executed.

       

      (Like in documment: Forms Process (FRMWEB) Consumes 100% of CPU in Oracle Applications R12 (Doc ID 745711.1))

       

      I've increased FORMS_RECORD_GROUP_MAX to 60000. But no effect. The same 10000 limatation.

       

      May you please suggest any naxt steps?

      Thank you.