"Cache: Error retrieving row from FA_DEPRN_BASIS_RULES table for" Error Occurs when Performing Amortize Adjustments

(Doc ID 1633735.1)

Last updated on MARCH 13, 2014

Applies to:

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


 Performing Amortize Adjustments fails with the following error:

Cache: Error retrieving row from FA_DEPRN_BASIS_RULES table for:
Fiscal Year Name: XXFA Fiscal Year
Fiscal Year: 2012

Cause: You have a database problem.
Action: Contact your system administrator.
ORA-01403: no data found

Steps to Reproduce
1.  Fiscal Years

    Creating Fiscal Years with starting on 01-JAN-2013

    (N)Setup > Asset System > Fiscal Years

    From Date       To Date         Fiscal Year
    -------------   -------------   -------------
    01-JAN-2013     31-DEC-2013     2013
    01-JAN-2014     31-DEC-2014     2014

2.  Calendars and Prorate Conventions

    Creating Calendars / Prorate Conventions with the above Fiscal Years

    (N)Setup > Asset System > Calendars
    (N)Setup > Asset System > Prorate Conventions

3.  APR-2012 *** Add an Asset with STL 5YR

4.  APR-2012 *** Performing Amortize Adjustments

    Depreciation method       : (From)STL 5     (To)JP-STL 5YR
    Amortized flag            : Yes
    Amortization Start Date   : 01-APR-2012

    *Performing Amortize Adjustments ends with the above error.


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