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 DECEMBER 07, 2016

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

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

  

 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms