APP-FND-00016: No Primary Key Information Exists for table XXX

(Doc ID 888323.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Application Object Library - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

The AuditTrail Update Tables concurrent request is failing with below errors:

+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDATUPD module: AuditTrail Update Tables
+---------------------------------------------------------------------------+

Current system time is 10-SEP-2009 08:10:42

+---------------------------------------------------------------------------+

APP-FND-00016: No primary key information exists for table GMD_SPEC_RESULTS_A, audit table not made.

Action: Define primary key information for table. Auditing cannot occur on tables without primary
keys.
APP-FND-00016: No primary key information exists for table GMD_SPEC_TESTS_B_A, audit table not made.

Fatal error in fdaupc, quitting...


Steps To Reproduce:
1. Navigation - System Administrator > Security > AuditTrail > Groups.
2. Run the "AuditTrail Update Tables".

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms