Error(1003014) Unknown Member and Update Balances Cubes Chart of Accounts Fails: Essbase Error(1007083): Dimension build failed. Error code [1090003] (Doc ID 2137757.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion General Ledger - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Close Accounting Period-Close Ledgers

New values were added to a value set for a segment in the chart of accounts, after this, the Flex fields are deployed and the process 'Update Balances Cubes Chart of Accounts Dimension Members and Hierarchies' submitted, but the job ends with error Essbase Error(1007083). When trying to Open a GL period fails with Error Code:1003014, since the new dimensions were not successfully added to the cubes.The Key Flex Fields shows that for a segment of the Chart of Accounts the name, description and short prompt do not match the segment code, which is used as a default when the account configuration is uploaded from excel. For example, if a segment code is Local_Product, the name, description and short prompt will have the same value.

Accessing the Inquire and Analyze Balances from Financial Reporting Center also shows error: Essbase Error(1260046): Unknown Member 'Segment Name' used in query. The 'Segment Name' matches the name for the segment changed after the account configuration was submitted.

ERROR
-----------------------

*** Log for Update Balances Cubes Chart of Accounts Dimension Members and Hierarchies job:
.......
buildGen2DetailedlevelNode(): Exception :: Cannot incremental build. Essbase Error(1007083): Dimension build failed. Error code [1090003]. Check the server log file and the dimension build error file for possible additional info.
.......
#################################### UpdateCOADimension :publishTreeVerCall End and took 120.856 Seconds############################
updateCOADimensions: Publish function failed for coa: 'Customer Data' :: Error: Cannot incremental build. Essbase Error(1007083): Dimension build failed. Error code [1090003]. Check the server log file and the dimension build error file for possible additional info.
Releasing Root AM...

 

*** Log for Open Next GL period:

......
Error Code:1003014
Msg and Log buffer:
[Fri Apr 29 13:06:21 2016]bi.oracleoutsourcing.com/ 'Customer Data' /db/FUSION_APPS_GL_ESSBASE_APPID/Error(1003014)
Unknown Member ['Segment Number' - 'Value'] in Data Load, [226] Records Completed
Missing Dim Mbr:['Segment Number' - 'Value']
GL_SHRD0180: ESS_Inc_Import_std() - Performing action: Return from this module and Call Dimension Maint Program .

Error code: 1003014
Error buffer:
Error in ESS_Inc_Import_std call

 

*** Trying to access the Inquire and Analyze Balances from Financial Reporting Center shows error

Cannot perform cube view operation. Essbase Error(1260046): Unknown Member 'Segment Name' used in query.

 

STEPS

1. After account configuration was submitted, change the segment name, description and short prompt.
2. Add new values to the value set used by a segment changed in step 1.
3. Deploy Flexfields.
4. Run the Update Balances Cubes Chart of Accounts Dimension Members and Hierarchies and the job fails with error: Essbase Error(1007083): Dimension build failed. Error code [1090003].
5. Open a GL period and the job fails with error: Error(1003014) Unknown Member ['Segment number' - 'Value'] for the segment used in step 1.
6. Access the Inquire and Analyze Balances from Financial Reporting Center show error : Cannot perform cube view operation. Essbase Error(1260046): Unknown Member 'Segment Name' used in query. The 'Segment Name' matches the name for the segment changed in step 1

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