Description

We're building an OTBI report using subject area: Procurement - Purchasing Real time, the requirement is to pull the PO amount in USD currency based on the exchange rate on PO creation date (exchange rate type is 'Spot'). We pulled column - Purchase Order Distribution Amount in US Dollar Currency, and US Dollar Conversion Rate. However the US Dollar Conversion Rate is always 1. 

We issued the SQL for the OTBI report and it shows that the "US Dollar Conversion Rate" is pulling for Corporate type and system date. How can we change it to Spot type and PO Creation Date?
( Trunc(SYSDATE) ) AS DAILY_RATE_CONVERSION_DATE,
( 'Corporate' ) AS DAILY_RATE_TYPE_CORPORATE

We raised SR 3-25364892221 : How to populate USD Amount in OTBI, and here is the feedback: 

The USD conversion intended to be used for OAL customer and not for all.
The current logic is if the conversion rate is null, we display as 1 which does not do any conversion rate but just display whatever document currency amount shows.
If user does not have corp type and no USD conversion available in GL_DAILY_RATES, we will not get the conversion rate and the amount displaying
for customer is just document currency value.
If user wants to see the USD, then in GL_DAILY_RATES, the conversion rate are required to be populated.

We need the ability to use another conversion type (Spot) to populate the conversion rate and on PO creation date. 

Use Case and Business Need

With this ability, business user can leverage the reporting functionality better by specify a conversion rate type (not has to be Corporate) and on a user-defined date (eg: PO Creation Date or PO Approval Date,not has to be system date). 

Original Idea Number: 0caa6fe8ba