FAPIMP: Process Impairments Gets Error When Performs for the CGU Including Non-depreciating Asset without Deprn Reserve (Doc ID 2189156.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

Process Impairments(=FAPIMP) is getting the following error when it performs for the Cash Generating Unit(=CGU) including the asset which is added with Depreciate Flag = NO and without Depreciation Reserve.

Concurrent Log:

Module FAPIMP ended with error

Fnd Debug Log:

sqlerrm has the value of ORA-01422: exact fetch returns more than requested num

  

Steps to Reproduce
1.  2016-04 *** Addition 2 Assets

    Issue's Asset
    Cost                       : 100000
    YTD depreciation           : 0
    Accumulated depreciation   : 0
    Date in Service            : 01-APR-2016
    Depreciation method        : STL 5Year
    Salvage value              : 0
    Depreciation limit amount  : 1
    Depreciation flag          : No
    Cash Generating Unit       : CGU001


    Normal Asset
    Cost                       : 100000
    YTD depreciation           : 0
    Accumulated depreciation   : 0
    Date in Service            : 01-APR-2016
    Depreciation method        : STL 5Year
    Salvage value              : 0
    Depreciation limit amount  : 1
    Depreciation flag          : Yes
    Cash Generating Unit       : CGU001



2.  2016-04 *** Perform Impairments for the CGU001

    (N)Assets > Impairment > Create and Post

    --> Module FAPIMP ended with error

 

Supplement
Not able to post the Impairment for the asset which is added with Depreciate Flag = NO and without Depreciation Reserve. This is intentional behavior.

[Reference]
<Document 1962989.1> - FAPIMP Process Impairments Error: "this asset is added with Depreciate Flag NO and without Depreciation Reserve"
<Document 2054996.1> - Why Can't You Post Impairments for Non-depreciable or CIP Assets?

Changes

The error message of the "Module FAPIMP ended with error" is too simple to know exactly what is happening.  Hence, it has changed to return the correct validation error.

You cannot perform Impairment on &ASSET_NUMBER, this asset is added with Depreciate Flag NO and without Depreciation Reserve.
Module FAPIMP ended with error

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