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!

APP-FND-00668 when compiling Flexfields

Discussion in 'Oracle Financials' started by Bhavani, Feb 22, 2010.

  1. Bhavani

    Bhavani Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    HI,

    In Release 12 While I am creating the new COA and compiling my flexifield i got some error.


    The Error code is APP-FND-00668 and 00926.


    Can any one help to solve this problem.

    Thanks in advance

    Regards
    Bhavani.
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Re: R12-Compiling Flexifield-error

    This is a known issue:

    Fix:

    The following steps can be checked if these errors encountered

    1) Verify that tables FND_ID_FLEX_STRUCTURES ,FND_DESCRIPTIVE_FLEXS FND_ID_FLEX__STRUCTURES_TL, FND_DESCRIPTIVE_FLEXS_TL are visible from the APPS user

    2) Verify that APPS user has select/update/insert privledges to these tables

    For the first two tables grant select, insert, and update privileges to these tables

    3) Run the following selects

    Code (SQL):

      SELECT COUNT(*), LANGUAGE
      FROM fnd_id_flex_structures_tl
      GROUP BY LANGUAGE;
     
      SELECT COUNT(*) FROM fnd_id_flex_structures;
     
    The select count from fnd_id_flex_structures should be the same as the count retrieved from fnd_id_flex_structures_tl for each installed language.

    Code (SQL):

      SELECT COUNT(*), LANGUAGE
      FROM FND_DESCRIPTIVE_FLEXS_TL
      GROUP BY LANGUAGE;
     
      SELECT COUNT(*) FROM FND_DESCRIPTIVE_FLEXS;
    The select count from FND_DESCRIPTIVE_FLEXS should be the same as the count retrieved from FND_DESCRIPTIVE_FLEXS_TL for each installed language.

    If they do not match, run "Maintain Multilingual Tables" option from adadmin.