My Oracle Support Banner

Control Budget Successfully Uploaded Is Not Visible (Doc ID 2224793.1)

Last updated on NOVEMBER 12, 2019

Applies to:

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

Symptoms

Request to refresh the balances to the cube failed.

Data is not loaded because of missing members in the cube. To correct please do the following:

1. Run the Rebuild Budget Chart of Accounts Dimension ess program budgetary control cube name : XCC_ESMAdvisory and the followingBudget Chart of Accounts Dimension name(s):
  Budget Chart of Accounts Dimension: Account.

2. Run the Transfer Control Budget Balances to Essbase ess program the following control budget(s):
Control Budget - ESMAdvisory



trying to disconnect from cube
setErrorCode :: ERROR returned from XCC_PREPARE_CONTROL_BUDGET.post_essbase_err_handler_hook Procedure ::null
setErrorCode : Successfully Closed the callable statement
refreshBalancesFunction: Uploading data to Budget Cube failed... Error::Data is not loaded, because of missing dimension members. Please check the output file. Add them and re-submit the Refresh Balannces program.
Refresh Balances program has failed... Error::Data is not loaded, because of missing dimension members. Please check the output file. Add them and re-submit the Refresh Balannces program.
refresh balance -> finally, released the lock
Releasing Root AM...
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: BEGIN
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: p_controlbudget_id = 300000002717470
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: p_start_period_name = BUDGET_2017
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: l_periods.COUNT: 1
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: o_period_name ==('BUDGET_2017')
xcc.plsql.XCC_ESSBASE_UTILITY_PKG.pkb.refbal_get_budget_period_names: END
in post_essbase_err_handler_hook, p_control_budget_id=300000002717470, p_cube_id=300000004068774

Cause

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
Symptoms
Cause
Solution


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