My Oracle Support Banner

Mass Copy ORA-01403: no data found or Depreciation ORA-01405: Column value is NULL Error for New Tax Book (Doc ID 2952145.1)

Last updated on JUNE 06, 2023

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.23.01.0 and later
Information in this document applies to any platform.

Symptoms

Mass copy and Calculate Depreciation processes end in error for new tax book:


Mass Copy log:

"Retrieving rows from the FA_DEPRN_PERIODS table for the book <BOOK NAME>, the period counter <PC VALUE>, and the effective date failed.

fa_cache_pkg.fazcdp

ORA-01403: no data found"



Calculate Depreciation log:

AFDICT_APP_PREFIX-FND--285675328: Process has found an SQL error. (ERRNO=1405) (ROUTINE=fazgtbcs) (REASON=ORA-01405: Column value is NULL
) (SQLSTMT=) (ERRFILE=)
fazcbcs: EXCEPTION
CONC-REQ RETURNED NO MESG

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!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.