How To Enable Auditing On BEN_CWB_RPT_DETAIL Table? (Doc ID 559103.1)

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

Symptoms

-- Problem Statement:
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)

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