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

Last updated on MARCH 08, 2017

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***

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

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