Navigate to the Admin menu and open FK Validation Summary to view foreign key validation errors associated with the objects defined in Master Data.
Description of Page
You can use Table Name to restrict errors to a specific object. If this field is left blank, all errors on all objects will be displayed.
The grid contains a separate row for each table and foreign key error combination.
The following information is displayed:
Table Name is the name of the main table associated with the object.
Count contains the number of records on this table that have this error.
Foreign Key Field Names 1 to 6 contain the names of the foreign keys contained on this table that have been found to be in error.
Foreign Key Values 1 to 6 contain the values within the foreign key fields that are found to be in error.
Most foreign keys on a table are obvious based on the field name. For example, if the output shows Table Name CI_ADJ, Count 100, Foreign Key Field Name 1 ADJ_TYPE_CD, and Foreign Key Value 1 SALES_INTEREST, you know that there are 100 records in the Adjustment table referencing an invalid Adjustment Type Code of SALES_INTEREST. However, some foreign keys are multi-part keys and in viewing the Foreign Key names, the table they refer to may not be obvious. If it is not clear what table a foreign key is referring to, navigate to the Table page for the table reported in the error and view the Constraints tab. All the foreign keys being checked are listed there with their respective table names.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.