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 and later
Information in this document applies to any platform.


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
execute immediate 'create or replace context
global_parameters_BR_'||substr(replace(:user,'-','_'),1,9)||' using
IPLS_GLOBAL_PARAMETERS accessed globally';

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

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


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