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