My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.