My Oracle Support Banner

R12: When using Same Functional Currency in Requisition and Create an Award from the Requsition, conversion rate used is the one from the header and not the current conversion rate. (Doc ID 2648598.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.7 and later
Information in this document applies to any platform.
PO_AUTO_DIST_PROCESS_PVT.plb

Symptoms

On : 12.2.7 version, Modifications

Currency Conversion Rate Issue:

There is an award with option lines. The currency on the award and backing requisition/s is not USD, so a currency conversion rate is applicable.

When the award is created the currency conversion rate at the time is stored on the award header. When trying to exercise an option line and fund it using a backing requisition,
there is no issue if the currency conversion rate at the time is the same as the one on the award header.

The issue occurs only if currency conversion rate is different.

The requisition uses the current conversion rate but when it is brought over onto the award the conversion rate used is the one from the header and not the current conversion rate.
This causes incorrect conversion from foreign currency to USD where the obligation amount on the award is different the amount committed on the requisition.

Note: The conversion rate value stored on the award is always defaulted onto any distributions that are created on the award.

The rate_type, rate_date and rate fields on the award header are editable only on award original.
It is not editable at the header level on a mod.  At the distribution level, for an award original these fields are editable.
But at the mod level, these fields are not editable if the dist has a backing requisition.

Users cannot exercise option lines on multi-year contracts which use foreign currency and the conversion rate is different then the one present at the time of creating the award.

Unable to use the option lines functionality in CLM.


Expected Behavior

The currency conversion used on the award to exercise the option line should be the current conversion rate and not the conversion rate from the time of award creation.


Steps to reproduce:

1. Responsibility: Purchasing, CLM

2. Navigate to: Buyer Work Center > Awards

3. Create a new Modification:
    Tab -> Modifications
    Modification # XXXP00001

4. Tab -> Headers

   Changed Amount = 10,000.00 PHP
   Changed Undefinitized Amount = 0.00 PHP
   Total Change in Fund Value = 22.22 USD

5. Tab -> Lines

6. Update Line 0002

Getting Error:
Funded Value - Line 0002, Schedule 1, Distribution 1 - Funded value cannot be greater than distribution's total order value.

Fund Value = 22.2222222222222
Line 0002, Schedule 1, Distribution 1 - Funded value cannot be greater than distribution's total order value.

Tab -> Awards -> Awards

Error:
=====
1. Funded Value - Line 0002, Schedule 1, Distribution 1 - Funded value of the PO distribution is greater than its corresponding Requisition distribution.
2. Funded Value - Line 0002, Schedule 1, Distribution 1 - Backing Purchase Requisition of the PO distribution does not have sufficient funds.

Error:
======
1. Warning: Line # 0002, Shipment # 1, quantity (10000) does not match distribution quantity (1000).
2. Row 2 Distribution - Error: Funded value cannot be greater than distribution's total order value.

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.