Function IPLS_USAGE.GETCONVERTEDCURRANDEXCHRATE Returns Up To 2 Decimal For Converted Currency (Doc ID 1543456.1)

Last updated on MAY 21, 2013

Applies to:

Oracle Media Intellectual Property Management - Version 3.3.18.0 and later
Information in this document applies to any platform.

Goal

Qn1:Oracle provided Function IPLS_USAGE.GETCONVERTEDCURRANDEXCHRATE returns up to only 2 decimal places. Our requirement is to get the converted currency up to 4 decimal places.
How to modify the function as per the above requirement.
 


Qn2:Even after enabling the BR as mentioned in Answer1 ,

Exchange rate is being populated up to 4 decimal digits, but exchange amount is getting populated up to 2 decimal digits only. So, customer is facing the issue. What is the reason behind it ?


 
Qn3:would Customer need to run below statements one time from custom schema or every time when they need to perform currency conversion?

-- BR based context
begin
execute immediate 'create or replace context
global_parameters_BR_'||substr(replace(:user,'-','_'),1,9)||' using
IPLS_GLOBAL_PARAMETERS accessed globally';
end;


-- Context for IPLS_APPLICATION_PROPERTIES
begin
execute immediate 'create or replace context
global_param_IPLS_AP_'||substr(replace(:user,'-','_'),1,9)||' using
IPLS_GLOBAL_PARAMETERS accessed globally';
end;
 

Qn4:What is the use case that requires customer to access the BR/function from a non-ipm user?
 

Solution

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