GL_INTERFACE.CURRENCY_CONVERSION_RATE Field is Truncated to 10 Decimal Points after WebADI Data Upload Using 'Foreign Actuals - Multiple' Template for the 'General Ledger - Journals' Integrator (Doc ID 3009974.1)

Last updated on JUNE 11, 2024

Applies to:

Symptoms

The user wants to upload General Ledger Journal information with foreign currency records using WebADI template upload. The user wants to load records with currency conversion rate with more than 10 decimal points.
The issue is that, the 'CURRENCY_CONVERSION_RATE' field's data is truncated to 10 decimal points at the GL_INTERFACE table after a WebADI journal upload using the standard 'Foreign Actuals - Multiple' Template for the 'General Ledger - Journals' Integrator.

The issue can be reproduced at will with the following steps:

1.Navigate to Desktop Integrator responsibility>Create Document
2.Download and Save General Ledger - Journals integrator with layout as 'Foreign Actuals - Multiple'.
3.Load data into the 'General Ledger - Journal Foreign Actuals - Multiple' WebADI template with 'Currency_Conversion_Rate' having data with decimal precision points more than 10.
4.Review CURRENCY_CONVERSION_RATE field in GL_INTERFACE to discover that the data is truncated to 10 decimal points.

Cause

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