Seeded Program "Publish Forecast To Source System" Not Publishing Forecast To JDE (Doc ID 2100081.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Oracle Value Chain Planning Integration Base Pack - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version, LoadData

ACTUAL BEHAVIOR
---------------

Seeded program "Publish Forecast To Source System" doesn't publish demantra forecast to JDE on an E1-Demantra integrated environment.
When running the standard program "Publish Forecast To Source System", the program is generating 0 bytes Forecast.txt file.
When running only the workflow "AIA-Forecast_upload", then the file is getting created with data.

There is no error message in the request log or request output files:

Request Log :
+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
MSCE1FSS: Publish Forecast To Source System

+---------------------------------------------------------------------------+
12-OCT 17:12:27 : ODI Scenario PREPROCESSHOOKPKG execution is successful.
12-OCT 17:12:51 : ODI Initializion is successful
DEM WORKFLOW LAUNCHED.Process Id:784739
DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY
12-OCT 17:14:53 : ODI Scenario EXPORTFILESFROMDEMANTRASERVER execution is successful.
12-OCT 17:14:54 : ODI Scenario LOADDMFORECASTDATATOE1PKG execution is successful.
12-OCT 17:14:54 : ODI Scenario POSTPROCESSHOOKPKG execution is successful.
12-OCT 17:14:55 : ODI Scenario MAIL execution is successful.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested. Output file size: 665
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 12-OCT-2015 17:14:55
+---------------------------------------------------------------------------+

 

Request Output :
msd_dem_demantra_utilities.set_demantra_schema: the demantra schema is DV
Exiting
msd_dem_demantra_utilities.set_demantra_schema 12-OCT-2015 17:12:27
Exiting msd_dem_demantra_utilities.get_demantra_schema 12-OCT-2015 17:12:27
Entering: MSC_E1APS_UTIL.DEM_WORKFLOW - 12-OCT-2015 17:12:51
SELECT
utl_http.request('http://demantra:port/demantra/WorkflowServer?action=run_proc&user=dm&password=xxx&schema=AIA-Forecast_Export&sync=no')
FROM dual
Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - 12-OCT-2015 17:12:51
Exiting msd_dem_demantra_utilities.get_demantra_schema 12-OCT-2015 17:12:51

 



EXPECTED BEHAVIOR
-----------------------
Seeded program "Publish Forecast To Source System" should publishing forecast to JDE and generate the Forecast.txt file with data.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Advanced Supply Chain Planner responsibility.
2. Run Publish Forecast To Source System request.
3. Data is not publish back to E1.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot publish forecast to JDE. This is impacting the overall solution design for first roll out.

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