Audit Tracking Not Creating The Audit Tables, "Fatal error in fdasql"

(Doc ID 1933308.1)

Last updated on MARCH 08, 2017

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


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