AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules

Requirement

AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules

Application:

Oracle Fusion Payables Cloud Service – Version 11

Detail of issue

AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules

Eg: Invoice Header.Invoice Amount*CurrencyConversionGlobal.getRate(Invoice
Header.Invoice Currency Code,”USD”,Invoice Header.Invoice
Date,”NORM_DAILY”,0)
Conversion Rate Type: NORM_DAILY

Solution

Approval conversion rules calls GetRate() API, it expects Conversion_Type, but of we are passing User_Conversion_Type and the API will fail.

This is expected behavior. Note that for seeded rate types (say Corporate, Spot), Conversion_Type will be a string value

where for user defined rate types, Conversion_Type will be middle-tier sequence value.

Run below Query to get the Conversion_Type

SELECT CONVERSION_TYPE, USER_CONVERSION_TYPE
FROM    fusion.GL_DAILY_CONVERSION_TYPES
WHERE   USER_CONVERSION_TYPE = <‘Custom Exchange Rate Type’>

Rule Condition:

Invoice Header.Invoice Amount*CurrencyConversionGlobal.getRate(Invoice Header.Invoice Currency Code,”USD”,Invoice Header.Invoice Date,”<CONVERSION_TYPE from above query>”,0)

Note: Currency can be used as per requirement, in above condition USD is taken as example