My Oracle Support Banner

An Analysis With A Hierarchy Fails With: The Property Account.Sort Order Is Missing (Doc ID 2830342.1)

Last updated on JANUARY 03, 2022

Applies to:

Oracle Analytics Cloud - Version 106.3.0 and later
Information in this document applies to any platform.


A Data Model (RPD) was developed after importing Metadata from FCCS (as per: Build and Upload a Data Model from Cloud EPM Platform) and deployed in Oracle Analytics Cloud (OAC).

When an Analysis is created that includes attribute columns from a hierarchy (for example: Account Name, Period Name, Entity Name, etc.), the results are returned in a Table view as expected.

When adding the hierarchy / hierarchical column (for example: Account, Period, Entity, etc.) - which will return results in a Pivot Table view - or on adding other views to the analysis, the following errors may be encountered:

* See a pop up window with the message: The query was canceled

* See the following error is thrown: [nQSError: 43119] Query Failed: The property "Account.Sort Order" is missing from the query results


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.