FCEXEC Aborts with ORA-01476 Error at FUTURE_COST_ROLLFWD_SQL.HELP_ROLL_DEAL_2 (Doc ID 2909326.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Symptoms

After creating an Off-invoice Deal with Buy/Get details, with Threshold Target Buy Item Quantity with the same quantity as Threshold Purchase Order Quantity, the FCEXEC process aborts with

Error
-----------------------
"ORA-01476: divisor is equal to zero" error at FUTURE_COST_ROLLFWD_SQL.HELP_ROLL_DEAL_2.


Steps to Recreate
-----------------------
1) Setup an Off-invoice Deal for today, with Buy/Get details which Get-Item is the same as Buy Item and Threshold Target Purchase Order Quantity is the same quantity as Threshold Target Buy Item Quantity.
2) Execute FCTHREADEXEC and FCEXEC batch processes.
3) Note that ORA-01476 errors appear on COST_EVENT_RESULT table for Event Process ID of configured Deal.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.