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.

Symptoms

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

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