Demantra Download Calendars Not Downloaded Into T_EP_FISCAL_MONTH Table (Doc ID 1396498.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 01-November-2013***

Symptoms


On : 7.3.1 version, LoadData

ACTUAL BEHAVIOR
---------------
Run Demantra Download Calendars, fiscal calendars not loaded into t_ep_fiscal_month and t_ep_fiscal_quarter tables.

EXPECTED BEHAVIOR
-----------------------
The user should able to download the calendars from EBS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run ASCP collection for fiscal calendar. Validated data collected in msc_calendar_months.

2.Set up Demantra Calendar List = 'TST:Calenda'

3.Set up profile 'MSD_DEM: Fiscal Calendar' = 'TST:Calenda'

4. Run 'Download Calendars', it completed normal. But fiscal calendar not loaded into Demantra

5.Output file shows no calendar_code passed intoD XX.Integration_1_Load_Calendars('') procedure:

In Procedure: COLLECT_TIME_DATA
MSD Schema: MSD
truncate table MSD.msd_dem_time
begin XX.Integration_1_Load_Calendars(''); end;

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