Error "ORA-01476: Divisor Is Equal To Zero Returned By Program Unit PACKITEM_ATTRIB_SQL.GET_ORDER_COMP_COST" In Order Details Screen For Complex Pack Having Component With Cost 0
(Doc ID 2436443.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
When setting the order details for an order containing a pack item (complex pack) that has unit cost zero, the "divisor is equal to zero" error is thrown.
The issue can be reproduced at will with the following steps:
- Create a new item with diffs, then create a children for this item.
Note: all have cost Zero.
- Create a pack item (complex pack) and add as component one of the child items.
- Create a order for pack item, after setting the order details notice the error above.
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