Home › Discussions › Questions & Answers › Error on FA Asset Summary (Germany)

Error on FA Asset Summary (Germany)

Avatar photoCustomer Questions & Answers 1 reply

HI Team we are running into below error when running FA Asset Summary (Germany) report after 3.3.1 upgrade

I have re uploaded report from website – however I am still running into error

Regards
——————————————————————— ERROR fetching data —————————————————————

Error at line 49:

to_char(fnd_number.canonical_to_number((lpad(substr(to_char(trunc(x.life_in_months/12, 0),’999′), 2,3),3,’ ‘) || ‘.’ || substr(to_char(mod(x.life_in_months, 12),’00’),2,2))),’990D99′) life_yr_mo,

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

ORA-06512: at “APPS.FND_NUMBER”, line 20

ORA-06512: at “SYS.DBMS_SQL”, line 1726

ERROR|/snprd/fs_ne/inst/SNPRD_tulsa/logs/appl/conc/out/ FA_Asset_Summary_Germany_Pivot_Detailed_with_Asset_Details_146559663.xlsx |FA_Asset_Summary_Germany_Pivot_Detailed_with_Asset_Details_146559663.xlsx||||

/snprd/fs1/EBSapps/appl/xxen/12.0.0/bin/XXEN_REPORT

Program exited with status 1

1 reply

  • You must be logged in to reply to this post.