Periodic Cogs Revenue Matching Report Error ORA-01476 ADD_DEFCOGSDATA (Doc ID 1338654.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms


On : 12.1.1 version, Reports Issues

When attempting to submit request:Periodic COGS Revenue Matching Report,
the following error occurs.

ERROR
-----------------------

ORA-19202:Error occurred in XML processing
ORA-01476:divisor is equal to zero in Package CST_RevenueCogsMatch_PVT Procedure ADD_DEFCOGSDATA




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.In Cost Management Responsibility>(M)View>Requests
Periodic COGS Revenue Matching Report

Legal Entity:
Cost Type:PAC-Cameo
Cost Group:CAMEO-COGS
Period:Jun-11
Sales Order Issue Date From:2011/06/01
Sales Order Issue Date To:2011/06/30
Display Matched Lines:No

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms