My Oracle Support Banner

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:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.


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

"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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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