My Oracle Support Banner

R12: Purchase Requisition Unit Price Decimal Place Inconsistent (Doc ID 2676699.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Oracle Purchasing - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Requisitions

Requisition Unit price field in both foreign currency or base currency with inconsistent display decimal place format.
USD Unit price : USD 8,125.00
Converted HKD Unit price : HKD 63,600.0625
 
Rate type : Ask
Rate date : 2019/11/18
Exchange Rate : 7.8277
 
Quantity : 3
 
PR line amount in USD : USD 24,375.00
PR line amount converted in HKD : HKD 190,800.19


Expected Behavior

Expecting standardized display in 2 decimal places with thousand separator to improve readability.


Steps to reproduce:

1. Responsibility: Purchasing

2. Navigate to: Requisitions > Requisitions Summary

  Req. # XX-0001

3. Click Find.

Requisition Headers Summary:
  Requisition Lines Summary:

Line # 1, quantity = 3
Price = HKD 63,600.0625
Amount = HKD 190,800.19

4. Click Open

Requisition Summary to Requisitions:

Tab -> Currency

Base Currency price = HKD 63,600.0625
Foreign Currency price = USD 8,125.00

Exchange Rate = 7.8277


Note: Due to this issue, decimal places are showing beyond two.

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.