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 OCTOBER 17, 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

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
Changes
Cause
Solution


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