My Oracle Support Banner

UNABLE TO AUDIT TABLE HR_PERSON_DEPLOYMENTS DUE TO PRIMARY KEY MISSING (Doc ID 2604482.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to enable Audit for Table HR_PERSON_DEPLOYMENTS using Document id 848039.1
When submit Audit Trail Update Tables concurrent request we receive below error :

APP-FND-00016: No primary key information exists for table HR_PERSON_DEPLOYMENTS_A, audit table not made.
APP-FND-00016: No primary key information exists for table , audit table not made.
Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
Fatal error in fdagcn, quitting...
Fatal error in fdactr, quitting...

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
----->Update Pending Columns
----->Adding ROW_KEY
**Starts**25-AUG-2019 12:19:23
**SQL error and free**25-AUG-2019 12:19:24
ORACLE error 942 in FDPSTP

Cause: FDPSTP failed due to ORA-00942: table or view does not exist
ORA-06512: at "APPS.FND_AUDIT_UPDATE_PKG", line 73
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was: and was executed fro25-AUG-2019 12:19:24
----->Alter Shadow Table
ALTER TABLE HR_PERSON_DEPLOYMENTS_A ADD (ASSIGNMENT_STATUS_TYPE_ID NUMBER(15,0))
ALTER TABLE HR_PERSON_DEPLOYMENTS_A ADD (ASSIGNMENT_STATUS_TYPE_ID NUMBER(15,0))
ORA-00942: table or view does not exist

 

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1. enable audit trail on the table

 

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


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