Home » Applications » Oracle Fusion Apps & E-Business Suite » OIC: Payment Plan - recoverable_flag question (Incentive Compensation)
icon4.gif  OIC: Payment Plan - recoverable_flag question [message #285803] Wed, 05 December 2007 12:47
Messages: 1
Registered: December 2007
Location: US
Junior Member
Hi All,

I'm looking for someone who has an Oracle Incentive Compensation implementation experience.
We are on Oracle - Implementing OIC.

Here is my question and issue that I face.
- There is a Sales Rep that has a Payment Plan
- The above payment plan has Recoverable Flag set to yes.
- His minimum amount on the payment plan = $1000
- He has underperformed in month of November (earned $500)
- His transaction is LOADED and CALCULATED.
- The Payrun created for the month of NOVEMBER
- And the Worksheet created for the above Payrun.
- Now when I perform the following query against the cn_payment_transactions, it displays the recoverable flag set to "No' for this Sales Rep INCENTIVE_TYPE_CODE = PMTPLN (DRAW).

select *
from apps.cn_payment_transactions ptrx
and ptrx.quota_id = qt.quota_id
and pay_period_id = 2007011

This is the issue - my expectation it shall be set to YES as per Payment Plan setup.

Please note - the above was a manual transaction that I created from Transactins -> Adjust tab.

Any suggestion / advice?
Thank you very much!
Previous Topic: ITEM KEY getting generated as #SYNCH
Next Topic: Loan Approval Report
Goto Forum:

Current Time: Fri Aug 18 20:59:10 CDT 2017

Total time taken to generate the page: 0.47873 seconds