My Oracle Support Banner

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

Last updated on AUGUST 25, 2020

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 xxxxxx
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 XXXXXXXXX01

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 XXXXXXXXX01

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: xxxxxx Asset Number: XXXXXXXXX01 --> ** Failed **
---------------------------------

Reproduce steps

  1. Addition ***** 2015-04(APR-15)
     
    Book Type TEST_BOOK
    Asset Number XXXXXXXXX01
    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.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Fixed Files
 2. Recommended Patches
 3. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.