My Oracle Support Banner

Primary to Secondary Ledger Conversion Creates Zero Amount Journals from Non-Zero Foreign Currency Journals (Doc ID 2757767.1)

Last updated on MARCH 18, 2021

Applies to:

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

Symptoms

Two ledgers exist in the system, the context is as following:

Primary Ledger (PL) - Functional Currency is USD
Secondary Ledger (SL) - Functional Currency is USD
Conversion type is 'Journal'.  Account Specific Conversion Type: Not Enabled

Created a manual foreign currency (EUR) journal in the Primary Ledger. The entered amount in foreign currency(EUR) is zero, but in the functional currency(USD), converted amount is not zero.
On posting, a journal is created in the Secondary Ledger, but with all 0 amounts (both entered and accounted amounts).

This type of journal is unusual, but used at period/year end to record some gain-loss amounts.

 

STEPS TO REPRODUCE:

1. GL responsibility > Accounting Setup Manager > Identify Primary and Secondary Ledgers having the same functional currency

2. Journals > Enter > Create a Manual journal in foreign currency where the entered amount is zero but the converted amount is not zero

3. Post the journal

4. Verify the Secondary Ledger journal created by Posting, observe this shows all amounts as zero

 

SAMPLE JOURNALS:

 

Changes

 None

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
References


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