Lease and Finance Management - EBS (MOSC)

MOSC Banner

R121.3 Post upgrade tasks:Service Contracts Update Base Annualized Factor Worker

edited Apr 25, 2012 7:15PM in Lease and Finance Management - EBS (MOSC) 3 comments
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center