Reports End with ORA-01400: cannot insert NULL into FA.FA_WORKER_JOBS.START_RANGE (Doc ID 1374062.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
Journal Entry Reserve Ledger Report
FAS400
Cost Detail Report
FASCOSTD
Reserve Detail Report
FASRSVED

Goal


When attempting to run Journal Entry Reserve Ledger Report or Cost Detail Report or Reserve Detail Report, the following error occurs:

ERROR
-----------------------
REP-0759: One or more PL/SQL libraries have been modified since the =
report was saved.
The PL/SQL will be recompiled.
REP-1401: 'c_do_insertformula': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.FA_RSVLDG_REP_INS_PKG", line 1263
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.FA_BALREP_PKG", line 91
ORA-01400: cannot insert NULL into ("FA"."FA_WORKER_JOBS"."START_RANGE")




Solution

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