AuditTrail Update Tables ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AC' does not exist Error When Disable "Audit Enabled" For A Certain Schema Enabled
(Doc ID 2025113.1)
Last updated on OCTOBER 01, 2019
Applies to:
Oracle Application Object Library - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
Running the AuditTrail Update Tables completes with error in the request log file as follows:
ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AC' does not exist
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AH
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AH
ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AH' does not exist
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AT
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AT
ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AT' does not exist
Cause: Table name is FND_PROFILE_OPTION_VALUE_A.
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 fdadv, quitting...
Fatal error in fdadic, quitting..
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AH
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AH
ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AH' does not exist
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AT
DROP TRIGGER FND_PROFILE_OPTION_VALUE_AT
ORA-04080: trigger 'FND_PROFILE_OPTION_VALUE_AT' does not exist
Cause: Table name is FND_PROFILE_OPTION_VALUE_A.
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 fdadv, quitting...
Fatal error in fdadic, quitting..
If enable "Audit Enabled" of APPLSYS and disable "GL", the error message will be changed as follows.
ORA-04080: trigger 'GL_LEDGERS_AC' does not exist
DROP TRIGGER GL_LEDGERS_AH
DROP TRIGGER GL_LEDGERS_AH
ORA-04080: trigger 'GL_LEDGERS_AH' does not exist
DROP TRIGGER GL_LEDGERS_AT
DROP TRIGGER GL_LEDGERS_AT
ORA-04080: trigger 'GL_LEDGERS_AT' does not exist
Cause: Table name is GL_LEDGERS_A.
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 fdadv, quitting...
Fatal error in fdadic, quitting...
DROP TRIGGER GL_LEDGERS_AH
DROP TRIGGER GL_LEDGERS_AH
ORA-04080: trigger 'GL_LEDGERS_AH' does not exist
DROP TRIGGER GL_LEDGERS_AT
DROP TRIGGER GL_LEDGERS_AT
ORA-04080: trigger 'GL_LEDGERS_AT' does not exist
Cause: Table name is GL_LEDGERS_A.
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 fdadv, quitting...
Fatal error in fdadic, quitting...
Changes
Unchecked "Audit Enabled" of all schemas using the next window in order to cancel all audit trails.
Responsibility : System Administrator,
PATH : Security > AuditTrail > Install
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 |