Tax Reserve Ledger Report - FAS480 Errors with REP-1401 and ORA-6502 (Doc ID 167180.1)

Last updated on OCTOBER 15, 2016

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.
Report:FAS480.RDF - Tax Reserve Ledger Report
***Checked for relevance on 30-Oct-2012***


Symptoms

The Tax Reserve Ledger Report (FAS480) ends with the following error:

Error
------ 
One or more PL/SQL libraries have been modified since the report was saved.
The PL/SQL will be recompiled. 
REP-1401: 'd_lifeformula': Fatal PL/SQL error occurred 
ORA-06502: PL/SQL: numeric or value error 
Program exited with status 1 

After compiling the report, these new errors are received:

Error
------
REP-759 One or more PL/SQL libraries have been modified
REP-736 There exist uncompiled program units
REP-1247 Report contains uncompiled pl/sql 

Compiled fadolif.pll manually and program still errored
f60gen userid= APPS/APPS module=fadolif.pll module_type=library output_file=/ /plsql/fadolif.pll compile_all=Yes 

Ran report from command line with same results.

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