1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Asset numbers in Fixed assets jump randomly

Discussion in 'Oracle Apps Technical' started by Julian, Sep 11, 2008.

  1. Julian

    Julian Forum Advisor

    Messages:
    48
    Likes Received:
    1
    Trophy Points:
    90
    Hello, we have a strange problem when we create new assets in FA, the asset number seems to be jumping randomly, anyone faced this before?
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    hello

    we have faced this problem ourselves and there is a very simple solution. Here the problem is that the sequence which is being used for FA Asset numbering is ageing out of the cache.

    There are two solutions,

    1> Don't cache the sequence at all by

    Execute from sqlplus
    Code (Text):

    alter sequence fa_additions_s nocache;
     
    However this may result in some performance degradation issues.

    2>You are better off by pinning the sequence in the cache
    Code (Text):

    dbms_shared_pool.keep('FA_ADDITIONS_S','Q').
     
    To be able to pin a sequence in the cache you must be on RDBMS version 7.3.3.1 or later.

    Once you verify that your sequence is not jumping anymore, Add the above code to some sql script which would run it at db startup, so that the pinning is not lost after a db bounce.

    This problem can happen with any sequence in apps, so replace FA_ADDITIONS_S by your sequence name.
     
  3. Julian

    Julian Forum Advisor

    Messages:
    48
    Likes Received:
    1
    Trophy Points:
    90
    yes sir, thanks a lot. I pinned down the sequence as you suggested and the asset numbers are being incremented by one now.