14 Replies Latest reply on Apr 25, 2019 3:26 AM by Kanda-Oracle

    All_Sequences show Cache Size >=1000

    Lalitha Subramanian

      Hello,

       

      We recently upgraded from R12.1.3 to R12.2.7 and we started seeing sequencing issue, users reported Loans numbers skips 1000 also noticed the same on customer numbers.  When i ran query against all sequences it shows a lot of sequences with cache size >1000 will be time consuming to alter each of them one by one?  Is it a know issue? if yes what should we do. If not also what should we do..

       

      Thanks

      Lalitha