My Oracle Support Banner

Funding and Booking Amounts Discrepancy for Non-Functional Currency Contracts (Doc ID 2479489.1)

Last updated on DECEMBER 05, 2018

Applies to:

Oracle Lease and Finance Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 

 ACTUAL BEHAVIOR  
---------------

When a contract using a Foreign Currency is Funded on a date other than the Contract Start Date the the accounts converted amounts do not match for the Booking and Funding entries.

For example...

a. A contract starts on 15-Oct-2015 when the conversion rate between the currencies is 16.6145.

b. The same contract is funded on 01-Nov-2015 and the conversion rate is 16.6469.

 

Because of the Conversion Rate difference, Amounts do not match between the Booking and Funding Accounting Events.

This causes amounts to remain in a clearing account eternally.

STEPS

-----------------------

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

1. Create a contract in foreign currency, that is a currency other than functional currency.

2. Book the contract and booking accounting entries in transaction currency and functional currency are generated. Functional amount is calculated based on the conversion rate on date of booking.

3. Create funding for the contract on another day where the conversion rate is different to that of booking.

4. Check the accounting entries generated for funding the functional amount will not be same as the case with booking as Conversion rate is different on the Funding date.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot reconcile these amounts.

Changes

 

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