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.
While reviewing the AuditTrail Update Tables, the following error was found.
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
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.
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