Last updated on JUNE 05, 2017
Applies to:Oracle Advanced Benefits - Version: 12.0
This problem can occur on any platform.
EXECUTABLE:FNDATUPD - AuditTrail Update Tables
On 12 in Production:
FNDATUPD: AuditTrail Update Tables concurrent process fails with the following error: APP-FND-00016: No primary key information exists for table BEN_CWB_RPT_DETAIL_A, audit table not made.
Action: Define primary key information for table. Auditing cannot occur on tables without primarykeys.
This is preventing the completion of the AuditTable creation.
How to enable auditing on these tables or for any seeded table which doesnt have a primary key?
-- Steps To Reproduce:
System Administrator > Requests > Run > Single Request
AuditTrail Update Tables
-- Business Impact:
The issue has the following business impact:
Due to this issue, unable to implementing Oracle Ebusiness suite security best practices (Note Id:403537.1)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms