My Oracle Support Banner

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

Last updated on DECEMBER 12, 2022

Applies to:

Oracle Assets - Version 12.0.0 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

To view full details, 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 a vibrant support community of peers and Oracle experts.