Error ORA-20015 and ORA-06550 In Forecast Export From Demantra To ASCP
(Doc ID 1276744.1)
Last updated on MAY 24, 2022
Applies to:Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
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.
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