Asset number and Asset ID skips - Oracle EBS R12

https://fixedasstets.blogspot.com/2016/06/asset-number-and-asset-id-skips.html

Error:

We have created two new books in FA, then create new assets. The Asset number & ID skips. Please find the attached document "Asset Number Skipping"

Solution:

Command

alter sequence FA.FA_ADDITIONS_S NOCACHE

--------------------------------------------------------------------------------------------------------------------------

you have two possible solutions to prevent sequences from aging out of the sequence cache.

The first and most obvious option would be not to cache the sequence values at all. But the result of this could be a moderate to severe degradation of the application's performance. This performance degradation may not affect individual manual asset additions so much as when posting Mass Additions. The following command will change the CACHE_SIZE to 0:

alter sequence fa_additions_s nocache;

Another solution is to prevent sequences from aging out of the library cache by pinning them using dbms_shared_pool.keep(). Pinning the sequence will prevent the sequence values from being aged out of the cache. Pinning the sequence is achieved by invoking the rdbms package dbms_shared_pool.keep() as follows:

dbms_shared_pool.keep('FA_ADDITIONS_S','Q')

for more details follow the note below
Automatic Asset Numbering Skips Numbers ( Doc ID 1036833.6 )