My Oracle Support Banner

Cube Creation Child ESS Job Fails with 'There are other active users on database [db]' (Doc ID 2670073.1)

Last updated on MAY 14, 2020

Applies to:

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


On : version, Financial Reporting and Analysis

When attempting to Create balances cube one of the child process fails with the following error occurs.

buildCurrencyDimension(): Exception :: Cannot begin incremental build. Essbase Error(1013132): Cannot build dimensions. There are other active users on database [db]

Releasing Root AM...

The issue can be reproduced at will with the following steps:
1. Go to scheudal processes page
2. Run 'Create General Ledger Balances Cube' ESS job
3. Monitor the Job and child jobs, review the ESS Log file.

The issue has the following business impact:
Due to this issue, customer cannot use the cube for the postong and reporting purpose.


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.