My Oracle Support Banner

Audit Tracking Not Creating The Audit Tables, "Fatal error in fdasql" (Doc ID 1933308.1)

Last updated on JANUARY 26, 2023

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.


As part of our requirement, We have enabled the Audit for few R12 tables for few columns.
Example : AP_SUPPLIERS : Already audit enabled, enabled audit for few more fields
IBY_EXTERNAL_PAYEES_ALL : Enabled Audit for this table

Enabled audit on a product table and ran the concurrent program "Audit Trail Update Tables"

The newly added audit tables and audit columns exist in fnd_audit_tables & fnd_audit_groups, but the Audit tables/ Audit Columns are not getting created.

For instance, an audit was set up on IBY_EXTERNAL_PAYEES_ALL table, but the IBY_EXTERNAL_PAYEES_ALL_A shadow table is not getting created.

The concurrent program log is showing the below error message.

Fatal error in fdasql, quitting...
ORA-24344: success with compilation error
Fatal error in fdactr, quitting...
Fatal error in fdactr, quitting...


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.