Automatic Asset Numbering Skips Numbers (Fix Assets)

Automatic Asset Numbering Skips Numbers (Fix Assets)

Pinning the sequence is achieved by invoking the rdbms package dbms_shared_pool.keep() as follows:

execute dbms_shared_pool.keep('APPS.FA_ADDITIONS_S','Q') ;

To Check Pinning of Object:

SELECT owner, name, type

FROM gv$db_object_cache

WHERE kept = 'YES' and OWNER = 'FA';