Error ORA-20015 and ORA-06550 In Forecast Export From Demantra To ASCP (Doc ID 1276744.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Goal

When run the standard workflow to export forecast from Demantra to ASCP, I get an error in stored procedure step". The error states:
Process ID: 780900
Schema ID: 634
Schema name: ’’EBS Upload Local Forecast’’
Step ID: ’’PopulateDenormTable’’
Step name: ’’PopulateDenormTable’’

Error description ’’Database internal error:ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast_with_app_id - ORA-06550: line 1, column 16:’’


Customer had uploaded the following:
1. version history details
2. results from apscheck.sql
3. screen shots of the integration interface
4. screen shots of workflow
5. screen shots of error
6. Package and package body "apps.msd_dem_upload_forecast.upload_forecast_with_app_id"

No errors in the db_exception_log.

Solution

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