My Oracle Support Banner

Purchase Price Variance Report Runs Into Error (Doc ID 293403.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Purchasing - Version 11.5.9 to 11.5.10.4 [Release 11.5]
Linux x86
z*OBSOLETE: Microsoft Windows 2000
Oracle Solaris on x86 (32-bit)
HP-UX PA-RISC (32-bit)
z*OBSOLETE: Microsoft Windows XP (64-bit Itanium)
z*OBSOLETE: Microsoft Windows XP
IBM AIX on POWER Systems (64-bit)
Red Hat Enterprise Linux Advanced Server Itanium
SUSE \ UnitedLinux x86-64
Red Hat Enterprise Linux Advanced Server x86-64 (AMD Opteron Architecture)
Linux x86-64
Oracle Solaris on SPARC (64-bit)
IBM AIX on POWER Systems (32-bit)
z*OBSOLETE: IBM AIX 4.3 Based Systems (64-bit)
Oracle Solaris on SPARC (32-bit)
HP-UX PA-RISC (64-bit)
Microsoft Windows (32-bit)

Symptoms

Purchase Price Variance Report runs into error with following message:

MSG-00001: Wip Installation status is I
ORA-01476: divisor is equal to zero
' || MCA.SEGMENT5 , MSI.SEGMENT1 , msi.description , pov.vendor_name ,
poh.segment1 , papf.full_name , poh.currency_code , round (
mmt.primary_quantity , : P_qty_precision ) , msi.primary_unit_of_measure ,
round ( ( nvl ( mmt.transaction_cost , 0 ) ==> /


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.