My Oracle Support Banner

How to setup non-recoverable payment plan with sample data flow. (Doc ID 1084843.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Goal

Payment plans are an optional way to set up advance or deferred payments (sometimes referred to as draws) and to define minimum and maximum payments.

This document shows a test case scenario of the affect of applying a non-recoverable (the resource does not have to pay them back) payment plan to payrun worksheets. The data flow examples will demonstrate how the process works.

Data Scenario
Resource has a payment plan to pay a non-recoverable minimum of $250 each period.

System Profile Current Setting
OIC: Pay by Transaction = No
OIC: Reset Balances Each Year = Yes

Transactions Flow
1. Commission calculated for JUN-00 period is $100.
2. Create payrun for JUN-00 generates payment plan adjustment for $150 so total payment is $250.
    Payment Type  Payment Amount
    Commission              100.00
    Payment Plan            150.00
    Total Amount            250.00
3. Commission calculated for JUL-00 period is $1200.
4. Create payrun for JUL-00 with no payment plan since commission earned is greater than $250.
5. Commission calculated for AUG-00 period is -$20 (negative).
6. Create payrun for AUG-00 generates payment plan adjustment for $270 so total payment is $250.
    Payment Type       Payment Amount
    Commission             <20.00>
    Payment Plan           270.00
    Total Amount          250.00
7. Commission calculated for SEP-00 period is $110
8. Create payrun for SEP-00 generates payment plan adjustment for $140 so total payment is $250.
9. Commission calculated for OCT-00 period is $50.
10. Create payrun for OCT-00 generates payment plan adjustment for $200 so total payment is $250.
11. Commission calculated for NOV-00 period is -$380 (negative)
12. Create payrun for NOV-00 generates payment plan adjustment for $630 so total payment is $250.
13. Commission calculated for DEC-00 period is -$30 (negative)
14. Create payrun for DEC-00 generates payment plan adjustment for $280 so total payment is $250.
15. Commisison calculated for JAN-01 period is $10.
16. Create payrun for JAN-01 and since payment plan is no longer active total payment is $10.

Note: Throughout the transaction flow, the system does not generate any recoverable payment amounts.

View full screenshots and complete sql output data flow:  1211NonRecoverableTestCase.pdf

Solution

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
Goal
Solution

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