My Oracle Support Banner

AuditTrail Update Tables Report for Custom Table Fails With APP-FND-00016 No primary key information (Doc ID 1193775.1)

Last updated on JULY 29, 2018

Applies to:

Oracle Application Object Library - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Executable:FNDATUPD - AuditTrail Update Tables
Executable:FNDATRPT - AuditTrail Report for Audit Group Validation
***Checked for relevance on 03-May-2013***
Reviewed for Relevance 29 Jul 18

Symptoms

On R12.1.1, when enabling audit on a custom table as described in Note 433527.1, the report AuditTrail Update Tables fails with the following errors in the log file:

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

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
----->Update Pending Columns
----->Adding ROW_KEY
**Starts**16-JUN-2010 16:17:58
----->Alter Shadow Table
ALTER TABLE XXFW_CONTACT_A ADD (SALESREP_ID NUMBER )
ALTER TABLE XXFW_CONTACT_A ADD (SALESREP_ID NUMBER )
ORA-00942: table or view does not exist

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!


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