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
Last updated on APRIL 12, 2018
Applies to:Oracle Fusion General Ledger Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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/XYZCOAInstance/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/XYZCOAInstance/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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms