APP-FND-00668 and 00926.

  R12-Compiling Flexifield-error

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.

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.