My Oracle Support Banner

Unable to Generate STAT Currency Journal Using Mass Allocation Formula After Upgrade to R12 (Doc ID 2033939.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


The Mass Allocation formulas were working correctly in 11i as well as 12.1.x and generating a STAT journal as needed. After upgrade to R12.x.x the STAT journal is not created, what is being created
is a journal in the functional currency of the ledger.


This can be replicated using a Mass Allocation formula similar to the following:
Mass Allocation Name  - Test for Stat
Category -  Adjusting
Currency -  STAT

A                           -01-000-1110-0000-000 Ledger Currency USD  currency type - Total Amount Type PTD
                            C      C     C       C      C

B   1
C  -1

T                           -01-000-1110-0000-000 Ledger Currency Greyed  currency type - Greyed Amount Type PTD
                               C      C     C       C      C

O                          -01-111-1110-0000-000 Ledger Currency Greyed  currency type - Greyed Amount Type PTD
                              C      C     C       C      C

When generated, this Allocation will create a USD journal and not a STAT journal as it did in 11i.


 Upgrade to R12


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.