Unable To Publish Account Hierarchy After Updating CoA Value Set Value Description (Doc ID 2513242.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Goal

On : 11.13.19.01.0 version, Financial Reporting and Analysis

Unable to publish account hierarchy after updating CoA value set value description

After updating the description for a value in the account segment of the chart of accounts, user is no longer able to publish chart of accounts hierarchy via the Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes and Update Chart of Accounts Dimension Members and Hierarchies processes.

Both processes ended in error and returned similar error logs.

The most relevant part of the Publish Chart of Account Dimension Members error log:
"validate_dimmemberalias_naming --> Start Time 2019-02-28 17:59:14.214257

validate_dimmemberalias_naming --> Detecting conflicts for coaId: 1XX1 and calendar:

IN Clause for Skipping values: 'EXP','ALL'

IN Clause for Skipping special values: 'EXP'

validate_dimmemberalias_naming --> COA Id: 104XX1;COA Ins Id: 1YY1;COA Str Id: 1XX1;"


The most relevant part of the Publish Chart of Account Dimension Members error log:
"updateCOADimensions: Publish function failed for coa: Actuals :: 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.

validate_Period_MemID_Conflict --> Start Time validate_Period_MemID_Conflict 2019-02-28 17:59:16.681800

validate_Period_MemID_Conflict --> Detecting conflicts for coaId: 1XX1 and calendar: 30000000XXXXX01

validate_Period_MemID_Conflict --> COA Id: 1XX1;COA Ins Id: 1YY1;COA Str Id: 1XX1;

validate_Period_MemID_Conflict --> period_set_name: Actuals; period_type: MONTH9942XXX840"
 

Solution

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