Datamart Job Failing

Discussion created by N.P on Apr 9, 2013
Latest reply on Apr 9, 2013 by navzjoshi00

We have datamart job failing with following error. We are going to open case with CA but just wanted to check if anybody has faced this error before.

PMD application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_PCF_SP: ORA-20000: Error in NBI_EXTR_PCF_SP - Extracting NBI_PROJECT_CURRENT_FACTS: ORA-20000: Error in NBI_PROJECT_CURRENT_FACTS_SP - 5015483 - Applying the exchange rate on totalamount/cost/amountremaining: ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 379
ORA-06512: at line 1