My Oracle Support Banner

Cannot Save Order Lines for Some Items Which Show Error Debug Log "ERROR IN SET_PRGORA-01476: divisor is equal to zero" (Doc ID 1988630.1)

Last updated on JULY 19, 2021

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Some sales order lines are not saved with a status when booking sales orders.
The order is booked with an order number, but the line has no status and when coming out of the order the message 'You have changes pending; is displayed.

Issue Verified

=============

Shown in the debug file created using <Document 1334948.1> - How to Generate a Debug File Involving a Sales Order For Pricing Analysis


FileComment
-----------------
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter value exists.  
PARAMETER VALUE: 154
SET PRGCREATE qty0
ERROR IN SET_PRGORA-01476: divisor is equal to zero
ERROR IN PROCESS_PRGUser-Defined Exception
EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR with rollback

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
Cause
Solution
References


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