Shipment And Booking Collections Failing After Installing Demantra 7.3.0.1 with Error ORA-06502: PL/SQL: numeric or value error (Doc ID 1252174.1)

Last updated on APRIL 15, 2013

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

PROBLEM
-------------
Recently installed Demantra 7.3.0.1. When using Demantra 7.3 the Shipment and Booking collections was working smoothly but since the time they have installed Demantra 7.3.0.1 the collections is failing due to Error :

Booking and history collection is erroring in Launch EP_LOAD step.

 **Starts**01-OCT-2010 09:38:26
 **Ends**01-OCT-2010 09:38:26
 ORA-06502: PL/SQL: numeric or value error



STEPS
--------
ASCP -> Sales and Operations Planning System Administrator -> Collections -> Oracle Systems -> Shipment and Booking History



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