Intermittent Essbase Error(1260046) When Running Allocate General Ledger Balances (Doc ID 2212655.1)

Last updated on DECEMBER 09, 2016

Applies to:

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

Symptoms

On : 11.1.11.1.0 version

An allocation rule is defined with a variable (run time parameter) for the Accounting Period.
The variable is used in the POV of the rule and when running the Generate Allocation program, the Period parameter is displayed and the period can be selected
from a list of values but sometimes the Allocate General Ledger Balances program ends in error.

ERROR
-----------------------
Error in Rule Execution. Cannot Perform Custom Calc. Essbase Error(1260046): Unknown Member Period_Name used in query


STEPS
-----------------------
1. Define an allocation rule that uses a variable for the accounting period
2. Submit the Generate Allocations program. It shows the variable for the period as a parameter.
3. Select the period from the LOV and submit the program. See that sometimes the program ends in error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms