APP-OFA-47685: Error: Unable to get information from FA_CALENDAR_PERIODS table - Oracle EBS R12

http://fixedasstets.blogspot.com/2016/10/app-ofa-47685-error-unable-to-get.html


Unable to get information from FA_CALENDAR_PERIODS table

+---------------------------------------------------------------------------+
Assets: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FADEPR module: Depreciation Run
+---------------------------------------------------------------------------+

Current system time is 18-OCT-2016 17:06:35

+---------------------------------------------------------------------------+

Depreciation Program Exception Report
APP-OFA-48152: Asset number 108438
APP-FND-01564: ORACLE error 1403 in fazgtff

Cause: fazgtff failed due to ORA-01403: no data found
                                             .

The SQL statement being executed at the time of the error was:  and was executed from the file .
APP-OFA-47685: Error: Unable to get information from FA_CALENDAR_PERIODS table

Cause:        You have a database problem.

Action:        Contact your system administrator.

APP-OFA-47715: Error: function fazcff returned failure (called from faxcfyf)
APP-OFA-47715: Error: function faxcfyf returned failure (called from faxcde)
APP-OFA-47715: Error: function faxcde returned failure (called from fadmlp)
APP-OFA-47715: Error: function fadmlp returned failure (called from faddep)
Asset ID 108438 (108438) -> ** Failed **
APP-OFA-48152: Asset number 108755
APP-OFA-48152: Asset number 108756
APP-FND-01564: ORACLE error 1403 in fazgtff

Cause: fazgtff failed due to ORA-01403: no data found

--------------------------------------------------------------------------------------------------------------------------

In my Case Asset Calendar Periods were defined for only 3 Months for the Year. I Defined Calendar for Complete Year and Resolves the Issue.

------------------------------'OR' ----------------------------------as below

Depreciation Projection Report (FAPROJ) errors with:

APP-FND-1564: ORACLE error 1403 in fazgtff
APP-OFA-47685: Error:Unable to get information from FA_CALENDAR_PERIODS

fajprj failed due to ORA-1403: no data found


CAUSE

General Ledger calendar period names may be different than the Oracle Asset calendar period names.

For example:
GL may have Jan-99 but FA may have JAN-99

With these 2 diagnostic queries we can see that the period names are different:

select set_of_books_id, period_name, closing_status
from gl_period_statuses
where set_of_books_id in
(select set_of_books_id
from fa_book_controls
where book_type_code = '&your_deprn_book');

select period_name, period_counter, deprn_run
from fa_deprn_periods
where book_type_code = '&your_deprn_book'
order by period_counter, period_name ;

SOLUTION

Change the calendar period names to be the same. The report should complete
successfully.

To change unused period names:

Navigate to: Setup\Asset System\Calendars

1. Query the calendar in question.
2. Scroll to the last period.
3. From the Main menu select: Edit/Delete Record
4. Continue to delete as far back as necessary (or to where transactions have been entered for the period)
5. Re-add the periods deleted with the correct name.