My Oracle Support Banner

How to Enable Auditing on BEN_CWB_RPT_DETAIL Table? (Doc ID 559103.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Compensation Workbench - Version 11.5.10 HRMS FP.K RUP9 and later
Information in this document applies to any platform.
EXECUTABLE:FNDATUPD - AuditTrail Update Tables

Symptoms

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 primary keys.

This is preventing the completion of the AuditTable creation.

How to enable auditing on these tables or for any seeded table which doesn't have a primary key?


Steps To Reproduce:

  1. System Administrator > Requests > Run > Single Request.
  2. AuditTrail Update Tables.

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
Cause
Solution
References


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