My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Service Contracts - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


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

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

Expected Behavior:
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.


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

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