Service Contracts Import Program Cannot Process Non-Quota Sales Credit If More Than 100%

(Doc ID 1282510.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 12.1.2 and later
Information in this document applies to any platform.
Executable:OKSIMPRT - Service Contracts Import
***Checked for relevance on 8-Oct-2014***


The Service Contracts Import program completes with the following error when the Non Quota Sales Credit has a value of over 100% for a single line.  The Forms application allows a contract to be activated with Non-Quota Sales Credit of > 100% for a single sales credit line (although Quota Sales Credit can only add up to a total of 100% for all lines).

'Enter a value between 0 and 100 for percent.'

Steps to reproduce:
1. Create service contract import data in the import interface tables where in OKS_SALES_CREDITS_INTERFACE there is a line where 'PERCENT' is > 100 for Sales_Credit_Type = 'Non-quota Sales Credit'.
2. Run the Service Contracts Import program for the contract.
3. Review the Service Contracts Import Report program output
- will see the error:
OKS_SALES_CREDITS_INTERFACE 61 Enter a value between 0 and 100 for percent.


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 hundreds of Community platforms