procedure Sp_report under xcenter database giving unique constraint error

Hi All ,

We have schedule Job in Xcenter database which is running for every 15 Minutes. Under this job its running  Procedure running SP_report which is calling Sp_flash.

Output error :

ERROR NUM: -1

ERROR TXT: ORA-00001: unique constraint (DTV.PK_RPT_SALE_LINE) violated

Want to resolve this , the same job is running successfully and fine without any erros  in test environment . but under production its failing .

I m sure its same thing related to data available already in table rpt_sale_line.

Please help to over come this issue.

Thanks

Ahmed