Upload Global Zone Forecast Workflow Does Not Populate zone_id in the MSD_DP_SCN_ENTRIES_DENORM Table (Doc ID 758238.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Demantra Demand Management - Version 12.0 to 12.0 [Release 12]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On R12 in Production:
Customer has discovered a issue in the Upload Global Zone Forecast workflow. When they run this
workflow the forecast records are inserted in the MSD_DP_SCN_ENTRIES_DENORM table, however zone_id field does not get populated. By debugging at the msd_dem_upload_forecast package, they have found an issue in the GET_LEVEL_COLUMN procedure.

The following portion of the code

ELSIF (p_level_name = C_ZONE)
THEN
x_group_table_id := 'ZONE_ID';

should replaced with

ELSIF (p_level_name = C_ZONE)
THEN
x_level_id_lkup_code := 'ZONE_ID';

version of the code we are running.

CREATE OR REPLACE PACKAGE BODY APPS.MSD_DEM_UPLOAD_FORECAST AS
/* $Header: msddemufb.pls 120.4.12000000.3 2008/04/15 11:31:53 syenamar noship $ */



STEPS
The issue can be reproduced at will with the following steps:
1. Login to Demantra worflow manager
2. Run the workflow Upload Global Zone Forecast workflow



.

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