Unable To Generate STAT Currency Journal Using Mass Allocation Formula after upgrade to R12 (Doc ID 2033939.1)

Last updated on MARCH 13, 2017

Applies to:

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

Symptoms

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.


Changes

 Upgrade to R12

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