My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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]<CUbeName>/db/FUSION_APPS_GL_ESSBASE_APPID/Info(1003040)
Parallel dataload enabled: [1] block prepare threads, [1] block write threads.
Error Code:1003063
Msg and Log buffer:
[Tue Apr 10 11:18:41 2018]<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 buffer:
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.