My Oracle Support Banner

Primary Key Missing On Table Eam_pm_scheduling_rules (Doc ID 2641258.1)

Last updated on FEBRUARY 22, 2020

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

While reviewing the AuditTrail Update Tables, the following error was found.

ERROR

APP-FND-00016: No primary key information exists for table EAM_PM_SCHEDULING_RULES_A, audit table not made.

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
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

STEPS

The issue can be reproduced at will with the following steps:
1. When we are trying to enable audit on eam_pm_scheduling_rules table, the error was found in the audit trail log.

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.