SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Jobs failing with - ORA-01426: numeric overflow ORA-06512: at "SYS.DBMS_ISCHED", line 5143 ORA-01426

user1980Jul 30 2019 — edited Jul 30 2019

Hi,

Many of our long running jobs have suddenly started failing with the below errors. No code changes have been made to these jobs.

p_exl EXL_XRF_MAPPING_VALUE -1426 ORA-01426: numeric overflow

ORA-06512: at "SYS.DBMS_ISCHED", line 5143

ORA-01426: numeric overflow

p_exl EXL_PRODUCTSTORE -1426 ORA-01426: numeric overflow

ORA-06512: at "SYS.DBMS_ISCHED", line 5143

ORA-01426: numeric overflow

There are no code changes deployed. Anything else I can check?

Regards,

Added on Jul 30 2019

6 comments

1,665 views