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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |