OGL EPF: Calendar Period Dimension Member Loader Not Working Correctly For Multi-Language Installation) (Doc ID 428409.1)

Last updated on OCTOBER 08, 2007

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.9 to 11.5.10
This problem can occur on any platform.
OGL EPF Data Integration
FEM.D.1 Rollup #2
FEM

Symptoms

With a multi-language install on 11i.FEM.D1 Rollup #2, the Dimension Member Loader program for Calendar Period is overwriting the DESCRIPTION column with the US Language Description and not maintaining the foreign language DESCRIPTION.  This is the only Dimension getting this behavior.  All other dimensions are working as expected.

For example:

Populating FEM_CAL_PERIODS_TL_T (Cal Period interface table) with the following:

CAL_PERIOD_END_DATE CAL_PERIOD_NUMBER LANGUAGE CAL_PERIOD_NAME DESCRIPTION CALENDAR_DISPLAY_CODE DIMENSION_GROUP_DISPLAY_CODE
06/30/1950 6 KO June 1950 Desc KO JUN-1950 Default Month
06/30/1950 6 US June 1950 Desc US JUN-1950 Default Month

Results in the following records in FEM_CAL_PERIODS_TL (Cal Period base table):

LANGUAGE SOURCE_LANG CAL_PERIOD_NAME DESCRIPTION comments
US US June 1950 Desc US JUN-1950 English record
KO US June 1950 Desc US JUN-1950 Korean language record does not have Korean desc

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