Cannot Open New Accounting Period Error(1003063) The input data is not in proper dimension order as in rule file [8-20] Error in ESS_Inc_Import_std call
(Doc ID 2385623.1)
Last updated on FEBRUARY 05, 2019
Applies to:Oracle Fusion General Ledger Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Close Accounting Period-Close Ledgers
When attempting to open an accounting period, the process ends in error and the process logs shows the error below.
[Tue Apr 10 11:18:41 2018]fa.oracleoutsourcing.com/<CUbeName>/db/FUSION_APPS_GL_ESSBASE_APPID/Info(1003040)
Parallel dataload enabled:  block prepare threads,  block write threads.
Msg and Log buffer:
[Tue Apr 10 11:18:41 2018]fa.oracleoutsourcing.com/<CubeName>/db/FUSION_APPS_GL_ESSBASE_APPID/Error(1003063)
The input data is not in proper dimension order as in rule file [8-20]
GL_SHRD0180: ESS_Inc_Import_std() - Performing action: Error in ESS_Inc_Import-EssImportASO.
Error code: 1003063
Error in ESS_Inc_Import_std call
The issue can be reproduced at will with the following steps:
1. Segment 8 has a value 20 which is taken in the cubes as [8-20]
2. The Calendar periods are defined as 'MM-YY' , in the cubes this dimension is defined as [8-20] (for the corresponding 8 month and year 2020 )
3. Any operation that requires an update to the cubes using this value will return an error since for the cubes we have a duplicate member ID 8-20.
The issue has the following business impact:
Due to this issue, users cannot open a period, post journals which is affecting their daily operations.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document