My Oracle Support Banner

Currency Conversion Rate Is Zero In Paysheet Table (Doc ID 1662032.1)

Last updated on NOVEMBER 05, 2016

Applies to:

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


On : version, Manage Incentive Comp

When calculating commission in USD, but the home currency for the participant may not be USD. In the paysheets table.
See home currency captured based on the participant home currency.
But the conversion rate is always showing as zero.

I verified in the table cn_tp_paysheets_all  and also from pay sheet subject area  in OTBI.

Payment amount should  be converted

The issue can be reproduced at will with the following steps:
1. From Setup and maintenance > Implementation Project > retrieve task :  Manage Currency Conversions
    > enter fixed rates (for 2 years between base currency (USD) and any other existing currency (see snapshots)
2. Manage Transaction > Calculation process complete successfully
3. Manage Payment no conversion is done (ie conversion rate is always showing as zero.)

The issue has the following business impact:
Due to this issue, users cannot convert payment  for participants in their home currency.



To view full details, 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 a vibrant support community of peers and Oracle experts.