4 Replies Latest reply on May 22, 2015 1:48 PM by MariaKarpa(MK)

    EBS R12.2  - Automatic Asset Numbering Skips numbers

      Hi all,

       

      Capture.PNG

       

      One of the solution is to run > dbms_shared_pool.keep('FA_ADDITIONS_S','Q');

       

      Where do I run this command? at the owner of the sequence or as dba?

      I tried both but it did not work

       

      Kindly assists....

       

      Thanks,

      MK

       

      connect fa/fa

       

      SQL> exec dbms_shared_pool.keep('FA_ADDITIONS_S','Q');

       

      BEGIN dbms_shared_pool.keep('FA_ADDITIONS_S','Q'); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

       

       

       

       

      SQL> connect / as sysdba

      Connected.

       

      SQL>  exec dbms_shared_pool.keep('FA_ADDITIONS_S','Q');

       

      BEGIN dbms_shared_pool.keep('FA_ADDITIONS_S','Q'); END;

      *

      ERROR at line 1:

      ORA-06564: object FA_ADDITIONS_S does not exist

      ORA-06512: at "SYS.DBMS_UTILITY", line 156

      ORA-06512: at "SYS.DBMS_SHARED_POOL", line 72

      ORA-06512: at "SYS.DBMS_SHARED_POOL", line 84

      ORA-06512: at line 1