The Earning Record Has Correct Commission Amount But the Credit Amount Is Incorrect ( ie. null, too high, too low ). (Doc ID 2999180.1)

Last updated on JANUARY 19, 2024

Applies to:

Symptoms

The earning record has correct commission amount but the credit amount is not correct ( ie. null, too high, too low ).

STEPS TO REPRODUCE:
1. Create a Per Interval Plan component ( eg. Annual interval with period payout )
2. Import transactions/credit $20500 for JAN-23 ( period_id 2023001 ) and $10000 for FEB-23 ( period_id 2023002 )
3. Calculate commission for full year
    Commission generated for JAN-23 is $500
    Commission generated for FEB-23 is $250
4. Import additional transactions/credit for $100 for FEB-23 ( period_id 2023002 ) and Calculation
    Commission generated for FEB-23.  The second transaction is not enough to hit the next tier so commission remains the same for $250
5. Using Simulation API to get estimate commission for MAR-23 and see that the credit amount for FEB-23 did not include the second transaction ( should be $10100 )

https://XXXX-YYYY.fa.us2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/incentiveCompensationCalculationSimulations/300000040517007/child/Earnings?fields=SimulationResultType,HomeEarningAmount,CreditAmount,HomeCurrencyCode,PayPeriodId,PlanComponentName,PlanComponentId&onlyData=true&limit=999

Simulation results shows :
line 271 :
{
"SimulationResultType": "SIMULATION",
"HomeEarningAmount": 500.00,
"CreditAmount": 20500,
"HomeCurrencyCode": "USD",
"PayPeriodId": 2023001,
"PlanComponentName": "Revenue 1 2023",
"PlanComponentId": 300000028323997
},

line 361:
{
"SimulationResultType": "SIMULATION",
"HomeEarningAmount": 250.00,
"CreditAmount": 10000,
"HomeCurrencyCode": "USD",
"PayPeriodId": 2023002,
"PlanComponentName": "Revenue 1 2023",
"PlanComponentId": 300000028323997
},

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.