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!

Error while entering Company value in values in Chart of Accounts

Discussion in 'Oracle Financials' started by anandsaan, Apr 8, 2012.

  1. anandsaan

    anandsaan Guest

    Hi,

    When I try to enter company value in values, system is generating this following message "APP-FND-01206This record already exists. You entered a duplicate value or sequence of values must be unique for every record"

    We saw from backend tables also but we didn't see any value in the table. Could you please suggest me?

    Regards,
    Anand.
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Anand,

    Unique Constraint at work. Do post the version of Oracle you work on. Try this from the back end.
    $ sqlplus apps/apps
    SQL> alter sequence APPLSYS.FND_FLEX_VALUES_S increment by 996004;
    SQL> select FND_FLEX_VALUES_S.NEXTVAL from dual;
    SQL> alter sequence APPLSYS.FND_FLEX_VALUES_S increment by 1;
    SQL> exit

    Update results.
    Ramji