My Oracle Support Banner

Common Problems and Solutions for Setup Financial Reporting Structures (Doc ID 1404368.1)

Last updated on JUNE 26, 2023

Applies to:

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


This document provides troubleshooting steps for setup issues related to the deployment of the accounting flexfield and the publishing of account hierarchies which are financial reporting structures.

Troubleshooting Steps

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
Troubleshooting Steps
 Problem Catalog
 Problems & Solutions
 1. Accounting flexfield deployment failed
 2. Mandatory chart of account value attributes are not displayed for value set values.
 3. Tree version audit process failed.
 4. Account hierarchies information as viewed in or processed by Oracle Fusion General Ledger is not consistent with the tree definition.
 5. Versions of the account hierarchy are not properly propagated to the Essbase General Ledger balance cubes.
 6. Account values and hierarchies published from DRM (Data Relationship Manager) are not reflected properly in Oracle Fusion General Ledger or the Essbase General Ledger balances cubes and there are inconsistencies between what is seen in these applications and the master hierarchy definition.
 7. Request errors for Publish Account Hierarchies submission using the Publish Account Hierarchies page or the Publish Chart of Accounts Dimension Members and Hierarchies program (buildCOADimensions) via ESS request submission.
 8. Enabled or disabled flexfield security policies are not in effect for Essbase GENERAL LEDGER Balances cube. 
 9. Need a new accounting scenario member for budgets.
 10. New accounting scenario dimension members are missing- for example: budgets or forecasts- from the Essbase General Ledger balances cube.
 11. Publish Chart of Accounts Dimension Members and Hierarchies Ess job not updating the hierarchy in the Essbase General Ledger balances cube when it is submitted outside of the ESS UI.

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