Purchase Order > Funds Check: Conversion Date Defaults Based On Database Date. If A Future Currency Rate Is Not Set Up, Funds Check Fails And An Error Message Is Returned: Missing Currency Conversion (Doc ID 2271640.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Purchase Order > Funds Check

Conversion Date Defaults Based On Database Date (UTC Timezone). If A Future Currency Rate Is Not Set Up, Funds Check Fails And An Error Message Is Returned


ERROR
-----------------------
Missing Currency Conversion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a purchase order as follows:

The purchase order is created in 9/01/2017 at 20:21 CST (user time)
Funds Check screen shows:
Conversion Rate = blanks
Conversion Rate Type = DOF
Conversion Date = 10/01/2017 > This is the database date/UTC timezone.

Date Information from Purchase Order

Purchase Order 17 - header:
Creation Date = 9/1/202017
Conversion Rate Type = DOF
Conversion Date = 9/1/2017
conversion Rate = 21.314

Purchase Order 17 - lines
Budget Date = 9/1/2017

Purchase Order 17 - schedules
Budget Date = 9/1/2017

Purchase Order 17 - distributions
Budget Date = 9/1/2017

Purchase Order 17 - distributions - conversion date
Conversion Date = 9/1/2017

2. Select Funds Status
Notice error:
Missing Currency Conversion


The time when this purchase order was entered shows 8:21 pm (CST). All the dates point to 9/1/2017, but Funds Check screen Conversion Date shows a future date 10/1/2017.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms