My Oracle Support Banner

Translation Creates Balances for Asset/Liability Account Even if Net Functional Balance is Zero (Doc ID 2418619.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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


Translation is creating balances even for disabled Asset, Liability accounts having net activity/balance for functional currency = 0.

Balances created are equal on DR / CR so there is no impact, still GL_BALANCES table is affected for these codes influencing customizations. Some standard reports (eg. Trial Balance) run for the translated currency show activity (DR = CR) for accounts where there is no activity in functional currency similar report.

Expected for Translation to skip such accounts since there is no data to be translated.

The issue can be reproduced at will with the following steps:
1. GL Responsibility > Submit Translation process
2. Observe it creates data even for disabled accounts with no activity


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.