AuditTrail Update Tables Report for Custom Table Fails With APP-FND-00016 No primary key information
(Doc ID 1193775.1)
Last updated on FEBRUARY 13, 2025
Applies to:
Oracle Application Object Library - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]Oracle Financials for India - Version 12.2.9 to 12.2.9 [Release 12.2]
Oracle Financials for India - Version 12.2.6 to 12.2.6 [Release 12.2]
Oracle Assets - Version 12.2.12 to 12.2.12 [Release 12.2]
Information in this document applies to any platform.
Executable:FNDATUPD - AuditTrail Update Tables
Executable:FNDATRPT - AuditTrail Report for Audit Group Validation
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
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |