Service Contracts Import Program Is Not Importing Covered Items (Doc ID 1450855.1)

Last updated on AUGUST 24, 2015

Applies to:

Oracle Service Contracts - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-14***

Symptoms

When attempting to import covered items using the Service Contracts Import program, the validation fails with following error.

Error:
Enter a valid value for one and only one type of covered levels.

Expected Behaviour:
Covered item should be imported if valid details are provided in interface table(oks_covered_levels_interface.covered_item_id)

What is working:
Covered item is imported if covered_item_name is populated instead of covered_item_id

Steps to reproduce:
1. Populate service contracts import interface tables with required columns (oks_headers_interface, oks_sales_credits_interface, oks_lines_interface, oks_covered_levels_interface)
2. In oks_covered_levels_interface, valid covered_item_id and covered_item_org_id is populated.
3. Leave all other covered level columns blank (covered instance, party, system etc)
4. Submit Service Contracts Import in Validate mode.
5. Check Service Contracts Import Report output. Error message "Enter a valid value for one and only one type of covered levels." is displayed in report
6. Populate covered_item_name as 'AS54888' instead of populating covered_item_id.
7. Submit Service Contracts Import in Validate mode.
8. Program has validated the covered item line. No errors in the report.

Cause

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