Non-English Calendar Period Dimension Member Load Successful But No Data Loaded
Last updated on NOVEMBER 06, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
In Enterprise Performance Foundation Administrator, in the "English" language, when trying to load new non-English Calendar Period members using the Dimension Member Loader program, the Dimension Member Loader request completes successfully and indicates that all rows have been loaded successfully. However, the non-English Calendar Period rows have not been loaded and are still in the interface tables:
Additionally, the STATUS column in the interface tables does not contain any errors. STATUS is still "LOAD" in all of the interface tables.
- FEM_CAL_PERIODS_B_T contains 14 rows: Jan-06 thru Dec-06, Adj-06, and Year 2006.
- FEM_CAL_PERIODS_TL_T contains 14 rows for the Brazilian Portuguese language (PTB)
- FEM_CAL_PERIODS_ATTR_T contains 126 rows (9 attribute rows for each Cal Period row)
You log into the E-Business Suite in "English". You run the Dimension Member Loader program to load the rows. The request finishes successfully and the following is in the View log:
154 rows loaded successfully.
0 rows failed to load successfully.
(Note: 14 + 14+ 126 = 154)
However, all of the rows remain in the interface _T load tables with a status of "LOAD".
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