R121.3 Post upgrade tasks:Service Contracts Update Base Annualized Factor Worker
Hi As part of post upgrade tasks,while running the program "Service Contracts Update Base Annualized Factor Worker" it was completed with error and has the below error message.OKSUBAFWKR module: Service Contracts Update Base Annualized Factor Workererrored out ORACLE error 1476 in FDPSTPCause: FDPSTP failed due to ORA-01476: divisor is equal to zeroORA-06512: at "APPS.OKS_SETUP_UTIL_PUB", line 5593ORA-06512: at line 1analysisThe OKS_SETUP_UTILS_PUB package body has the procedure Update_Annualized_Factor_HWKR..The package has an update statement as belowUPDATE (Select /*+ rowid(hdr) leading(hdr) use_nl_with_index(cle) */cle.payment_instruction_type,cle.annualized_factor,hdr.payment_instruction_type hdr_payment_instruction_type,casewhen cle.lse_id in (1, 12, 14, 19, 46, 7, 8, 9, 10, 11, 13, 18, 25, 35)then (add_months (cle.start_date, (trunc (months_between(cle.end_date, cle.start_date) / 12) + 1) * 12) -cle.start_date - decode (add_months (cle.end_date, -12),(cle.end_date-366), 0, decode ( add_months(cle.start_date,(trunc(months_between(cle.end_date, cle.start_date)/ 12) + 1) * 12) - add_months(cle.start_date,trunc(months_between(cle.end_date, cle.start_date) / 12)* 12), 366, 1, 0)))/ (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
0