My Oracle Support Banner

APP-FND-00016: No Primary Key Information Exists for table XXX (Doc ID 888323.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Oracle Application Object Library - Version 12.0.0 to 12.2.9 [Release 12 to 12.2]
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".

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.