My Oracle Support Banner

Allocations Rules Are Taking A Long Time To Run (Doc ID 2403217.1)

Last updated on DECEMBER 20, 2019

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Capture Transactions-Define Allocations and Period Entries

ACTUAL BEHAVIOR
---------------
Allocation Performance - Allocations taking a long time to run

The customer has created allocation formula rules, that performs allocations across several dimensions, using all the member values of some of those dimensions. Both the Cost pool (Source) and the Basis are looping through the dimensions and segment values in the calculation. When running the generate Allocation job, the processes run for hours and needed to be cancelled. The customer is requesting assistance with reviewing the performance of the allocation processing. They want to understand why these allocations are taking an excessive amount of time to run.


EXPECTED BEHAVIOR
-----------------------
The Generate Allocation process should not take this long

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have an allocation rule design having the Range set as @Level0Descendants for 6 members out of 10 member.

2. Have the allocation rule validated, saved and deployed.

3. Run Generate Allocation for the rule.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot succeeded generating allocation rules, since the process runs for several hours.

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
References


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