Audit Tracking Not Creating The Audit Tables, "Fatal error in fdasql"
(Doc ID 1933308.1)
Last updated on NOVEMBER 15, 2024
Applies to:
Oracle Application Object Library - Version 12.1.3 and laterInformation 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 |