My Oracle Support Banner

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:

Oracle Web Applications Desktop Integrator - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
References


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