My Oracle Support Banner

Payment Transactions Using Wrong Currency Conversion Rate With Pay Date (Doc ID 2675775.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.20.01.0 and later
Oracle Fusion Incentive Compensation - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

The payment batch has Pay Date = 5/31/20 but some payment transactions have currency conversion rates from next period ( June 2020 ) .

STEPS
1. Manage Parameter  
         Functional Currency = USD
         Payment Conversion Rate Type = My-Rate-Currency-Conversion
         Payment Conversion Date = Pay Date
         Home Currency = Pay Date
2. Manage Incentive Currency Conversions :
    Rate Types = My-Rate-Currency-Conversion
         USD to EUR 6/1/19 - 5/31/20   0.848
         USD to EUR 6/1/20 - 5/31/21   0.8928
3. Participant = Rep1
         Role Assignment : Participant Role  1/1/18 - no end date
         Compensation Plan : My-Comp-Plan   6/1/19  -  5/31/21
         Effective Start Date        Effective End Date      Home Currency
         1/1/18                          null                            EUR
4. Create payment batch "Jun-20 Payment" 
        Pay Group = Pay Group 1, Period = JUN-20, Pay Date = 6/30/20
        Paysheet shows :
                source_trx_number = Trx1
                source_event_date = 2020-04-30
                pay_amt_home_curr = 2232
                home_currency_code = EUR
                pay_to_home_curr_cnvrt = 0.8928 --- correct rate for 6/30/20 ( based on conversion rate on Pay Date ) 
                pay_amt_pay_curr = 2500
                pay_currency_code = USD
5. Delete payment batch because wanted to create the payment batch in prior period ( MAY-20)
6. Create payment batch "May-20 Payment" ,
        Pay Group = Pay Group 1, Period = MAY-20, Pay Date = 5/31/20
        Paysheet shows :
                source_trx_number = SYM-Trx1
                source_event_date = 2018-03-31
                pay_amt_home_curr = 2232  --- incorrect, should be 2500 X 0.848 = 2120
                home_currency_code = EUR
                pay_to_home_curr_cnvrt = 0.8928 --- still the same , should be 0.848 ( based on Pay Date 5/31/20 )
                pay_amt_pay_curr = 2500
                pay_currency_code = USD

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.