R12 Depreciation Run Ends In Error APP-FND-01564 ORACLE Error 1400 In Fadais (Doc ID 1527918.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
FADEPR

Symptoms

Depreciation Run ends in error APP-FND-01564: ORACLE error 1400 in fadais in 12.1.3:

APP-OFA-48208: fadatd: method has the value of STL.
APP-OFA-48208: fadatd: life has the value of 36.
APP-OFA-48208: fadpaa: before faddha: method: has the value of STL.
APP-OFA-48208: fadpaa: before fadaid: method: has the value of STL.
APP-FND-01564: ORACLE error 1400 in fadais

Cause: fadais failed due to ORA-01400: cannot insert NULL into ("FA"."FA_DEPRN_SUMMARY"."ADJUSTED_COST")
.

The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47662: Error: Unable to insert records into FA_DEPRN_SUMMARY table

Cause: You have a database problem.

Action: Contact your system administrator.

APP-OFA-47016: Distribution ID: 140492
APP-OFA-47016: Distribution ID: ZKW BOOK
APP-OFA-47016: Distribution ID: 24157
APP-OFA-47016: Distribution ID: 02/02/2013 18:35:27
APP-OFA-47016: Distribution ID: 0
APP-OFA-47016: Distribution ID: 0
APP-OFA-47016: Distribution ID: 679
APP-OFA-47016: Distribution ID: DEPRN
APP-OFA-47016: Distribution ID: 50000
APP-OFA-47016: Distribution ID: -0.00000000000000000000000000000000E+125
APP-OFA-47016: Distribution ID: 0
APP-OFA-47016: Distribution ID: 0
APP-OFA-47016: Distribution ID: 0
APP-OFA-47016: Distribution ID: 0
/PRODAPP/apps/apps_st/appl/fa/12.0.0/bin/FADEPR
Program was terminated by signal 11



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