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!

DBA_SEQUENCES vs FND_SEQUENCES

Discussion in 'Oracle Apps Technical' started by joost.van.steeg, Mar 18, 2015.

  1. joost.van.steeg

    joost.van.steeg Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hello,

    We have to adjust a sequence to no cache. This sequence can be found in DBA_SEQUENCES (FA_ADDITIONS_S).
    But the same sequence can be found in APPLICATION DEVELOPER > APPLICATION > DATABASE > SEQUENCE.
    This form is based on table FND_SEQUENCES and shows different caching values from DBA_SEQUENCES for the same sequence name.
    Can someone tell me the difference between the two tables? Why is FND_SEQUENCES shown in APPLICATION DEVELOPER while DBA_SEQUENCES is used?

    Regards,
    Joost.
     
  2. joost.van.steeg

    joost.van.steeg Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    DBA_SEQUENCES is a view to see the actual DB sequences
    FND_SEQUENCES is a table in which metadata of the sequences is stored. This is used during installatie for example, to create the db sequences.
    The sequence information should be in sync. This can be achieved by creating or update a sequence using FND_LOAD.