My Oracle Support Banner

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

Last updated on JUNE 21, 2023

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

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
Goal
Solution


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