Audit Tracking Not Creating The Audit Tables, "Fatal error in fdasql"
(Doc ID 1933308.1)
Last updated on MARCH 08, 2017
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!