FK Validation Detail
This page is used to view foreign key validation errors of a given type associated with one of the objects defined in
Master Data. This transaction is not intended to be invoked from the
Admin menu. Rather, drill into the validation details from
FK Validation Summary.
Description of Page
Use Table Name to specify the table you wish to view. The names and values of the foreign key fields on the table are displayed. The grid that follows contains the primary key values of this table's records that are in error. The following information is displayed:
• Table Name is the name of the main table.
• FK Fields 1 to 6 are the names of the foreign keys contained in this table. Displayed alongside the key names are the values within these fields. These identify records on other tables to which this tables record is related. For example, the CI_PREM_GEO record identified by its displayed primary keys should be related to a Premise record with the Premise ID shown - it appears in this list only if there is something amiss with this relationship.
Parent topic