R12: Calculate Gains and Losses Finishes with ORA-01400 (Doc ID 2021797.1)

Last updated on JUNE 18, 2015

Applies to:

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

Symptoms

 When attempting to run Calculate Gains and Losses, ORA-01400 error occurs. The log file shows below.

---------------------------------
The Asset Id is 450399
APP-OFA-48208: at has the value of top of loop for get.
ORA-01400: cannot insert NULL into ("FA"."FA_ADJUSTMENTS"."ADJUSTMENT_AMOUNT")
APP-OFA-48208: at has the value of top of loop for get.
Error: function FA_INS_ADJUST_PKG.fainajc returned failure
APP-OFA-48208: at has the value of top of loop for get.
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
APP-OFA-48208: at has the value of top of loop for get.
Error: function FA_GAINLOSS_UPD_PKG.fagprv returned failure
APP-OFA-48208: at has the value of top of loop for get.
FAGPRV: Fail to insert Depreciation Reserve adjustments for asset FA_BOOK01-01

Cause:        You have a database problem.

Action:        Contact your system administrator.

APP-OFA-48208: at has the value of top of loop for get.
FAGRET: Fail to retire asset FA_BOOK01-01

Cause:        You have a database problem.

Action:        Contact your system administrator.

APP-OFA-48208: at has the value of top of loop for get.
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
APP-OFA-48208: at has the value of top of loop for get.
Retirement ID: 145422 Asset Number: FA_BOOK01-01 --> ** Failed **
---------------------------------

Reproduce steps

  1. Addition ***** 2015-04(APR-15)
     
    Book Type FA_BOOK01
    Asset Number FA_BOOK01-01
    Cost 151360765
    YTD depreciation amount 0
    Accumulated depreciation amount 151360764
    DPIS 01-APR-2003
    Depren method JP-STL-EXTND
    Salvage value 10%
    Depreciation limit amount 1  JPY

     

  2. Partial Retirement ***** 2015-05(MAY-15)
     
    Retire Date 31-MAY-2015
    Cost Retired 275720
    Proceeds of Sale 0
    Cost of Removal 0
    Retirement Type Following Month Convention

     

  3. Run Calculate Gains and Losses and the error occurrs.

 

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