My Oracle Support Banner

Journals Cannot Posted Due to Refresh Balances Program Failing (Doc ID 2767086.1)

Last updated on MAY 18, 2021

Applies to:

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


When attempting to Post journals this process was unsuccessful as the customer's cube was having issues with the current balances


Refresh Balances program has failed for ledger name = <CUBE NAME> .... Error::DeltaRowDelFailed
Refresh Balances program has failed... Error::DeltaRowDelFailed
Releasing Root AM...
-> Start of function GL_ESSBASE_UTILITY_PKG.isFeatureRequired <> p_lookup_type: ORA_GL_PROMOTIONAL_OPTIONS, p_fix_name_lookup_code: GL_PROMO_30804671, p_feature_default_option: N, p_Release_sequence: 9999

The issue can be reproduced at will with the following steps:
1. Post journal
2. See journal completed in error
3. Run create balances cube job


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.