R12.1 to R12.2 Depreciation Projection Report (FASPRJ) Completes With No Data Found (Doc ID 1428654.1)

Last updated on APRIL 26, 2017

Applies to:

Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
FASPRJ - Depreciation Projection Report



Symptoms


FA Projection Report (FASPRJ) completes with "No Data Found".  This is very likely to be occurring after a patch such as <Patch 13657197>:R12.FA.B or similar code level.  <Patch 9777127> will definitely have been applied.

The following SQL statements, when run, return no data:

select *
from all_synonyms
where synonym_name = 'FA_PROJ_INTERIM_RPT';

select *
from all_views
where view_name = 'FA_PROJ_INTERIM_V';

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