My Oracle Support Banner

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:

  1. Create a new item with diffs, then create a children for this item.
    Note: all have cost Zero.
  2. Create a pack item (complex pack) and add as component one of the child items.
  3. 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

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