My Oracle Support Banner

GL Journal File Based Data Import (FBDI) Rounds Up The Amounts When Loading The Data (Doc ID 1962704.1)

Last updated on AUGUST 13, 2022

Applies to:

Oracle Fusion General Ledger - Version 11.1.8.0.0 and later
Oracle Fusion General Ledger Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
------------------
GL Journal FBDI rounds up the Amounts when loading the data

The GL Journal FBDI rounds up the amounts when loading the data into Oracle. This causes a difference in the amount.
The amounts are balanced in the source Excel and in the FBDI, however when we load the data the tables get unbalanced amounts.

EXPECTED BEHAVIOR
--------------------
After will be generated csv and zip file through FBDI, all the amounts must be identical with the data source (xlsm file)

STEPS
------
The issue can be reproduced at will with the following steps:
1. Load data in FBDI file and save
2. Generate csv File
3. Import csv file in GL Interface
4. After import the journals are unbalanced

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
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.