My Oracle Support Banner

GLAMAS Mass Allocation Formula Using STAT Balances Not Generating Expected Allocations (Doc ID 2653464.1)

Last updated on JUNE 17, 2020

Applies to:

Oracle General Ledger - Version 12.1 and later
Information in this document applies to any platform.


Newly defined mass allocation formula using STAT currency in B and C lines is not generating the expected allocation journal results.

Both the total value being allocated and the values for each account are not as expected.

This is a new mass allocation and has not worked in the past.
Other mass allocations previously defined are working fine and do not use STAT currency data in the formula.

Steps to recreate the issue:
1) Defined a new allocation batch -
Formula                                                                                   Ledger Currency Entered   Amount
Line      Account                                                                       Currency Type    Currency Type
------ -------------------------------------------------                      -------- --------   --------    ------
A        LedgerA.110.500001.1001.000000.000.000.00000000.00 USD       Total                   PTD
*        C.C.L.L.C.C.C.C.C.C
B        LedgerA.101.500001.1001.000000.ALC.000.00000000.00 USD    Statistical STAT      PTD
/        C.L.L.L.C.C.C.C.C.C
C        LedgerA.101.500001.1001.000000.ALC.000.00000000.00 USD Statistical    STAT      PTD
Target LedgerA.101.500001.1001.000000.ALC.000.00000000.00                                        PTD
Offset LedgerA.110.500001.1001.000000.ALC.000.00000000.00                                        PTD

2) Validate the formula.

3) Make and post journals to the period needing to be allocated (USD and STAT).

4) Generate the allocation for the period run as full allocation.

5) Review the allocation journal and the journal created is not what is expected, either in total or by individual line.


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.