Error Inserting into FA_DEPRN_OVERRIDE While Running SQL Loader (Doc ID 277831.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Assets - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
deleted duplicate doc 295975.1

Symptoms

While running an SQL Loader script to load information into FA_DEPRN_OVERRIDE,
SQL Loader errors on every second record with the following:

Record 2: Rejected - Error on table "FA"."FA_DEPRN_OVERRIDE".
ORA-04091: table FA.FA_DEPRN_OVERRIDE is mutating, trigger/function may not see it
ORA-06512: at "APPS.FA_DEPRN_OVERRIDE_BRIUD", line 177
ORA-04088: error during execution of trigger 'APPS.FA_DEPRN_OVERRIDE_BRIUD'

There is no difference between the data in row one and two other than the
asset_id and amount.

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