My Oracle Support Banner

Enable Auditing for General Ledger Module Errors: Oracle error 4080: ORA-04080 / APP-FND-00016: No primary key information exists for table GL_LEGAL_ENTITIES_BSVS_A, audit table not made (Doc ID 2945688.1)

Last updated on MARCH 27, 2024

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
FNDATUPD: AuditTrail Update Tables

Symptoms

Enable auditing for General Ledger module errors. The concurrent program 'FNDATUPD: AuditTrail Update Tables' is run as part of the process and it throws error in the log file.



ERROR:
--->Update Triggers
----->Drop Triggers
DROP TRIGGER GL_LEGAL_ENTITIES_BSVS_AI
Oracle error 4080: ORA-04080: trigger 'GL_LEGAL_ENTITIES_BSVS_AI' does not exist


ORA-06512: at "A has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, FND, 8, $statement$, GL_LEGAL_ENTITIES_BSVS_AT): private_do_ddl(APPS, APPLSYS, APPLSYS, 8, $statement$, GL_LEGAL_ENTITIES_BSVS_AT): do_acd_trigger(0, APPS, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='DROP TRIGGER GL_LEGAL_ENTITIES_BSVS_AT'
----->Copy Table to Shadow Table
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 fdacts, quitting...
Fatal error in fdaut, quitting...


STEPS TO REPRODUCE:

1. System Administrator > Follow this document to enable auditing for General Ledger module: R12: How to Enable AuditTrail in GL (Doc ID 2920860.1)
2. View > Requests > Submit a new Request > Run FNDATUPD: AuditTrail Update Tables
3. See errors in the log file

Changes

Most likely to occur post R12 upgrade, on attempting to enable auditing on General Ledger module's tables.

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.