Essbase Error(1260046): Unknown Member XYZ used in queryValue for XYZ variable is not set. Please select the value from XYZ variable list of values and re-submit (Doc ID 2944554.1)

Last updated on JULY 23, 2023

Applies to:

Symptoms

On : 11.13.23.01.0 version, Period Close Setup & Processing

When attempting to run a custom ESS job set with 22 jobs for allocations, after selecting the rule and period in parameter for each block some processes erroed and other end successfully. The processes ending in error show the error below. When the rule failing in the logs is executed alone outside the job set the process ends successfully.

Aborting execution due to failure of JobExecuteAllocationsWith request ID: 1234567
Rule ABC execution failed while executing component number 1 due to following error ::Cannot Perform Custom Calc. Essbase Error(1260046): Unknown Member Acc_Period used in queryValue for Acc_Period variable is not set. Please select the value from Acc_Period variable list of values and re-submit.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have 22 allocation rules running properly when run independently
2. Create a custom ESS job set in parallel.
3. Run the custom ESS job and pass the rule and period

Cause

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