Audit Trail Update Tables Failing on AP_SYSTEM_PARAMETERS_AC1 View (Doc ID 567954.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Reviewed for relevance 23-Dec-2016

Symptoms

While running AuditTrail Update Tables to complete setup of auditing on the AP_SYSTEM_PARAMETERS table, the program fails with an error:

-->CE_BANK_ACCT_USE_ID
-->PREPAY_TAX_DIFF_CCID
-->RECEIPT_ACCEPTANCE_DAYS
-->TOLERANCE_ID
Fatal error in fdasql, quitting...
Fatal error in fdacv, quitting...
commit

Fatal error in fdaupc, quitting...

 You may also see this FATAL ERROR error occurring for other tables, for example PAY_PERSONAL_PAYMENT_RET.

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